Powershell: is your database mounted

Annoying little tidbit…

Using the Get-MailboxDatabase cmdlet on the RTM version returns a long list of things (if you pipe the output to format-list). One of those things is an entry for “Mounted”. This is clearly the heading that would contain the value of the mounted state of the database; however, the entry is blank…

[PS] C:\Documents and Settings\Administrator>get-mailboxdatabase | fl
JournalRecipient              :
MailboxRetention              : 30.00:00:00
OfflineAddressBook            :
OriginalDatabase              :
PublicFolderDatabase          :
ProhibitSendReceiveQuota      : 2355MB
Recovery                      : False
ProhibitSendQuota             : 2GB
IndexEnabled                  : True
AdministrativeGroup           : Exchange Administrative Group (FYDIBOHF23SPDLT)
AllowFileRestore              : False
BackupInProgress              :
CopyEdbFilePath               :
DatabaseCreated               : True
Description                   :
EdbFilePath                   : C:\Program Files\Microsoft\Exchange Server\Mail
                                box\First Storage Group\Mailbox Database.edb
ExchangeLegacyDN              : /o=JMDev/ou=Exchange Administrative Group (FYDI
                                BOHF23SPDLT)/cn=Configuration/cn=Servers/cn=DEV
                                DC/cn=Microsoft Private MDB
HasLocalCopy                  : False
DeletedItemRetention          : 14.00:00:00
LastFullBackup                :
LastIncrementalBackup         :
MaintenanceSchedule           : {Sun.1:00 AM-Sun.5:00 AM, Mon.1:00 AM-Mon.5:00
                                AM, Tue.1:00 AM-Tue.5:00 AM, Wed.1:00 AM-Wed.5:
                                00 AM, Thu.1:00 AM-Thu.5:00 AM, Fri.1:00 AM-Fri
                                .5:00 AM, Sat.1:00 AM-Sat.5:00 AM}
MountAtStartup                : True
Mounted                       :
Organization                  : JMDev
QuotaNotificationSchedule     : {Sun.1:00 AM-Sun.1:15 AM, Mon.1:00 AM-Mon.1:15
                                AM, Tue.1:00 AM-Tue.1:15 AM, Wed.1:00 AM-Wed.1:
                                15 AM, Thu.1:00 AM-Thu.1:15 AM, Fri.1:00 AM-Fri
                                .1:15 AM, Sat.1:00 AM-Sat.1:15 AM}
RetainDeletedItemsUntilBackup : False
Server                        : DEVDC
ServerName                    : DEVDC
StorageGroup                  : DEVDC\First Storage Group
StorageGroupName              : First Storage Group
IssueWarningQuota             : 1945MB
EventHistoryRetentionPeriod   : 7.00:00:00
Name                          : Mailbox Database
MinAdminVersion               : -2147453113
AdminDisplayName              : Mailbox Database
ExchangeVersion               : 0.1 (8.0.535.0)
DistinguishedName             : CN=Mailbox Database,CN=First Storage Group,CN=I
                                nformationStore,CN=DEVDC,CN=Servers,CN=Exchange
                                 Administrative Group (FYDIBOHF23SPDLT),CN=Admi
                                nistrative Groups,CN=JMDev,CN=Microsoft Exchang
                                e,CN=Services,CN=Configuration,DC=JMDev,DC=org
Identity                      : DEVDC\First Storage Group\Mailbox Database
Guid                          : 5b84b07a-163b-4cff-8b7e-e2aa7a9d3496
ObjectCategory                : JMDev.org/Configuration/Schema/ms-Exch-Private-
                                MDB
ObjectClass                   : {top, msExchMDB, msExchPrivateMDB}
WhenChanged                   : 12/8/2006 9:37:02 AM
WhenCreated                   : 12/8/2006 9:35:24 AM
OriginatingServer             : devdc.JMDev.org
IsValid                       : True

So what is a person to do? well despite the heading being there, you have to specify the -status option to get it populated….

[PS] C:\Documents and Settings\Administrator>get-mailboxdatabase -status | fl
JournalRecipient              :
MailboxRetention              : 30.00:00:00
OfflineAddressBook            :
OriginalDatabase              :
PublicFolderDatabase          :
ProhibitSendReceiveQuota      : 2355MB
Recovery                      : False
ProhibitSendQuota             : 2GB
IndexEnabled                  : True
AdministrativeGroup           : Exchange Administrative Group (FYDIBOHF23SPDLT)
AllowFileRestore              : False
BackupInProgress              : False
CopyEdbFilePath               :
DatabaseCreated               : True
Description                   :
EdbFilePath                   : C:\Program Files\Microsoft\Exchange Server\Mail
                                box\First Storage Group\Mailbox Database.edb
ExchangeLegacyDN              : /o=JMDev/ou=Exchange Administrative Group (FYDI
                                BOHF23SPDLT)/cn=Configuration/cn=Servers/cn=DEV
                                DC/cn=Microsoft Private MDB
HasLocalCopy                  : False
DeletedItemRetention          : 14.00:00:00
LastFullBackup                :
LastIncrementalBackup         :
MaintenanceSchedule           : {Sun.1:00 AM-Sun.5:00 AM, Mon.1:00 AM-Mon.5:00
                                AM, Tue.1:00 AM-Tue.5:00 AM, Wed.1:00 AM-Wed.5:
                                00 AM, Thu.1:00 AM-Thu.5:00 AM, Fri.1:00 AM-Fri
                                .5:00 AM, Sat.1:00 AM-Sat.5:00 AM}
MountAtStartup                : True
Mounted                       : True
Organization                  : JMDev
QuotaNotificationSchedule     : {Sun.1:00 AM-Sun.1:15 AM, Mon.1:00 AM-Mon.1:15
                                AM, Tue.1:00 AM-Tue.1:15 AM, Wed.1:00 AM-Wed.1:
                                15 AM, Thu.1:00 AM-Thu.1:15 AM, Fri.1:00 AM-Fri
                                .1:15 AM, Sat.1:00 AM-Sat.1:15 AM}
RetainDeletedItemsUntilBackup : False
Server                        : DEVDC
ServerName                    : DEVDC
StorageGroup                  : DEVDC\First Storage Group
StorageGroupName              : First Storage Group
IssueWarningQuota             : 1945MB
EventHistoryRetentionPeriod   : 7.00:00:00
Name                          : Mailbox Database
MinAdminVersion               : -2147453113
AdminDisplayName              : Mailbox Database
ExchangeVersion               : 0.1 (8.0.535.0)
DistinguishedName             : CN=Mailbox Database,CN=First Storage Group,CN=I
                                nformationStore,CN=DEVDC,CN=Servers,CN=Exchange
                                 Administrative Group (FYDIBOHF23SPDLT),CN=Admi
                                nistrative Groups,CN=JMDev,CN=Microsoft Exchang
                                e,CN=Services,CN=Configuration,DC=JMDev,DC=org
Identity                      : DEVDC\First Storage Group\Mailbox Database
Guid                          : 5b84b07a-163b-4cff-8b7e-e2aa7a9d3496
ObjectCategory                : JMDev.org/Configuration/Schema/ms-Exch-Private-
                                MDB
ObjectClass                   : {top, msExchMDB, msExchPrivateMDB}
WhenChanged                   : 12/8/2006 9:37:02 AM
WhenCreated                   : 12/8/2006 9:35:24 AM
OriginatingServer             : devdc.JMDev.org
IsValid                       : True

Of course you can shorten it as well

[PS] C:\Documents and Settings\Administrator>get-mailboxdatabase -status | fl mounted

Mounted                       : True