Video Screencast Help

Trying to get each archive size...

Created: 02 Nov 2012 • Updated: 12 Nov 2012 | 9 comments
This issue has been solved. See solution.

Hi all,

I am running EV 9.0.2 and I have a request to get a real time size of each archive in the vault, I know there is a report that could find this but I am wanting to give the end users a tool that can be run real time to get the size of their Archive. 

Anyone know of any commands that I can run to pull this information from the vault?

Many thanks

Discussion Filed Under:

Comments 9 CommentsJump to latest comment

RahulG's picture


click on the vault store where your archive is and then click on 'view usage report by archive name'

There is no tool as such .

you may run the following query to find the

SELECT ESE.ExchangeComputer "Exchange Server", 
       COUNT(S.IdTransaction) "Items Archived",
       SUM(S.ItemSize)/1024 "Size of Items (MB)"
FROM   EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
       EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,
       EnterpriseVaultDirectory.dbo.ExchangeServerEntry ESE,
       yourVaultStore.dbo.ArchivePoint AP,
       yourVaultStore.dbo.Saveset S
WHERE  S.ArchivePointIdentity = AP.ArchivePointIdentity
  AND  AP.ArchivePointId = EME.DefaultVaultId
  AND  EME.MbxStoreIdentity = EMS.MbxStoreIdentity
  AND  EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
GROUP BY ESE.ExchangeComputer
stang92's picture

Correct me if I am wrong though, but is that data just not since the last time the archive was processed?  If I delete 5 GB's lets say from my archive, will the useage.asp update report that right away?

RahulG's picture

The information in the report is update every time you refresh the page, and on the back ground it queries the sql database to get the information to be displayed in the report .

stang92's picture

But the information in SQL is only updated every time the archive task runs, correct?

People want to have a real time way to display their useage in the vault, from what I am hearing I am thinking i can only give them ~24 hour delay instead (if archive task runs daily and completes)

this true?

RahulG's picture

No thats not true . The information in the Sql is updated as in the archiving happens .

stang92's picture

but if my archive task only runs once a day, the data is only as good from the last time it ran.

My situation is this, the users are being asked to delete TB's of data and we need to supply a real time report of the archive size, my response to them was the size of the archive is only as good as the last time the archive task ran, are you saying that it each time you run the report it queries the actual vault size at that time?

if so, that is great news!

RahulG's picture

Infromation in the usage report is generated on Run time. Just to test this you may try refreshing the page when the archiving is running .

AndrewB's picture

have you seen this technote?

How to grant other users access to the Enterprise Vault (EV) Vault Store Usage Report.
padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;color: #666666; background-color:#f2f2f2">Article:TECH50913 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2;"> |  padding: 0px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2;">Created: 2007-01-24 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2"> |  padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2">Updated: 2009-01-10 padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2"> |  padding: 1px;font: 12px Arial; text-align: left;color: #666666;background-color:#f2f2f2">Article URL

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner |

Ben Heymink's picture

Has your question been answered by these comments stang92? The only other way I can think of is knocking together some script to call some EV webpages that can return you the archive size.