02-12-2015 07:13 AM
Tring to find a simple sql query to return the mailbox name and the associated vault id.
Solved! Go to Solution.
02-12-2015 06:29 PM
02-12-2015 07:58 AM
Hello Steve,
Try this SQL query:
USE EnterpriseVaultDirectory SELECT EME.MbxDisplayName AS [Mailbox Name], ESE.ExchangeComputer AS [Exchange Server], EMS.Name AS [Exchange Database], ArchiveView.ArchiveName, ArchiveView.VaultEntryId FROM ExchangeMailboxEntry AS EME INNER JOIN ExchangeMailboxStore AS EMS ON EME.MbxStoreIdentity = EMS.MbxStoreIdentity INNER JOIN ExchangeServerEntry AS ESE ON EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity INNER JOIN Root AS R ON EME.DefaultVaultId = R.VaultEntryId INNER JOIN ArchiveView ON R.RootIdentity = ArchiveView.RootIdentity ORDER BY [Exchange Server], [Exchange Database], [Mailbox Name]
https://www-secure.symantec.com/connect/forums/ev-sql-query-list-all-maiboxes-mailboxes-and-out-ev-archives-mailbox-display-name-exchange-se
I hope this helps.
02-12-2015 09:27 AM
Perfect! Thank you very much.
02-12-2015 01:28 PM
You're welcome!
02-12-2015 06:29 PM