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 databases
select * from Mailstore
- or -
select MailstoreId, Displayname, DistinguishedName, LegacyExchangeDN from Mailstore
Note here MailstoreId of every mailbox database where you want to enable or disable Exchange Store Manager from all of it's mailboxes
2.) The following SQL Query will verify, which individual mailboxes are attached to the mailbox database
select * 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 enabled
3.) The following SQL Query let us disable or enable the Exchange Store Manager for all mailboxes of a certain mailbox database
The 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 Mailbox
set EnableStoreManager = 0
where MailstoreId = xxx OR MailstoreId = yyy OR MailstoreId = zzz
To enable scan for all mailboxes of a certain mailbox database, the value can be set to 1:
update Mailbox
set EnableStoreManager = 1
where MailstoreId = xxx