Retour
-
Titre
How to enable or disable Exchange Store Manager scan on mailboxes in bulk, based on mailbox database. -
Description
When users mailboxes are distributed between different mailbox databases and only users' mailboxes distributed to certain mailbox database should be enabled for Exchange Store Manager to be scanned, users' mailboxes on other mailbox databases can be disabled by use of the following SQL Queries. Enabling Exchange Store Manager for all mailboxes of a certain mailbox database is possible as well. -
Résolution
1.) The following SQL Query will identify the mailbox databases available, and their MailstoreId's assigned - either of the following SQL Query's will produce an overview over all available mailbox databases with information needed to identify each of the mailbox databasesselect * from Mailstore- or -select MailstoreId, Displayname, DistinguishedName, LegacyExchangeDN from MailstoreNote here MailstoreId of every mailbox database where you want to enable or disable Exchange Store Manager from all of it's mailboxes2.) The following SQL Query will verify, which individual mailboxes are attached to the mailbox databaseselect * from Mailbox where EnableStoreManager = 1 AND MailstoreId = xxx (with value of MailstoreId found in 1.))This shows all mailboxes of the selected mailbox database with Exchange Store Manager enabled3.) The following SQL Query let us disable or enable the Exchange Store Manager for all mailboxes of a certain mailbox databaseThe value of MailstoreId needs to get taken by Query 1.), 'set EnableStoreManager = 0' will disable and 'set EnableStoreManager = 1' will enable, furthermore the 'OR' statement to include multiple mailbox databases into one Query:To disable scan for all mailboxes of a certain mailbox database, the value can be set to 0:update Mailboxset EnableStoreManager = 0where MailstoreId = xxx OR MailstoreId = yyy OR MailstoreId = zzzTo enable scan for all mailboxes of a certain mailbox database, the value can be set to 1:update Mailboxset EnableStoreManager = 1where MailstoreId = xxx