Often the question of what is the different states of MbxArchivingState and MbxExchangeState in the ExchangeMailboxEntry table.
The Archiving State translates as follows:
0 = Not Enabled
1 = Enabled
2 = Disabled
3 = Re-Link
To view the Archiving State you can use the following:
SELECT count(MbxArchivingState) as '# Mailboxes',
MbxArchivingState as 'Archiving State'
FROM ExchangeMailboxEntry
GROUP BY MbxArchivingState
The Exchange State translates as follows:
0 = Normal
1 = Hidden
2 = Deleted
To view the Exchange State you can use the following:
SELECT count(MbxExchangeState) as '# Mailboxes',
MbxExchangeState as 'Exchange State'
FROM ExchangeMailboxEntry
GROUP BY MbxExchangeState