Archival Vault Store usage report

[Vipul_Desai]

Dear All,

We are using Enterprise Vault 9.0.2.

We need to gather information regarding enterprise vault archive data.

We have checked with usage.asp.

Apart from this is there any SQL query which will determine archived data and original data excluding single instance storage.

We have not installed reporting for the same.

How can we accomplish this.

Regards,

Vipul

[Rob_Wilcox1 · Accepted solution]

Did you take a look at : https://www-secure.symantec.com/connect/articles/enterprise-vault-useful-sql-queries

[Jens_Sanft · Accepted solution]

You could try the following query against the vault store database. It gives you the number of Active Archives, Archived Items, Archived Items Size and Original Size.

I use it with EV 10.0.4, so I'm not sure if it works with EV 9.0.2

SELECT    COUNT(DISTINCT V.ArchivePointIdentity) AS ActiveArchives,
          SUM(V.ArchivedItems) AS ArchivedItems,
          SUM(CAST(V.ArchivedItemsSize AS decimal(20, 0))) AS ArchivedItemsSize,
          SUM(CAST(T.Orgsize AS decimal(20, 0))) AS OriginalSize

FROM      dbo.Vault AS V

LEFT OUTER JOIN (

SELECT SS.VaultIdentity, (CASE WHEN SUM(OriginalSize) IS NULL THEN 0 ELSE SUM(OriginalSize) END) AS Orgsize
FROM      dbo.Saveset AS SS

LEFT OUTER JOIN
          dbo.SavesetProperty AS SSP ON SS.SavesetIdentity = SSP.SavesetIdentity
GROUP BY  SS.VaultIdentity) AS T ON V.VaultIdentity = T.VaultIdentity