cancel
Showing results for
Did you mean:

How to calculate vault size of users as from specific date

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.

1 Solution

Accepted Solutions
Accepted Solution!

run this query in SQL.

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

Accepted Solution!

run this query in SQL.

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