How to find archive based on the SavesetID or ArchiveID

[StevenHill]

Does anyone have a way or SQL query to determaine the Archive a items belongs too? I have a shortcut item that I extracted the Saveset ID and Archive ID from. How can I determine the archive this belings too?

Thanks in advance.

[JesusWept3 · Accepted solution]

archive id, open the Vault Admin Console, hold Ctrl-Shift and right click Archives and go to Find Archive or Folder and paste in your archive id

[Rob_Wilcox1]

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

[Damon_Kaswell]

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.)

[StevenHill]

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.

[StevenHill]

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

[StevenHill]

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 

[JesusWept3]

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'

[Damon_Kaswell]

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.