Pages

Sunday, June 3, 2012

How to report Number of Archived Items and Size


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,
image
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