INFO: Obtain size of the items from Enterprise Vault

Overview

Sometimes it may be necessary to get a size of items from the Enterprise Vault prior the migration.

Enterprise Vault stores the size of an item in several places:

• Saveset table > ItemSize = Compressed size of the item
• SavesetProperty table > OriginalSize = The original size of the item from the mailbox

This query will get the item size from Enterprise Vault Database:

SELECT
‘Original Size (KB)’= SUM(SavesetProperty.OriginalSize) / 1024,
‘Compressed Size’ = SUM(CONVERT(BIGINT, Saveset.ItemSize))
FROM Saveset
INNER JOIN SavesetProperty ON SavesetProperty.SavesetIdentity = Saveset.SavesetIdentity
where
IdTransaction=’70c5be42-1b01-b11e-b4c0-aa4d9fc8ca41'