How to find youngest/oldest archived date and sent/received date per Index Volume for all the archives in Enterprise Vault

book

Article ID: 100011308

calendar_today

Updated On:

Resolution

Run the following SQL query:

Use EnterpriseVaultDirectory
Select A.ArchiveName "Archive Name",
       IV.IndexVolumeIdentity "EV Index Volume Set ID",  
       CONVERT(VARCHAR(20), IV.YoungestItemDateUTC, 100) "Youngest Sent/Received Date UTC",
       CONVERT(VARCHAR(20), IV.YoungestArchivedDateUTC, 100) "Youngest Archived Date UTC",
       CONVERT(VARCHAR(20), IV.OldestItemDateUTC, 100) "Oldest Sent/Received Date UTC",
       CONVERT(VARCHAR(20), IV.OldestArchivedDateUTC, 100) "Oldest Archived Date UTC"

FROM   Archive A, IndexVolume IV
WHERE  IV.RootIdentity = A.RootIdentity
  AND  IV.OldestItemDateUTC IS NOT NULL
ORDER BY A.ArchiveName

 

Note: Time is displayed in Coordinated Universal Time (UTC) not Local Time.

 

 

Issue/Introduction

How to find youngest/oldest archived date and sent/received date per Index Volume for all the archives in Enterprise Vault