Query Vault Usage

From EnterpriseVaultFaq.com - Wiki

Revision as of 09:18, 17 April 2009 by Michelz (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

SQL Script Description
Script Purpose: Gets Vault Usage per Vault
Description: Returns the Archive Name, Number of Items and Archive Size per Archive in VaultStore
Script Input: -
Script Output: ArchiveName, ArchivedItems, ArchivedItemsSize
Tested on EV Versions: 7.5 / 8.0

Source

Execute in Vault Store Database (EV*) 

SELECT [ArchiveName], ArchivedItems, CAST(ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize, ModifiedDate 
FROM view_ListVaults 
INNER JOIN [EnterpriseVaultDirectory].[dbo].[ArchiveView] 
ON view_ListVaults.ArchivePointId = [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId]

Or getting an additional field into the report (in this case "Company" out of the ExchangeMailboxEntry table): 

SELECT [ArchiveName], [Company], ArchivedItems, CAST(ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize, ModifiedDate
FROM view_ListVaults
INNER JOIN [EnterpriseVaultDirectory].[dbo].[ArchiveView]
ON view_ListVaults.ArchivePointId = [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId]
INNER JOIN [EnterpriseVaultDirectory].[dbo].[Root]
ON [EnterpriseVaultDirectory].[dbo].[ArchiveView].[RootIdentity] = [EnterpriseVaultDirectory].[dbo].[Root].[RootIdentity]
INNER JOIN [EnterpriseVaultDirectory].[dbo].[ExchangeMailboxEntry]
ON [EnterpriseVaultDirectory].[dbo].[Root].[VaultEntryId] = [EnterpriseVaultDirectory].[dbo].[ExchangeMailboxEntry].[DefaultVaultId]

Note: EnterpriseVaultDirectory Database and Vault Store Database have to be on the same Server for this to work.

Retrieved from "http://www.enterprisevaultfaq.com/wiki/Query_Vault_Usage"