How to Calculate Enterprise Vault Size Licensing (4254986)

How to Calculate Enterprise Vault Size Licensing

For some people http://localhost/EnterpriseVault/usage.asp seems not to work, for whatever reason. This article gives a SQL script which can be used instead.

Here is a SQL script that lists all mailboxes with data volumes (Archived&Original) that people can use to determine their licensing requirements.  The first script provides a daily count of items archived:

The output is:
Archived Date, Mailbox Name, Provisioning Group, No of items archived, Archived item size (MB) and Original Items size (MB).

Note: Archive Shuttle is licensed on the Compressed size

Select the Vault Store Database in Management Studio on which to execute this script.
You will Need to execute it on every Vault Store Database. 

SELECT
left(convert (varchar, S.archiveddate,20),10) "Archived Date",
EME.MbxDisplayName "Mailbox Name",
PTG.DisplayName "Provisioning Group",
COUNT(S.ItemSize) "No. Items Archived",
SUM(S.ItemSize)/1024 "Archived Item Size (MB)",
SUM(SP.OriginalSize)/1024/1024 "Original Item Size (MB)"
FROM
dbo.Saveset S,
dbo.SavesetProperty SP,
dbo.ArchivePoint AP,
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
EnterpriseVaultDirectory.dbo.PolicyTargetGroup PTG
WHERE
S.SavesetIdentity = SP.SavesetIdentity
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointID = EME.DefaultVaultId
AND EME.PolicyTargetGroupEntryId = PTG.PolicyTargetGroupEntryId
GROUP BY left(convert (varchar, archiveddate,20),10), EME.MbxDisplayName, PTG.DisplayName
ORDER BY PTG.DisplayName, EME.MbxDisplayName
  

 The second script provides an overall count per archive
 
The output is:
Mailbox Name, No of items archived, Archived item size (MB) and Original Items size (MB).
 
 
SELECT
EME.MbxDisplayName "Mailbox Name",
COUNT(S.ItemSize) "No. Items Archived",
SUM(S.ItemSize)/1024 "Archived Item Size (MB)",
SUM(SP.OriginalSize)/1024/1024 "Original Item Size (MB)"
FROM
dbo.Saveset S,
dbo.SavesetProperty SP,
dbo.ArchivePoint AP,
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME
WHERE
S.SavesetIdentity = SP.SavesetIdentity
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointID = EME.DefaultVaultId
GROUP BY EME.MbxDisplayName
ORDER BY EME.MbxDisplayName
 
Output can be put in Excel and calculated for archives "eligible" for migration