---
title: "How do I reset printer statistics so that printer pooling works correctly?"
slug: "how-do-i-reset-printer-statistics-so-that-printer-pooling-works-correctly"
updated: 2024-04-02T12:49:10Z
published: 2024-04-02T12:49:10Z
canonical: "kb.pharos.com/how-do-i-reset-printer-statistics-so-that-printer-pooling-works-correctly"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pharos.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

## Related

- [How do I reset the Signup Client?](/how-do-i-reset-the-signup-client.md)
- [HP Integrated Printer Readiness Guide](/hp-integrated-printer-readiness-guide.md)
- [How do I update the HP printer firmware with the Pharos HP iMFP software installed?](/how-do-i-update-the-hp-printer-firmware-with-the-pharos-hp-imfp-software-installed.md)
- [Konica Minolta Integrated Printer Readiness Guide](/konica-minolta-integrated-printer-readiness-guide.md)
- [Toshiba Integrated Printer Readiness](/toshiba-integrated-printer-readiness.md)