11-09-2014 09:56 AM
We need to restore archived items for 300 users to Exchange 2010 as from 1-JAN-2012.
How can we calculate the vault size of each individual user, not the total size (this report exists), but the total size of vault items as from 1-JAN-2012.
We need this info to have an idea how much the excange database will grow.
Solved! Go to Solution.
11-09-2014 10:42 AM
run this query in SQL. replace VaultStore and "date" below with your parameters.
SELECT A.ArchiveName,
COUNT(S.ItemSize) "Item Count",
SUM(S.ItemSize)/1024 "Total Size (MB)"
FROM VaultStore.dbo.Saveset S,
VaultStore.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 > "date"
GROUP BY A.ArchiveName
ORDER BY A.ArchiveName
11-09-2014 10:42 AM
run this query in SQL. replace VaultStore and "date" below with your parameters.
SELECT A.ArchiveName,
COUNT(S.ItemSize) "Item Count",
SUM(S.ItemSize)/1024 "Total Size (MB)"
FROM VaultStore.dbo.Saveset S,
VaultStore.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 > "date"
GROUP BY A.ArchiveName
ORDER BY A.ArchiveName