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:
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)"
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.