There are various options you have for reporting Number if items in archive and size of archive. Lets check these possibilities
Option 1
1. Go to VAC [Vault Admin Console]
2. From Admin Console go to Storage Group –> Store –>Right Click—> reporting
Option 2
Run below query against EV Store Database
SELECT ex.MbxDisplayName,
a.archiveditems as Count, (a.archiveditemsSize/1024) as 'Size'
FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize
Result looks like,
Option 3
In this option we talk about how we can automate the reporting. For example if you like to have the report send to you by mail then you can follow the below steps and get it done. In this option we utilize the reporting of EV,
1. First you would need to configure the report server for email delivery http://msdn.microsoft.com/en-us/library/ms345234(SQL.105).aspx
2. Once you have completed the above task you need to setup subscriptions to the bill usage report.
No comments:
Post a Comment