Issue
When adding age on the Bulk mapping screen, newest item and oldest item are inconsistent with actual data contained in the Archive and Item table.
Bulk mapping screen in UI

SQL database results for container ID 11dbd7ec-761f-4ba3-ba5a-2e6681c153f2 (cloud customer)

SQL query to get results

SELECT 
'[ArchiveShuttleDirectory].[dbo].[BulkMappingView]' AS [DB Source], 
ContainerId, 
OldestItemDateUtc, 
YoungestItemDateUtc 
FROM [ArchiveShuttleDirectory.CUSTOMER].[dbo].[BulkMappingView]
WHERE ContainerId = 'CONTAINER ID'
UNION ALL
SELECT 
'[ArchiveShuttleDirectory].[dbo].[Container.EnterpriseVaultView]' AS [DB Source], 
ContainerId, 
OldestItemDateUtc, 
YoungestItemDateUtc 
FROM [ArchiveShuttleDirectory.CUSTOMER].[dbo].[Container.EnterpriseVaultView]
WHERE ContainerId = 'CONTAINER ID'
UNION ALL
SELECT 
'[ArchiveShuttleDirectory].[dbo].[EVArchive]' AS [DB Source], 
ContainerId, 
OldestItemDateUtc, 
YoungestItemDateUtc 
FROM [ArchiveShuttleDirectory.CUSTOMER].[dbo].[EVArchive]
WHERE ContainerId = 'CONTAINER ID'
UNION ALL
SELECT 
'[ArchiveShuttleItem_DATABASEID].[dbo].[Item]' AS [DB Source], 
ContainerId, 
Min(DateUtc) AS OldestItemDateUTC, 
Max(DateUtc) AS YoungestItemDateUTC 
FROM [ArchiveShuttleItem_DATABASEID].[dbo].[Item]
WHERE ContainerId = 'CONTAINER ID'
GROUP BY ContainerId
UNION ALL
SELECT 
'[ArchiveShuttleItem_DATABASEID].[dbo].[ItemEnterpriseVault]' AS [DB Source], 
b.ContainerId, 
Min(a.ArchivedDateUtc) AS OlderstItemDateUTC, 
Max(a.ArchivedDateUtc) AS YoungestItemDateUTC 
FROM [ArchiveShuttleItem_DATABASEID].[dbo].[ItemEnterpriseVault] a
LEFT OUTER JOIN [ArchiveShuttleItem_DATABASEID].[dbo].[Item] b ON a.ItemId = b.ItemId
WHERE a.ItemID IN (SELECT ItemId FROM [ArchiveShuttleItem_DATABASEID].[dbo].[Item]
WHERE ContainerId = 'CONTAINER ID')
GROUP BY b.ContainerId

More details
To UI is information getting passed from “EVArchive” table. Same information is passed to views created (“BulkMappingView” and “EnterpriseVaultView”) and stored in columns “OldestItemDateUtc” and “YoungestItemDateUtc”.
The rest of the EV VaultStore DB (item-level) dates are different and can not be compared with previously mentioned. DB columns are named “DateUtc” or “ArchivedDateUtc”.
Exception
Youngest and Oldest item dates are not populated (not collected) in case of DAM (Dell Archive Manager).

Print Friendly, PDF & Email