How to find archive based on the SavesetID or ArchiveID

Steven, I'm curious ... Why do you want to do this?

There is also a way to do this in SQL. If you already have the transaction ID (should look something like this: 5897B02F-6987-4258-8F20-2B3E4CDD96D0) then you can run this query to get the name of the archive:

SELECT EVVSStore1_1.dbo.view_Saveset_Archive_Vault.IdTransaction, EnterpriseVaultDirectory.dbo.ArchiveView.ArchiveName, EnterpriseVaultDirectory.dbo.ArchiveView.VaultentryId
FROM EnterpriseVaultDirectory.dbo.ArchiveView
INNER Join EVVSStore1_1.dbo.view_Saveset_Archive_Vault
ON EVVSStore1_1.dbo.view_Saveset_Archive_Vault.ArchivePointId = EnterpriseVaultDirectory.dbo.ArchiveView.VaultentryId
WHERE EVVSStore1_1.dbo.view_Saveset_Archive_Vault.IdTransaction = 'transactionID'

(Replace EVVSStore1_1 with the name of your Vault Store database, and transactionID with the correct transaction ID.)

There is a shared mailbox that a shortcut was copied too. We were not sure if the item had been archived in the origional recipients mailbox or once it was moved to the shared mailbox.

That worked like a charm, got to love thoes hidden menu items!

I don't have the transactionID, just what is on the shortcut. Do you know how to find the archive based on the ArchiveID as shown above. I would like to do this with SQL if possibel that way I can create a web front end for this.

Thanks 

if you want to do it via SQL with the ArchiveID you can do one of the following queries

USE EnterpriseVaultDirectory
SELECT MbxDisplayName, DefaultVaultID
FROM ExchangeMailboxEntry
WHERE DefaultVaultID = 'abcdefg12345evsite'

or

SELECT A.ArchiveName, R.VaultEntryID
FROM Root R, Archive A
WHERE R.RootIdentity = A.RootIdentity
  AND R.VaultEntryID = 'abcdefg12345evsite'

Also for the TID, Damon missed a hyphen (it should be 8-4-4-4-12)
If you have 5897B02F698742588F202B3E4CDD96D, then your transaction ID is 5897B02F-6987-4258-8F20-2B3E4CDD960'

The saveset ID contains the transaction ID. So for instance, if you have a saveset ID of 818000000000000~200608161654500000~0~5897B02F698742588F202B3E4CDD96D, then your transaction ID is 5897B02F-6987-4258-8F20-2B3E4CDD960 (Note that I've put a 0 on the end. All transaction IDs should end in 0.)

Edit: Whoops, missed a hyphen.