Archive Shuttle Item Size (4270265)

Issue
Archive Shuttle stores reference information/metadata about archived items. This is obtained from the Enterprise Vault Vault Store database. One of the attributes which is stored is the size of the item. This note gives you information on what that size refers to.
Solution
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

 
Archive Shuttle stores the ItemSize from the Saveset table in the Item Database ‘Item’ table.
 
This query will help you to get the item size from Enterprise Vault DB.
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=’909B92C8-6CC8-4597-64C7-C31A3F732CC1'