dorlow615
9 years agoLevel 4
Enterprise Vault SQL command to see usage for an archive?
We have our EV servers that are pointing to SQL servers for the database. When I want to see how much space a certain user is using in EV, I go to the EV server they're provisioned on and opened a w...
- 9 years ago
You could use this:
--This gives the archive name and size of archive in MB
--Runs against the VaultStore DatabaseSELECT ex.MbxDisplayName,
a.archiveditems as Count, (a.archiveditemsSize/1024) as 'Size'FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointIDWHERE ex.MbxDisplayName = 'My.User'
GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize