Forum Discussion

NaturesRevenge's avatar
NaturesRevenge
Level 5
12 years ago

EVPM PST Migration Effort (EV904) - Archive ID

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!

Enterprise Vault
Information Governance
Windows Server (2003-2008)
  • GabeV's avatar
    GabeV
    Level 6
    12 years ago

    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's avatar
    JesusWept3
    Level 6
    12 years ago

    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's avatar
    GabeV
    Level 6
    12 years ago

    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.