Customised printer usage reports

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

Report Name

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

Description

This is additional information about the report

Query Definition

This is the definition of the query select statement (in SQL) that returns the data for the report

Restrict By Printer

This is set to 1 if this report can be restricted by printer

Restrict By User

This is set to 1 if this report can be restricted by user