Forum Discussion

BruGuy's avatar
BruGuy
Level 6
10 years ago

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

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.

Enterprise Vault
Information Governance
Tip-How to
Windows Server (2003-2008)
  • TonySterling's avatar
    TonySterling
    10 years ago

    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

  • TonySterling's avatar
    TonySterling
    Moderator
    10 years ago

    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's avatar
    BruGuy
    Level 6
    10 years ago

    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's avatar
    BruGuy
    Level 6
    10 years ago

    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's avatar
    TonySterling
    Moderator
    10 years ago

    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