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 different offices. 

I was wondering is it is possible to run this sort of script but just for users in a particular vault store? 

 

Thanks

 

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

     

5 Replies

Sort By
  • Pradeep-Papnai's avatar
    Pradeep-Papnai
    Level 6
    9 years ago

    Hi Rdosramos, Looking @ my lab, the NULL value may appear if there is no archiving happened OR index entries are not updating.

  • Rdosramos's avatar
    Rdosramos
    Level 5
    9 years ago

    managed to work some thing out thanks Pradeep,

     

    Would you know why Null values appear

  • Rdosramos's avatar
    Rdosramos
    Level 5
    9 years ago

    Is there anyway I can use that script to target certain lindex locations or vault stores?

  • Pradeep-Papnai's avatar
    Pradeep-Papnai
    Level 6
    9 years ago

    Hi

    You can try following query.

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

     

    Regards

    Pradeep