Forum Discussion

DarthMaul's avatar
DarthMaul
Level 3
11 years ago
Solved

Running Reports from EV Server

Hi Everyone!

I have been requested to run a report to find out the total archive size of every user's mailbox at our company, in order to find out who has the biggest EV mailbox's (almost like a hit list) and would like to know if this is possible to do?

I have read various discussions on reporting but am unable to find any that help me

Any help would be most welcome!

DM 

 

Enterprise Vault
Information Governance
Monitoring
Reporting
Windows 7
  • AndrewB's avatar
    AndrewB
    11 years ago

    1. login to your EV server with your EV service account

    2. launch Internet Explorer

    3. go to http://localhost/EnterpriseVault/usage.asp

    4. you have several options: a. save report by archive, b. save report by account, c. you can click on the vault store and see the report in your web browser (by username or by account)

     

  • GertjanA's avatar
    GertjanA
    Moderator
    11 years ago

    Hello DM,

    You can run this on SQL (where the databases for EV are):

    SELECT A.ArchiveName, COUNT(S.IdTransaction) AS ArchivedItemCount, SUM(S.ItemSize)/1024 AS ArchivedItemSizeMB
    FROM EnterpriseVaultDirectory.dbo.Archive A,
    EnterpriseVaultDirectory.dbo.Root R,
    yourvaultstorename.dbo.ArchivePoint AP,
    yourvaultstorename.dbo.Saveset S

    WHERE S.ArchivePointIdentity = AP.ArchivePointIdentity
    AND AP.ArchivePointId = R.VaultEntryID
    AND R.RootIdentity = A.RootIdentity
    AND S.ArchivedDate < getDate()
    GROUP BY A.ArchiveName

     

    replace yourvaultstorename with the name of the database for your user vault store database name.

  • DarthMaul's avatar
    DarthMaul
    Level 3
    11 years ago

    Thank you for the information

    So this would provide me with all the information of mailbox sizes, and, guessing i can output this into CSV or TXT files?

  • AndrewB's avatar
    AndrewB
    Moderator
    11 years ago

    1. login to your EV server with your EV service account

    2. launch Internet Explorer

    3. go to http://localhost/EnterpriseVault/usage.asp

    4. you have several options: a. save report by archive, b. save report by account, c. you can click on the vault store and see the report in your web browser (by username or by account)

     

  • TonySterling's avatar
    TonySterling
    Moderator
    11 years ago

    So do you just want to know the archive size or the mailbox size? It seems like you are using mailbox and archive interchangeably.

    If you want to know the mailbox size you can do a Run Now of the Archive Task in report mode, if you just care about the archive size the suggestions above should work.

     

  • DarthMaul's avatar
    DarthMaul
    Level 3
    11 years ago

    Worked a treat guys, thank you very much!! Sorry for the delay been on Holiday :)