Query to find Count of items archived between dates

From EnterpriseVaultFaq.com - Wiki

Jump to: navigation, search

Description

SQL Script Description
Script Purpose: Provides Count of Items for a specific Date Range
Description: Count of Items in a specific Date Range
Script Input: -
Script Output: Item Count
Tested on EV Versions: 7.5

Source 

--Vault Store name <Vaultstore>
--Date range to query
 
USE <Vaultstore>
SELECT count(*) FROM saveset
WHERE archiveddate > 'MM/DD/YYYY' AND archiveddate < 'MM/DD/YYYY'
Retrieved from "http://www.enterprisevaultfaq.com/wiki/Query_to_find_Count_of_items_archived_between_dates"