Forum Discussion

Vipul_Desai's avatar
Vipul_Desai
Level 4
10 years ago

Archival Vault Store usage report

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

 

Enterprise Vault
Information Governance
Installing
Troubleshooting
Windows Server (2003-2008)
  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    10 years ago

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

  • Jens_Sanft's avatar
    Jens_Sanft
    10 years ago

    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

     

  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    Level 6
    10 years ago

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

  • Jens_Sanft's avatar
    Jens_Sanft
    Level 3
    10 years ago

    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