Help to find youngest item archived date for all users

The easiest way is to look the vault store summary report .

By using the Vault Admin Console ( VAC )  > Go to the Vault store > Right click and select the Reporting Option.

 

Uses this sql query:-

SELECT VaultEntryId, Type, RootIdentity, ArchiveName, ArchiveStatus, Structured, IndexingLevel, LocaleId, COUNT(DISTINCT IndexVolumeSetId) 
AS CountIndexVolumeSets, COUNT(RootIdentity) AS CountIndexVolumes, COUNT(NULLIF (Failed, 0)) AS CountFailedIndexVolumes, 
COUNT(NULLIF (Offline, 0)) AS CountOfflineIndexVolumes, COUNT(NULLIF (Rebuilding, 0)) AS CountRebuildingIndexVolumes, 
MIN(OldestArchivedDateUTC) AS OldestArchivedDateUTC, MAX(YoungestArchivedDateUTC) AS YoungestArchivedDateUTC, 
NULLIF (MIN(ISNULL(OldestItemDateUTC, '17530101')), '17530101') AS OldestItemDateUTC, NULLIF (MAX(ISNULL(YoungestItemDateUTC, '99991231')), 
'99991231') AS YoungestItemDateUTC, MAX(ISNULL(HighestItemSequenceNumber, 0)) AS HighestItemSequenceNumber, SUM(IndexedItems) 
AS IndexedItems, SUM(FailedItems) AS FailedItems, IndexItemsMode, ConvertedContentMode, IgnoreIndexingPolicy
FROM dbo.IndexVolumeView
GROUP BY VaultEntryId, Type, RootIdentity, ArchiveName, ArchiveStatus, Structured, IndexingLevel, LocaleId, IndexItemsMode, ConvertedContentMode, 
IgnoreIndexingPolicy

 

 

you may also use the following query 

 

Use EnterpriseVaultDirectory
select archivename, YoungestItemDateUTC from Indexview

or if you wanted the youngest archived date it would be:-

Use EnterpriseVaultDirectory
select archivename, YoungestArchivedDateUTC from Indexview