Forum Discussion

Rdosramos's avatar
Rdosramos
Level 5
9 years ago

SQL query check users oldest and youngest item

Hi All, I jave a large EV enviroment and we are wanting to check the oldest archived item and youngest archived item for the users but we have multipal vault store and each vault store represents ...
Enterprise Vault
Information Governance
Reporting
Tip-How to
Troubleshooting
Windows Server (2003-2008)
  • Pradeep-Papnai's avatar
    Pradeep-Papnai
    9 years ago

    Hi

    You can try following query.

    USE EnterpriseVaultDirectory
    SELECT
        ArchiveName,
        OldestArchivedDateUTC,
        YoungestArchivedDateUTC,
        OldestItemDateUTC,
        OldestItemDateUTC
    FROM IndexVolumeView

     

    Regards

    Pradeep

     

Rdosramos's avatar
Rdosramos
Level 5
9 years ago

managed to work some thing out thanks Pradeep,

 

Would you know why Null values appear