cancel
Showing results for 
Search instead for 
Did you mean: 

Running Reports from EV Server

DarthMaul
Level 3

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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)

 

View solution in original post

6 REPLIES 6

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Regards. Gertjan

DarthMaul
Level 3

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
Moderator
Moderator
Partner    VIP    Accredited

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

 

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

Hi DM, did you get what you needed?

DarthMaul
Level 3

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