Video Screencast Help
Search Video Help Close Back
to help

How to get the size of a specific archive?

Created: 07 Dec 2012 | Updated: 08 Dec 2012 | 4 comments
mistervault's picture
mistervault
0 0 Votes
Login to vote
This issue has been solved. See solution.

Hello,

I need to get the size of a specific archive by SQL query or script.

I don't want to use the report usage because I need to script it.

Thanks

Discussion Filed Under:
,

Comments 4 Comments • Jump to latest comment

AndrewB's picture
AndrewB Partner Accredited
How to get the size of a specific archive? - Comment:07 Dec 2012 : Link
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

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

0
Login to vote
  • Actions
TonySterling's picture
TonySterling Trusted Advisor Partner Accredited Certified
How to get the size of a specific archive? - Comment:07 Dec 2012 : Link

Andrew's query will give you items size per Exchange server but if that isn't what you want then try this:

 

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

WHERE (A.ArchiveName = 'archivename' )
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointId = R.VaultEntryID
AND R.RootIdentity = A.RootIdentity

GROUP BY A.ArchiveName

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

SOLUTION
0
Login to vote
  • Actions
TonySterling's picture
TonySterling Trusted Advisor Partner Accredited Certified
How to get the size of a specific archive? - Comment:07 Dec 2012 : Link

Or this one from Alex found here:

https://www-secure.symantec.com/connect/forums/ev-...

 

SELECT EME.MbxDisplayName "Mailbox Name",
       ESE.ExchangeComputer "Exchange Server",
       EMS.Name "Exchange Database",
       VSE.VaultStoreName "Vault Store"
FROM   ExchangeMailboxEntry EME,
       ExchangeMailboxStore EMS,
       ExchangeServerEntry ESE,
       Root R,
       Archive A,
       VaultStoreEntry VSE
WHERE  EME.MbxStoreIdentity = EMS.MbxStoreIdentity
  AND  EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
  AND  EME.DefaultVaultId = R.VaultEntryId
  AND  R.RootIdentity = A.RootIdentity
  AND  A.VaultStoreEntryId = VSE.VaultStoreEntryId
ORDER BY ESE.ExchangeComputer, EMS.Name, EME.MbxDisplayName

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

0
Login to vote
  • Actions
mistervault's picture
mistervault
How to get the size of a specific archive? - Comment:09 Dec 2012 : Link

In fact, I just realized something.

When we access to this page : http://localhost/enterprisevault/usage.asp

After, when we select a specific store, it calls the file "listvaults.asp" : 

http://localhost/enterprisevault/listvaults.asp?va...

 

This file "listvaults.asp" is located here : C:\Program Files (x86)\Enterprise Vault\webapp

It's the file used by Vault to perform the summary report by size in VBScript, interesting.

0
Login to vote
  • Actions