Video Screencast Help

Running Reports from EV Server

Created: 27 Jun 2014 • Updated: 16 Jul 2014 | 6 comments
This issue has been solved. See solution.

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 

 

Operating Systems:

Comments 6 CommentsJump to latest comment

GertjanA's picture

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.

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

DarthMaul's picture

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 picture

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)

 

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

SOLUTION
TonySterling's picture

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's picture

Hi DM, did you get what you needed?

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

DarthMaul's picture

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