01-11-2010 06:41 AM
Solved! Go to Solution.
01-11-2010 11:06 AM
One thing you could do is the following
USE EnterpriseVaultDirectory
SELECT COUNT(DISTINCT(EME.DefaultVaultId) AS NumberOfUsers, SUM(S.ItemSize)
FROM EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
yourVaultStoreDB.dbo.Saveset S,
yourVaultStoreDB.dbo.ArchivePoint AP
WHERE EME.DefaultVauiltId = AP.ArchivePointId
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
few things to note:
- Only enabled users will have a DefaultVaultID in the ExchangeMailboxEntry table
- This will not work if the Vault Store DB and the EnterpriseVaultDirectory database exist on different servers
- It will give you the itemsizes and the user count per vault store, not per site
- ItemSize will give you the results in KB so you will have to do the /1024 if you want MB etc
- Also note that ItemSize is a rounded number, so an if items are 4.5kb and 3.5kb, it will report them as 5 and 4 respectively, thats a 1kb offset in that scenario
so you may have 12,000 users, but if you target a vault store that has 4000 users, it will only give you the user count and itemsizes for those 4000 users
you'd have to run another query (perhaps a union or subselect) and target the other vault store databases)
01-11-2010 07:08 AM
01-11-2010 07:57 AM
01-11-2010 08:19 AM
01-11-2010 11:06 AM
One thing you could do is the following
USE EnterpriseVaultDirectory
SELECT COUNT(DISTINCT(EME.DefaultVaultId) AS NumberOfUsers, SUM(S.ItemSize)
FROM EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
yourVaultStoreDB.dbo.Saveset S,
yourVaultStoreDB.dbo.ArchivePoint AP
WHERE EME.DefaultVauiltId = AP.ArchivePointId
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
few things to note:
- Only enabled users will have a DefaultVaultID in the ExchangeMailboxEntry table
- This will not work if the Vault Store DB and the EnterpriseVaultDirectory database exist on different servers
- It will give you the itemsizes and the user count per vault store, not per site
- ItemSize will give you the results in KB so you will have to do the /1024 if you want MB etc
- Also note that ItemSize is a rounded number, so an if items are 4.5kb and 3.5kb, it will report them as 5 and 4 respectively, thats a 1kb offset in that scenario
so you may have 12,000 users, but if you target a vault store that has 4000 users, it will only give you the user count and itemsizes for those 4000 users
you'd have to run another query (perhaps a union or subselect) and target the other vault store databases)