cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate vault size of users as from specific date

Hans_P_
Not applicable

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 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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

View solution in original post

1 REPLY 1

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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