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

Article:TECH191325  |  Created: 2012-06-20  |  Updated: 2014-06-05  |  Article URL http://www.symantec.com/docs/TECH191325
Article Type
Technical Solution


Issue



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


Cause



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


Solution



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.
     
  2. Open SQL Server Management Studio.
     
  3. Click in the New Query button.
     
  4. Run the following SQL query:

    USE EnterpriseVaultDirectory
    SELECT ArchiveName, OldestItemDateUTC, YoungestItemDateUTC, HighestItemSequenceNumber, IndexedItems
    FROM EnterpriseVaultDirectory.dbo.IndexView
    ORDER BY OldestItemDateUTC


    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.



Article URL http://www.symantec.com/docs/TECH191325


Terms of use for this information are found in Legal Notices