Enterprise Vault SQL Reports can potentially show duplicate entries for User Mailboxes
Article ID: 100001738
Updated On:
Cause
This is observed when a users mailbox has multiple entries in the SQL table 'ExchangeMailboxEntry' under the 'EnterpriseVaultDirectory' database.
Resolution
1.) Open the 'ExchangeMailboxEntry' table and verify that the user has multiple entries
a.) This can be easily accomplished by running the following command:
SELECT * FROM ExchangeMailboxEntry WHERE MbxAlias = '' 2.) Remove the duplicate entries for each affected user
a.) This can be easily accomplished by running the following command:
DELETE FROM ExchangeMailboxEntry WHERE MbxAlias = '' 3.) From the Vault Admin Console re-run the Exchange Provisioning Task in normal mode
4.) Verify that the users are placed back onto the 'ExchangeMailboxEntry" table and only have one entry now
5.) Allow an Exchange Mailbox Archiving Task run to complete
6.) Check the affected SQL reports to verify that the duplicate entries are no longer present
Issue/Introduction
Enterprise Vault SQL Reports can potentially show duplicate entries for User Mailboxes
Was this article helpful?
Yes
No
Powered by
