original size when unarchived
I have looked at:
This points to two SQL queries in:
If I use the second query:
SELECT A.ArchiveName, COUNT(S.IdTransaction) "Num. Items Archived", SUM(S.ItemSize)/1024 "Archived Items Size (MB)", SUM(SP.OriginalSize)/1024/1024 "Original Email Size (MB)" FROM EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.Root R, yourVaultStoreDB.dbo.ArchivePoint AP, yourVaultStoreDB.dbo.Saveset S, yourVaultStoreDB.dbo.SavesetProperty SP WHERE S.SavesetIdentity = SP.SavesetIdentity AND S.ArchivePointIdentity = AP.ArchivePointIdentity AND AP.ArchivePointId = R.VaultEntryId AND R.RootIdentity = A.RootIdentity AND A.ArchiveName = 'your User' GROUP BY A.ArchiveName
I says for my account:
Archived Items 1107MB
Original Email size 1095
If I look in Exchange System Manager (Exchange Server 2003), it says: 155,805MB
I don't get these figures. I can't see why the Archived Items amount is larger than the original size and also it doesn't match the size Exchange is telling me.
In short; I would like to have a report that gives me the archived size in EV(so 'compressed') and what size it would take if we would export all EV archives to their original mailboxes.