cancel
Showing results for 
Search instead for 
Did you mean: 

SQL-Query listing ArchiveName, ArchivedItems, ArchivedItemsSize, YoungestArchivedDateUTC

Michael_Buehlme
Level 3

I have a SQL-Query which generates a list of Archives with ArchiveName, ArchivedItems, ArchivedItemsSize.

USE EVVAULTSTORENUE
GO

SELECT [ArchiveName], ArchivedItems,
    CAST(ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize
FROM view_ListVaults
INNER JOIN [EnterpriseVaultDirectory].[dbo].[ArchiveView]
ON view_ListVaults.ArchivePointId = [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId]

order by [archivename] asc

 

How can I get the "YoungestArchivedDateUTC" to the list?

1 REPLY 1

GabeV
Level 6
Employee Accredited

Hello Michael,

You need to use the IndexVolumeView from the EVDir DB. Try this one:

USE EVVAULTSTORENUE
GO

SELECT [EnterpriseVaultDirectory].[dbo].[ArchiveView].[ArchiveName], ArchivedItems,
    CAST(ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize, IndexVolumeView.YoungestArchivedDateUTC
FROM view_ListVaults
INNER JOIN [EnterpriseVaultDirectory].[dbo].[ArchiveView]
ON view_ListVaults.ArchivePointId = [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId] INNER JOIN [EnterpriseVaultDirectory].[dbo].[IndexVolumeView] ON [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId] = [EnterpriseVaultDirectory].[dbo].[IndexVolumeView].[VaultEntryId]