06-10-2016 12:26 AM
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
Solved! Go to Solution.
06-10-2016 01:53 AM
Hi
You can try following query.
USE EnterpriseVaultDirectory
SELECT
ArchiveName,
OldestArchivedDateUTC,
YoungestArchivedDateUTC,
OldestItemDateUTC,
OldestItemDateUTC
FROM IndexVolumeView
Regards
Pradeep
06-10-2016 01:53 AM
Hi
You can try following query.
USE EnterpriseVaultDirectory
SELECT
ArchiveName,
OldestArchivedDateUTC,
YoungestArchivedDateUTC,
OldestItemDateUTC,
OldestItemDateUTC
FROM IndexVolumeView
Regards
Pradeep
06-10-2016 04:23 AM
Is there anyway I can use that script to target certain lindex locations or vault stores?
06-10-2016 04:39 AM
managed to work some thing out thanks Pradeep,
Would you know why Null values appear
06-11-2016 10:27 PM
Hi Rdosramos, Looking @ my lab, the NULL value may appear if there is no archiving happened OR index entries are not updating.
06-13-2016 09:22 AM
OK thanks Pradeep.