Forum Discussion

Ain_t_No_Sunshi's avatar
13 years ago

Help to find youngest item archived date for all users

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

 

  • 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

3 Replies

  • 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