Dushan_Gomez
13 years agoLevel 6
How to know how much data that is older than 3 years archived by Enterprise Vault ?
Hi Everyone,
I need the SQL script to query my Enterprise Vault v8.0 SP4 that is older than 3 years. Can anyone share your SQL script to know how much disk in the vault it consumes that'd be great.
Thanks,
Actually nevermind, I didn't read the "older than 3 years" requirement
In which case it would beSELECT A.ArchiveName, COUNT(S.ItemSize) "No. Archived Items", SUM(S.ItemSize)/1024 "Total Size (MB) FROM yourVaultStore.dbo.Saveset S, yourVaultStore.dbo.ArchivePoint AP, EnterpriseVaultDirectory.dbo.Root R, EnterpriseVaultDirectory.dbo.Archive A WHERE S.ArchivePointIdentity = AP.ArchivePointIdentity AND AP.ArchivePointId = R.VaultEntryId AND R.RootIdentity = A.RootIdentity AND S.IdDateTime < DATEADD(year, -3, getDate()) GROUP BY A.ArchiveName ORDER BY A.ArchiveName