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
Article Type
Technical Solution


Problem



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:


Solution



  • 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.

Use %VaultStoreName%

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


Terms of use for this information are found in Legal Notices