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!
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.
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'
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.