HOW TO: Show number of items per folder in Enterprise Vault

Overview

From time to time it may be necessary to count the items per folder in a source archive. This can be achieved using the SQL given below.

Solution

In the Enterprise Vault Vault Store Database for the chosen archive issue the following SQL:

SELECT FolderName, COUNT(*) as ItemCount --, FolderPath
FROM [view_Saveset_Archive_Vault] a
INNER JOIN [EnterpriseVaultDirectory].dbo.ArchiveFolderView b ON a.VaultID = b.VaultEntryId
WHERE ArchivePointId = '14E72097B8240CB43A18DBB6AFCEE56D71110000rowi01-ev-01.rowiev.local'
GROUP BY FolderName

NOTE: The "ArchivePointId" can be found from the EVComplete UI or Vault Admin Console, by looking at the properties of the archive.