cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

1 Solution

Accepted Solutions
Accepted Solution!

Re: SQL query check users oldest and youngest item

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
Accepted Solution!

Re: SQL query check users oldest and youngest item

Hi

You can try following query.

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

 

Regards

Pradeep

 

View solution in original post

Re: SQL query check users oldest and youngest item

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

Re: SQL query check users oldest and youngest item

managed to work some thing out thanks Pradeep,

 

Would you know why Null values appear

Hi Rdosramos, Looking @ my

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

Re: SQL query check users oldest and youngest item

OK thanks Pradeep.