Querying Archive/mailbox size from EV SQL server

[RavishankarN22]

I'm trying to create a inventory of the archives in our EV environment. I'm looking for a way to find out the size of the archive related to a Exchange(2003) mailbox.

1. Is the size of the archive ( sum of size of the mails archived per mailbox) stored in any format in EV SQL server?

2. OR The only way to find out the total size of the mailbox(items) in the archive is by finding the individual mailbox items and them getting a sum of their sizes?

Please assist with any tips that are possible. >>> Please suggest the correct forum stream if this is out of scope here.<<<

Thanks,

[Mohawk_Marvin · Accepted solution]

Look at the usage page:

http://evserver/enterprisevault/usage.asp

if you click the vault stores under that, it will list all the archives, the item count and the size.

[JesusWept3]

Also if you look in the admin guide there is a section for useful SQL queries such as the ones you are looking for