Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

Mbx Archiving State / Mbx Exchange State

Created: 08 Dec 2009
Wayne Humphrey's picture
+6 8 Votes
Login to vote
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