Syneticon Networks logo
Home | Kontakt | Sitemap 
 


Unternehmen | Lösungen | Projekte | News | Support 



Print Server Accounting for Windows 2000 and 2003 (en)


There are various commercial solutions for printer accounting and print server accounting available. These solutions are capable of maintaining accounts for users or groups and do a lot of fancy things. However, for simple cases where you just need to calculate the amount of pages printed within a range of time by different users, you can gain this information in a very efficient and easy way at virtually no cost by just using Windows and MS Excel.

How?

The basic idea here is that the Windows Printer Spooler will write specific events to the System Event Log if configured to do so:


Type:              Information
Source: Print
Category: None
Event ID: 10
Date: 02/14/2005
Time: 19:41:01
User: PORTABLE\denis
Computer: PORTABLE
Description: Dokument 3, Microsoft Word - Mail.doc owned by
denis has been printed over LPT1 to HP LaserJet 6P
Size in bytes: 26564; pages printed: 3

Evaluating this information over a certain period of time will enable you to get statistical information on your printers and print servers usage.

So what now?

Ensure that your spooler logs informative print events. You can find a short illustrative description on how to do this futher on in the "Spooler configuration"
Then, download the MS Excel Spreadsheet which has the appropriate code to read the event log and a pivot table to analyze the raw data.
You can download the digitally signed spreadsheet for Excel XP/2003 here .
When you open the spreadsheet, a dialog prompting for the server name to query will appear. When executed at the server in question, you can leave the default value (".") meaning "local host". When executed at a management station, enter the name or IP address of your print server instead and enjoy.

Spooler configuration

The Windows Spooler can be configured to log different kind of events. The "Printer" Control Panel has an item called "Server settings" in the "File" menu.
Menü Datei - Servereigenschaften
You can find logging configuration options in the "Enhanced" tab:
Servereigenschaften - Erweiterte Optionen
The options for errors and warnings are pretty obvious, the "spooler information" will log owner, printer and pages information which can be used for accounting and load analysis.

Remarks

  • Event log querying needs WMI to function, so the WMI service has to run on the queried host
  • The query is issued assuming integrated domain authentication, so the querying user has to have the privelege to read the system event log.
  • The VBA code basically will run on any Excel version beginning with Excel 97. However, the downloadable file is in Excel XP/2003 format due to code signing capabilities
  • Event log size is configurable but limited. Depending on your settings the log will either rotate or stop recording events after the limit is reached. So you are limited in the amount of events which are available for evaluation

Author

Created by Denis Jedig, inspired by a news thread.
Changelog:
  • 0.2 Using the InsertionStrings-Array (Thanks to Martin Resch)
  • 0.1 Initial version
Remarks, corrections and questions are welcome:
dj at syneticon dot net
.


  Home | Kontakt | Sitemap

   © 2002-2007 Syneticon Networks. Alle Rechte vorbehalten. | Datenschutzerklärung