02-20-2013 03:02 AM
I need to confirm the following and need a pointer in the right direction:
Confirm the total email storage capacity currently stored in the Enterprise Vault deployment and confirm the compression ration on the archive.
Solved! Go to Solution.
02-20-2013 05:25 AM
02-20-2013 03:50 AM
If you search in the forum on 'archive size sql' you will find several scripts.
I use the below: Replace YourVaultStoreDatabase with the name of your VaultStoreDatabase
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,
YourVaultStoreDatabase.dbo.ArchivePoint AP,
YourVaultStoreDatabase.dbo.Saveset S,
YourVaultStoreDatabase.dbo.SavesetProperty SP
WHERE S.SavesetIdentity = SP.SavesetIdentity
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointId = R.VaultEntryId
AND R.RootIdentity = A.RootIdentity
GROUP BY A.ArchiveName
Also if you have EV reporting ( on a SQL reporting server), there are SIS reports.
02-20-2013 04:54 AM
Gertjan
Do I run this as an SQL query against the vault store database?
02-20-2013 05:25 AM
02-20-2013 05:27 AM
02-20-2013 09:02 AM
JesusWept3
we were asked the to confirm the following by third party:
Confirm the total email storage capacity currently stored in the Enterprise Vault deployment? i have checked the size of the vault store partitions folders on the SAN and they are 122GB and 60GB, however when running the report in the EV console vault store usage reporter it says total size of items 194MB.
confirm the compression ration on the archive? would this script provide that answer.