.gif){kind=logo}
|
Reminding Users About Reducing Printed PagesAug 10 2009 11:31AMDave Calabro
At TWC, we try to remind staff about reducing the amount of pages we print everyday. Part of this involves giving the user an actual number of pages that they have printed. Using Microsoft's utility called LogParser, we count the number of pages that the user has printed and we save that in our database. On our intranet we can then lookup that number and show the user how many pages they have printed.
Using this, users have more awareness of the impact on their printer use.
Tech Tip: Here's how we did it!
At TWC, we try to remind staff about reducing the amount of pages we print everyday. Part of this involves giving the user an actual number of pages that they have printed. Using Microsoft's utility called LogParser, we count the number of pages that the user has printed and we save that in our database. On our intranet we can then lookup that number and show the user how many pages they have printed.
Using this, users have more awareness of the impact on their printer use.
Tech Tip: Here's how we did it!
Download the LogParser utility and create a batch file on your print server with the following code in it. This will capture all printing events on your print server for the current day and store it to a database.
C:\logparser\logparser "SELECT TO_INT(TRIM(SUBSTR( Message, ADD(INDEX_OF(Message, '; pages printed: '), 17), SUB(SUB(STRLEN(Message), INDEX_OF(Message, '; pages printed: ' )), 17) ) )) AS PagesPrinted, SUBSTR( Message, ADD(INDEX_OF(Message, ' owned by '), 10), SUB(SUB(INDEX_OF(Message, ' was printed on '), INDEX_OF(Message, ' owned by ' )), 10) ) AS FileOwner,TO_STRING(TimeGenerated, 'MM-dd-yyyy') AS EventDate, RecordNumber AS ID FROM \\printserver\System TO tblPagesPrintedLog WHERE EventID = 10 AND EventDate=To_String(SYSTEM_TIMESTAMP(),'MM-dd-yyyy')" -o:SQL -server:DATABASE_SERVER_NAME -driver:"SQL Server" -database:Database_Name -username:DB_Username -password:DB_Password -createtable:OFF