EV Centera disk usage

[goatboy]

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!

[AndrewB · Accepted solution]

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.

[WiTSend · Accepted solution]

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

[goatboy]

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.