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

Problem

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.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)