cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query check users oldest and youngest item

Rdosramos
Level 5
Partner Accredited

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Pradeep-Papnai
Level 6
Employee Accredited Certified

Hi

You can try following query.

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

 

Regards

Pradeep

 

View solution in original post

5 REPLIES 5

Pradeep-Papnai
Level 6
Employee Accredited Certified

Hi

You can try following query.

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

 

Regards

Pradeep

 

Rdosramos
Level 5
Partner Accredited

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

Rdosramos
Level 5
Partner Accredited

managed to work some thing out thanks Pradeep,

 

Would you know why Null values appear

Pradeep-Papnai
Level 6
Employee Accredited Certified

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

Rdosramos
Level 5
Partner Accredited

OK thanks Pradeep.