In SQL Query Analyzer, choose a vault store database and then do the following:
Use the following SQL query to show how much has been archived in a certain period as well as time the first and last items were stored during that period. Replace the dates and times in this example with those you want to use.
Select count(*),min(archiveddate),max(archiveddate) from saveset where archiveddate >'2002-04-26 18:00' and archiveddate < '2002-04-27 5:00'
Use the following SQL Query to obtain the number of different vaults processed in a specified period.
Select distinct(vaultidentity) from saveset where archiveddate >'2002-04-26 18:00' and archiveddate < '2002-04-27 5:00'
Use the following SQL Query to obtain the number of vaults with items stored in them.
Select count(*) from vault