---
title: "How to remove all the Transactions associated with a Printer."
slug: "how-to-remove-all-the-transactions-associated-with-a-printer"
updated: 2024-04-18T13:23:30Z
published: 2024-04-18T13:23:30Z
canonical: "kb.pharos.com/how-to-remove-all-the-transactions-associated-with-a-printer"
---

> ## 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 to remove all the Transactions associated with a Printer.

### Problem:

How to remove all the Transactions associated with a Printer and resource usages.

---

### Cause:

Resource usages are not removed along with transactions. They need to be purged manually.

### Solution:

This can be done using SQL Query Analyzer, by running the commands listed below:

----------------------------------

use pharos

```plaintext
select * from resource_usages
```

update resource_usages

```plaintext
set num_jobs = '0'
where ref_id = 'ID OF THE PRINTER'
```

update resource_usages

```plaintext
set num_units = '0'
where ref_id = 'ID OF THE PRINTER'
```

update resource_usages

```plaintext
set num_sheets = '0'
where ref_id = 'ID OF THE PRINTER'
```

----------------------------------

As an alternative to ref_id, you can use ref_type.

(where ref_type = 'P') - this will remove all resource usage records for all the printers.

## Related

- [Manually Remove 8.x Popups](/manually-remove-8x-popups.md)
- [Deleting packages from Administrator does not remove them from the Uniprint website](/deleting-packages-from-administrator-does-not-remove-them-from-the-uniprint-website.md)
- [What is Informed Print?](/what-is-informed-print.md)
- [Pharos Cloud Infrastructure Upgraded To Remove Vulnerability to Meltdown/Spectre.Other Services Not Directly Vulnerable. - June 2020](/pharos-beacon-infrastructure-upgraded-to-remove-vulnerability-to-meltdownspectreother-services-not-directly-vulnerable.md)