# Deleted Items Count Between Two Dates

**URL:** https://forum.innovativeusers.org/t/deleted-items-count-between-two-dates/1214
**Category:** Polaris Repository
**Tags:** cp-migration, polaris-items
**Created:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/deleted-items-count-between-two-dates/1214 "2023-06-02T21:01:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://forum.innovativeusers.org/uploads/db7787/original/2X/8/8519ee8eef6492f310ea87d4ce482d931f01eef2.png) [@system](https://forum.innovativeusers.org/u/system)
#### Post date: [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/deleted-items-count-between-two-dates/1214/1 "2023-06-02T21:01:42Z")

</div>

# Deleted Items Count Between Two Dates

This is just a quick query that'll get you a count of items deleted between two given dates.

```SQL SELECT o.Name AS [Library], COUNT(DISTINCT th.TransactionID) AS [Total] FROM PolarisTransactions.Polaris.TransactionHeaders th WITH (NOLOCK)

LEFT OUTER JOIN  
PolarisTransactions.Polaris.TransactionDetails td WITH (NOLOCK) ON th.TransactionID = td.TransactionID  
INNER JOIN  
Polaris.Polaris.Organizations o WITH (NOLOCK) on th.OrganizationID = o.OrganizationID

WHERE  
th.TransactionTypeID = 3007  
AND  
td.TransactionSubTypeID = 38  
AND  
th.TranClientDate BETWEEN ‘2020-01-01 00:00:00.000’ and ‘2020-12-30 23:59:59.999’

GROUP BY  
o.Name  
ORDER BY  
o.Name

```auto

```