SQL Query to identify VaultEntryID in EnterpriseVaultDirectory.dbo.Root

Ok this should give you what you need if you only have the SQL tables to work with, make sure the EnterpriseVaultDirectory and Vault Store DBs are on the same SQL Server/Instance otherwise you will need to alter the query to suit.

Run it against you Vault Store DB which holds the TransactionIds you are interested in:-

SELECT ArchiveName
, VaultEntryId AS ArchiveID
, IDTransaction
, IDDateTime AS ItemDateTime
, ArchivedDate
FROM Saveset
INNER JOIN ArchivePoint on ArchivePoint.ArchivePointIdentity = Saveset.ArchivePointIdentity
INNER JOIN EnterpriseVaultDirectory..ArchiveView AV on AV.VaultEntryId = ArchivePoint.ArchivePointId