|
|
|
The printer usage viewer can have additional customised reports added to it to support specific business needs. This is achieved by adding records to the Printer Usage Reports table:
| Report Name | Description | Query Definition | Restrict By Printer | Restrict By User |
| Pages printed by day and hour | Summarises the printer usage by day of the week and time of day | SELECT * FROM dbo.[PAGES PRINTED BY WEEKDAY AND HOUR] | 1 | 1 |
| Printed Documents (All) | List of all the documents printed on all the printers being monitored | SELECT * FROM [PRINTED DOCUMENTS] | 1 | 1 |
| Printed Documents (Todat) | List of all the documents printed today on all the printers being monitored | SELECT * FROM dbo.[PRINTED DOCUMENTS] WHERE (DATEDIFF(Day, Submitted, GETDATE()) <= 1) | 1 | 1 |
This is the unique name for the report. This is the name as it will appear in the drop down list of printer usage reports
This is additional information about the report
This is the definition of the query select statement (in SQL) that returns the data for the report
This is set to 1 if this report can be restricted by printer
This is set to 1 if this report can be restricted by user