EVPM PST Migration Effort (EV904) - Archive ID

[NaturesRevenge]

We're using EVPM to move PST content to personal archives in EV. Because we have employees with the same name, to assure we're moving content to the correct Vault, I'd like to use the Archive ID in the Unicode INI that EVPM calls to. This Archive ID is found in the advanced tab of the properties of the archive.

Is someone familiar with a SQL query that I could run against the (I'm assuming) EnterpriseVaultDirectory database, that would show me, perhaps, Vault Name, Alias of mailbox, Archive ID, etc?

Thanks to all!

[GabeV]

There is a view available in the Enterprise Vault directory DB called dbo.ArchiveView where you can find all the information you are looking for. Just run this query:

USE EnterpriseVaultDirectory

SELECT * FROM dbo.ArchiveView

The VaultEntryID field contains the ArchiveID

I hope this helps.

[JesusWept3]

This should do what you want by specifying the MbxAlias

 

SELECT A.ArchiveName "Archive Name",
       R.VaultEntryId "Archive ID",
       EME.MbxAlias "Mailbox Alias",
       EME.MbxNTUser "Logon Name",
       VSE.VaultStoreName "Vault Store",
       CE.ComputerName "EV Server"
FROM   Archive A, 
       Root R,
       ExchangeMailboxEntry EME,
       ExchangeMailboxStore EMS,
       ExchangeServerEntry ESE,
       VaultStoreEntry VSE,
       StorageServiceEntry SSE,
       ComputerEntry CE
WHERE  A.RootIdentity = R.RootIdentity
  AND  R.VaultEntryId = EME.DefaultVaultId
  AND  EME.MbxStoreIdentity = EMS.MbxStoreIdentity
  AND  EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
  AND  A.VaultStoreEntryId = VSE.VaultStoreEntryId
  AND  VSE.StorageServiceEntryId = SSE.ServiceEntryId
  AND  SSE.ComputerEntryId = CE.ComputerEntryId
  AND  EME.MbxAlias = 'myAlias'

[GabeV]

Addint the ExchangeMailboxEntry table to the SQL query should give more information regarding the mailboxes:

USE EnterpriseVaultDirectory
SELECT *
FROM ArchiveView INNER JOIN ExchangeMailboxEntry ON 
     ArchiveView.VaultEntryId = ExchangeMailboxEntry.DefaultVaultId

I hope this helps.

[NaturesRevenge]

You two are pros. Thank you for the suggestions!!

[GabeV]

You're very welcome !!