Download LogParser from Microsoft:
http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&DisplayLang=en∞

Use a command prompt, change to the log parser dir.

Run the following command:

LogParser.exe "SELECT SID AS User, SUM(TO_INT(EXTRACT_TOKEN(Strings, -1, '|'))) AS Pages INTO printouts.csv FROM \\<printserver>\System WHERE EventID=10 AND TimeGenerated>'<Lookup period>' GROUP BY SID ORDER BY SUM(TO_INT(EXTRACT_TOKEN(Strings, -1, '|'))) DESC" -resolveSIDs:ON -o:CSV

The file "printouts.csv" contains a list of user:print pages count.


CategoryHowTo