How to find a list of all mailboxes currently enabled for Archiving by Enterprise Vault

Problem

When archiving has not previously been disabled for mailboxes where  the associated accounts are either disabled or deleted within Active Directory, Enterprise Vault will continue to try and archive the mailboxes and may produce errors in the Event log or increase poor performance during the archiving window.

Solution

Enterprise Vault needs to query Active Directory in order to build a list of available mailboxes and Exchange Servers that host them. This is done via the Provisioning Task.

In the Admin Console under the Targets > Exchange section you have the Provisioning Groups. This is a list of groups, in hierarchical order, which have their own specific Active Directory targets, which can be Groups or Individuals.

When the Provisioning Task runs, it looks for all Active Directory users that fall under the first groups target. For each, it finds an entry in the ExchangeMailboxEntry table or creates an entry for that user and their mailbox. The task will process each group, starting with number 1 until the last and will apply the policy settings for the first Provisioning group it encounters.

When mailboxes or AD entries are deleted, Enterprise Vault will not update the ExchangeMailboxEntry table to disable archiving. Disabling  archiving has to be performed manually for the mailbox within the Admin Console.
 

Useful SQL Queries: 

1. This will give the number of all enabled mailboxes that have been pulled from AD since the 18th March 2013:
   
   Select Count(*) from ExchangeMailboxEntry where mbxarchivingstate = 1 and lastmodified > '2013-03-18 00:00:000'
    
2. This will give the number of mailboxes enabled for archiving:
   
   Select Count(*) from ExchangeMailboxEntry where mbxarchivingstate = 1
   
   Note: 0=New users, 1= Active archiving mailboxes, 2=Disabled mailboxes.
    
3. This will give the number of mailboxes pulled from AD since EnterpriseVault was installed in the organization:
   
   Select Count(*) from ExchangeMailboxEntry
   
   To get a specific list of the names replace Count(*) with * and to get a list of all disabled mailboxes change the mbxarchivingstate = 1 to mbxarchivingstate = 2.
    
4. These results can then be used to manually disable a large group of mailboxes that no longer exist by using the following query.
   
   Update ExchangeMailboxEntry set mbxarchivingstate = 2 where mbxarchivingstate = 1 and lastmodified > '2013-03-18 00:00:000' and exchangembxtype != 2
   
   Note: Replace '2013-03-18 00:00:000' with the date previous to that which the last provisioning task was successfully run.