Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

EV Centera disk usage

Created: 01 Jul 2014 • Updated: 02 Jul 2014 | 3 comments
This issue has been solved. See solution.

Hi

EV 8/9/10 environment.

I am trying to get stats on Centera disk usage.

Here is my query:

SELECT EME.MbxDisplayName AS [Mailbox Name], ESE.ExchangeComputer AS [Exchange Server], EMS.Name AS [Exchange Database], EME.ADMbxDN AS [AD Details],
       T.SID AS OwningSID,
       VSE.VaultStoreName AS [Vault Store],
       AV.ArchiveName,
       vLV.ArchivedItems,
       CAST(vLV.ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize,
       vLV.ModifiedDate
FROM view_ListVaults AS vLV
LEFT OUTER JOIN EnterpriseVaultDirectory.dbo.ExchangeMailboxStore AS EMS
INNER JOIN EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME ON EMS.MbxStoreIdentity = EME.MbxStoreIdentity
INNER JOIN EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE ON EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
INNER JOIN EnterpriseVaultDirectory.dbo.Root AS R ON EME.DefaultVaultId = R.VaultEntryId
INNER JOIN EnterpriseVaultDirectory.dbo.Archive AS A ON R.RootIdentity = A.RootIdentity
INNER JOIN EnterpriseVaultDirectory.dbo.VaultStoreEntry AS VSE ON A.VaultStoreEntryId = VSE.VaultStoreEntryId
RIGHT OUTER JOIN EnterpriseVaultDirectory.dbo.ArchiveView AS AV ON R.RootIdentity = AV.RootIdentity ON vLV.ArchivePointId = AV.VaultEntryId
LEFT OUTER JOIN EnterpriseVaultDirectory.dbo.Trustee AS T ON R.OwningTrusteeIdentity = T.TrusteeIdentity
ORDER BY ESE.ExchangeComputer,
         EMS.Name,
         EME.MbxDisplayName ASC

The returned "ArchivedItemsSize" - is that the actual size on Centera, or the uncompressed size if I was to restore the data?

Thanks!

Operating Systems:

Comments 3 CommentsJump to latest comment

AndrewB's picture

i think you'd have to look at the centera itself to find out the actual size on centera. EV really wouldn't know. have a look at this technote which helps explain why. http://www.symantec.com/business/support/index?page=content&id=HOWTO57097#v15821909

so to answer your other question, that archive item size field is probably before any SIS.

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

SOLUTION
WiTSend's picture

As AndrewB as stated.  You'll need to use the Centera tools from EMC to get the actual storage usage.  Due to the Centera's storage,SIS and data protection mechanisms it is unlikely you'll get a true picture any other way.

 

https://community.emc.com/docs/DOC-2393

 

SOLUTION
goatboy's picture

Thanks, I'll liaise with our Storage team to get reports of Centera pool sizes and compare them to the output of the SQL query.