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









Thank you.