Overview
In case you do Enterprise Vault to PST migration you might need know which item is imported to which PST file based on EV TransactionID and this article can guide you how it can be tracked.
 
Details
TransactionID from [Saveset] table in Enterprise Vault Store database is the same ID as ItemID in Archive Shuttle Item Database.
It means that you could track it via tables such as [ItemRoutingNativeMailSubContainer] and [ItemRouting] in the Archive Shuttle database.
SQL queries which you might find helpful:
 
1) The SQL query to check which ItemDB ContainerMappingID belongs to. (Run on Archive Shuttle Directory DB.)
 

SELECT LDB.SQLDatabaseName FROM ContainerMapping CM INNER JOIN
       container C ON C.ContainerId = CM.SourceContainerId INNER JOIN
       Link L ON l.linkid = C.linkId INNER JOIN
       LinkDatabaseConnection LDB ON LDB.linkId = L.linkid
WHERE CM.containermappingid =  xx

xx = the appropriate container mapping ID
 
2) In case File Name Policy includes PST id (MailNativeSubContainerId) following SQL query can be used to check all ingested items per closed and renamed MailNativeSubContainerId\PST file, which was created for certain ContainerMappingId. (Run on Archive Shuttle ItemDB.)
 

SELECT ItemRouting.ItemId, ItemRouting.ContainerMappingId, ItemRoutingNativeMailSubContainer.MailNativeSubContainerId
FROM ItemRouting
INNER JOIN ItemRoutingNativeMailSubContainer ON ItemRouting.ItemRoutingId = ItemRoutingNativeMailSubContainer.ItemRoutingId
INNER JOIN [ArchiveShuttleDirectory].dbo.ContainerMapping ON ItemRouting.ContainerMappingId = [ArchiveShuttleDirectory].dbo.ContainerMapping.ContainerMappingId
INNER JOIN [ArchiveShuttleDirectory].dbo.EVArchive ON [ArchiveShuttleDirectory].dbo.ContainerMapping.SourceContainerId = [ArchiveShuttleDirectory].dbo.EVArchive.ContainerId
INNER JOIN [ArchiveShuttleDirectory].dbo.MailNativeSubContainer ON ItemRoutingNativeMailSubContainer.MailNativeSubContainerId = MailNativeSubContainer.MailNativeSubContainerId
WHERE ItemRouting.IsImported = 1 and MailNativeSubContainer.IsRenamed = 1
and ItemRouting.ContainerMappingId = xx
ORDER BY ItemRoutingNativeMailSubContainer.MailNativeSubContainerId

 
3) In case your File Name Policy does NOT include PST id (MailNativeSubContainerId) following SQL query can be used to check all ingested items per closed and renamed PST file name, which was created for certain ContainerMappingId. (Run on Archive Shuttle ItemDB.)
 

SELECT
[ArchiveShuttleDirectory].dbo.EVArchive.Name + '_' + CAST(ItemRoutingNativeMailSubContainer.MailNativeSubContainerId as varchar(128))+ '.pst' as PST_Name, 
ItemRouting.itemid AS SavesetId, ItemRoutingNativeMailSubContainer.MailNativeSubContainerId, ItemRouting.ContainerMappingId
FROM ItemRouting
INNER JOIN ItemRoutingNativeMailSubContainer ON ItemRouting.ItemRoutingId = ItemRoutingNativeMailSubContainer.ItemRoutingId
INNER JOIN [ArchiveShuttleDirectory].dbo.ContainerMapping ON ItemRouting.ContainerMappingId = [ArchiveShuttleDirectory].dbo.ContainerMapping.ContainerMappingId
INNER JOIN [ArchiveShuttleDirectory].dbo.EVArchive ON [ArchiveShuttleDirectory].dbo.ContainerMapping.SourceContainerId = [ArchiveShuttleDirectory].dbo.EVArchive.ContainerId
INNER JOIN [ArchiveShuttleDirectory].dbo.MailNativeSubContainer ON ItemRoutingNativeMailSubContainer.MailNativeSubContainerId = MailNativeSubContainer.MailNativeSubContainerId
WHERE ItemRouting.IsImported = 1 and MailNativeSubContainer.IsRenamed = 1
and ItemRouting.ContainerMappingId = xx
ORDER BY ItemRoutingNativeMailSubContainer.MailNativeSubContainerId

 
Note
Please take into consideration that the first line of this SQL query to get the right PST_Name might need to be adapted based on your PST File Name Policy.
TransactionID = SavesetId

Print Friendly, PDF & Email