Can I get total number of archived items per user in default EV10 web reports?

[BruGuy]

Hi there,

Is there a way, please, to get a report of the total number of archived items in and size of each user's vault from the default web reports in EV10 (the ones at /EnterpriseVault/ExchangeArchivingReports.aspx)? They seem to only list the number of archived items added in the last run.

We haven't installed EV Reporting Services yet, if there is a way to get the info above using the standard features that would be great. Can't imagine why it's missing from the default reports in the first place.

It's for Exchange 2010 mailbox archiving.

Thanks,

- Alan.

[TonySterling]

You can look at the usage report.  http://EVServerName/enterprisevault/usage.asp

You can save this report by archive name.

Starting Vault Store Usage Reporter

Article:HOWTO109101

|

Created: 2015-01-09

|

Updated: 2015-01-09

|

Article URLhttp://www.symantec.com/docs/HOWTO109101

[BruGuy]

Thanks a lot Tony. I'll try to figure out the link structure to the save as csv option and schedule a Powershell script.

[BruGuy]

Ummm, does anyone have please the list of parameters to pass to usage.asp to save the report by account to a TSV file (or better, csv) ?

Hovering over the link only gives me:

myserver/enterprisevault/listvaults.asp?tsv=true&vaultstoreeid=11223344EVSERVER&InfoLevel=2&AltServer=

It would save a lot of trial and error or sniffing. Much appreciated in advance.

[TonySterling · Accepted solution]

Can you use a SQL Query?  

--This gives the archive name and size of archive in MB
--Runs against the VaultStore 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