Checking MPS and AD Integrity... Part #6: Mailbox and Public Folder Database

At the heart of HMC is MPS. And at the heart of this this MPS is that 2 mysterious databases, the PlanManager and ResourceManager databases. What I am trying to do is to attempt to provide you guys some script to help you to better know your environment to at least know the health of your environment a little bit as you are planning to move forward to Exchange Server 2010 SP1 Hosting Deployment.

I wrote the following script (as attached) a while ago to help myself to check if all the mailbox and public folder databases listed in MPS map to a mailbox and public folder database object in Active Directory. At the same time it also list down the GUID and the actual free and maximum space for those databases in MPS.

Here is a sample output for the powershell script from my test lab,

[PS] C:\MPStoAD> .\CheckMBPFServer.ps1
Location: MAIL\Mailbox Database
MPS GUID: 5C8E61FBB572D34DAB6FA2142789F305
Actual Free/Max: 173618/200000
MB/PF: ExchMailStore07
DN Match: CN=Mailbox Database,CN=First Storage Group,CN=InformationStore
,CN=MAIL,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Admin
istrative Groups,CN=HMC45,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC

Location: MAIL\sg3mb1
Actual Free/Max: 276064/300000
MB/PF: ExchMailStore07
DN Match: CN=sg3mb1,CN=SG3,CN=InformationStore,CN=MAIL,CN=Servers,CN=Exc
hange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=HMC45,
CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=hmc45,DC=com

Location: MAIL\Exchange Public Folder Store
MPS GUID: D4BCDA19662FB34891B37B7CA9E05A40
Actual Free/Max: 41300/50000
MB/PF: ExchPublicStore07
DN Match: CN=Public Folder Database,CN=Second Storage Group,CN=Informati
onStore,CN=MAIL,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),C
N=Administrative Groups,CN=HMC45,CN=Microsoft Exchange,CN=Services,CN=Configura

This is A very simple script that doesn't really do too much but more for information purpose. It will also export it into a TXT file where you can then open it in Excel and perform a text to column and split it using semicolon (;) and you will get something like this,