Sometimes a target environment may be configured with specific maximum size quotas, and it is helpful to know up-front which archives in an Enterprise Vault source environment are particularly large. This article explains how that might be determined.
The following SQL should be run on each source Vault Store database:
SELECT EME.MbxDisplayName "Mailbox Name", COUNT(S.ItemSize) "No. Items Archived", SUM(S.ItemSize)/1024 "Archived Item Size (MB)", SUM(SP.OriginalSize)/1024/1024 "Original Item Size (MB)" FROM dbo.Saveset S, dbo.SavesetProperty SP, dbo.ArchivePoint AP, EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME WHERE S.SavesetIdentity = SP.SavesetIdentity AND S.ArchivePointIdentity = AP.ArchivePointIdentity AND AP.ArchivePointID = EME.DefaultVaultId GROUP BY EME.MbxDisplayName ORDER BY  EME.MbxDisplayName
The output will be similar to this:

The query can be modified slightly to show only archives above a particular maximum size.

Print Friendly, PDF & Email