03-08-2012 02:12 AM
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
Solved! Go to Solution.
03-08-2012 02:41 AM
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
03-08-2012 02:41 AM
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
03-13-2012 12:45 AM
Thanks RahulG, that worked nicely.
Apologies for the delay in replying.
Regards
Niag
03-13-2012 01:42 AM
Youe Welcome !! Cheers !!