exchangembxtype values and meaning

[SheldonDsouza]

Hi,

I am looking to query the ExchangeMailboxEntry Table in SQL and subsequently make a couple of changes as well.

While we are not using EV Reports in this environment, I need to depend on direct interaction with SQL.

I understand the risks I would be undertaking, but this will be a one time activity. Once I get to install and configure EV Reports or get the desired results from running SQL Queries (Select Statements), I do not have to make direct changes in SQL

Hence I need to know what are the different values for exchangembxtype and their meaning?

[AndrewB]

1 is a user mailbox and 2 is a journal mailbox

[Pradeep-Papnai · Accepted solution]

Hi,

Looked @ my LAB & I belive “ExchangeMbxType” represents whether the mailbox is a user/journal/system mailbox.

0=SystemMailbox (configured in the properties of archiving task)

1=User mailbox

2=Journal mailbox

[SheldonDsouza]

Thank You Pradeep

[SheldonDsouza]

Thank you Andrew...

[SheldonDsouza]

Hello once again... a small deviation from the topic.

It concerns another field in the ExchangeMailboxEntry Table; "MbxArchivingState"

In one technote, it gives the possible values for this field. In the environment I am working on, I see a value 3.

The technote I am quoting is TECH204081

[Ben_Watts]

To answer your last comment, excerpt from one of my SQL queries:- WHEN MbxArchivingState = 0 THEN 'Provisioned but not Enabled for Archiving' WHEN MbxArchivingState = 1 THEN 'Enabled for Archiving' WHEN MbxArchivingState = 2 THEN 'Archiving Disabled' WHEN MbxArchivingState = 3 THEN 'System Mailbox' So all mailboxes with an ExchangeMbxType of 0 should have a MbxArchivingState of 3.