cancel
Showing results for 
Search instead for 
Did you mean: 

Help to find youngest item archived date for all users

Ain_t_No_Sunshi
Level 3

Hi, 

I have around 3000 users.

What is the easiest way to create a list of users against youngest archived item date. 

Any help would be appreciated.

 

Thanks

Niag

 

1 ACCEPTED SOLUTION

Accepted Solutions

RahulG
Level 6
Employee

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

View solution in original post

3 REPLIES 3

RahulG
Level 6
Employee

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

Ain_t_No_Sunshi
Level 3

Thanks RahulG, that worked nicely.

Apologies for the delay in replying.

 

Regards

Niag

RahulG
Level 6
Employee

Youe Welcome !! Cheers !!