How to determine the youngest and the oldest item archived for all the archives in Enterprise Vault

In order to determine the youngest and the oldest item archived for all the archives in Enterprise Vault, follow these steps:

1. Connect to the SQL Server used for Enterprise Vault Directory database. The server name will be located in the SQLServerName value under KEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\KVS\Enterprise Vault\Directory\DirectoryService on the Enterprise Vault server.  
2. Open SQL Server Management Studio.
3. Click in the New Query button.
4. Run the following SQL query:
   
   USE EnterpriseVaultDirectory
   SELECT ArchiveName, OldestArchivedDateUTC, YoungestArchivedDateUTC
   FROM EnterpriseVaultDirectory.dbo.IndexView
   ORDER BY OldestArchivedDateUTC
   
   Note: All the results returned in this query will match the dates from the Archives > Exchange Mailbox > Archive's Properties > Advanced Tab. In addition, it will provide how many items have been indexed on each volume and what is the highest item sequence number.