Steps to run the query:

1.  Launch the SQL Server Management Studio
2.  Expand the Databases container to display the list of EV databases
3.  Click New Query on the left upper right hand side of the window
4.  The current focus to execute the query defaults to 'master'.  Click on the down arrow and change the focus to the EV Vault Store hosting the Archives
5.  Enter the query below in the blank SQL query window and click Execute from the query menu.

SELECT DISTINCT a.ArchiveName, r.VaultEntryId, COUNT(hs.HoldIdentity) AS 'Item Count' FROM ArchivePoint AS ap JOIN HoldSaveset AS hs ON ap.ArchivePointIdentity = hs.ArchivePointIdentity JOIN EnterpriseVaultDirectory.dbo.Root AS r ON ap.ArchivePointId = r.VaultEntryId JOIN EnterpriseVaultDirectory.dbo.Archive AS a ON r.RootIdentity = a.RootIdentity WHERE ap.ArchivePointIdentity IN ( SELECT DISTINCT ArchivePointIdentity FROM dbo.HoldSaveset) GROUP BY a.ArchiveName, r.VaultEntryId;

The results of the query can be saved to a CSV file by right clicking on the first row and selecting "Save Results As".

Note: The above steps will require the assistance of an EV Administrator with SQL server query privileges.