How to check in SQL for the total number of items archived for a particular archive
|Article:TECH194650|||||Created: 2012-08-09|||||Updated: 2012-10-22|||||Article URL http://www.symantec.com/docs/TECH194650|
At times it may be required to check the number of items which are archived to a particular user's archive. Follow the steps outlined below to achieve this objective:
Open the Enterprise Vault Administration Console.
Expand Directory - Site - Archives and select the relevant container where the archive resides.
Find the user for who you want to find out the number of savesets archived.
Double click on the archive.
Click on the Advanced Tab.
Copy the Archive ID value.
Launch Microsoft SQL Server Management Studio and run the below query to check the 'number of savesets' which have been archived for a particular archive.Note:- Replace %VaultStoreName% to the relevant database name of the vault store in your environment and replace %ArchiveID% with the relevant Archive ID copied previously.
select count(*) from saveset
where saveset.archivepointidentity = archivepoint.archivepointidentity
and archivepoint.archivepointid = '%ArchiveID%'
- The number returned is the amount of items currently archived within the archive.
Article URL http://www.symantec.com/docs/TECH194650