How do I reset printer statistics so that printer pooling works correctly?

My printer statistics need to be reset so that printer pooling works correctly, as one printer has a larger volume.

How can I reset printer statistics?

You can use the following SQL procedure to update the resource_usages table:

1. Open SQL Query Analyzer or OSQL.

2. Log on to SQL and switch to the Pharos Database.

3. Run the following query replacing the <insert printer name here> with the printer name in the Pharos Administrator:

   update resource_usages

   set resource_usages.num_jobs = 0, resource_usages.num_units = 0, resource_usages.num_sheets = 0

   where ref_type = 'D' and ref_id = (select device_id from devices where device = '<insert printer name here>')

4. Execute the query.

5. Restart the Print Server.