Forum Discussion

Gurmeet_Kohli's avatar
Gurmeet_Kohli
Level 4
11 years ago

ExchangeMailboxEntry table status.

Hello Guys, Can some on help me with the White paper or Tech Note as what does 'ExchangeMailboxEntry' has in it. To my understanding it has the info of all the Provisional mailbox entry in it. ...
Enterprise Vault
Information Governance
Windows Server (2003-2008)
  • JesusWept3's avatar
    JesusWept3
    11 years ago
    Like I said, once the entry is removed from ExchangeMailboxEntry you can't use the LegacyExchangeDN to query EV as the EME table is the ONLY table that contains the DN The ExchangeMailboxEntry table is updated by the Provisioning task which by default runs once a day automatically or you can set it to run twice a day, and you can also run it manually To get a list of inactive mailboxes run the following query SELECT MbxDisplayName, LegacyMbxDN FROM ExchangeMailboxEntry WHERE PolicyTargetGroupEntryId IS NULL
JesusWept3's avatar
JesusWept3
Level 6
11 years ago

So the user will be removed from provisioning i think after 7 failed attempts and the user no longer exists in Active Directory

Best bet for a query is

SELECT MbxDisplayName, LegacyMbxDN
FROM ExchangeMailboxEntry
WHERE PolicyTargetGroupEntryId IS NULL

This will get you all mailboxes that are no longer provisioned.
However once the entry is deleted from the ExchangeMailboxEntry, you won't have the LegacyMbxDN listed anywhere else, so your best bet maybe to just build your own database and table and simply have it copy the ExchangeMailboxEntry table, 

so Copy the entries in to a #temp table
then loop over them, if the user doesn't exist in the destination table, add the entry
if the user does exist, then simply update the table