Database Connectivity Health Monitor (Mobile Device Manager Log)

Microsoft.SystemCenter.MobileDeviceManager.2008.1_0.GatewayCentralManagementService.DatabaseConnectivity.MobileDeviceManager.CheckGatewayConfigurationintheDatabase.EventBased.UnitMonitor (UnitMonitor)

Knowledge Base article:

Database Connectivity (Aspect)

This aspect contains the Database Connectivity objects that you can monitor in the Gateway Central Management Service. These health monitors include the following detectors.

Green Health States

Event ID 5251: GCM_DATABASE_ACCESS_RESTORED - Gateway Central Management service is connected to the database.
Event ID 5263: GCM_FOUND_SELF_IN_SERVICE_LIST - The Gateway Central Management service successfully retrieved the list of all the other deployed Gateway Central Management services from the database.

Yellow Health States

Event ID 5255: GCM_SKIPPED_INVALID_MESSAGE - Gateway Central Management service ignored an invalid messages. An invalid message may include Gateway configuration and alert requests. Make sure that the Gateway Server configuration is not corrupted.
Event ID 5265: GCM_SHUTDOWN_TIMEOUT - Gateway Central Management service shutdown was delayed because of an error. Try again to stop the service.

Red Health States

Event ID 5250: GCM_UNABLE_TO_ACCESS_DATABASE - Gateway Central Management service did not access the database. Make sure that the database is running and can be accessed from this computer. Validate that the admin service on this computer is running and that the database DNS name can be resolved from this computer.
Event ID 5262: GCM_UNABLE_TO_FIND_SELF_IN_SERVICE_LIST - The Gateway Central Management service was unable to retrieve the list of deployed Gateway Central Management services from the database. Make sure database is running and accessible. Make sure the admin Service is authorized to access the database and that this Device Management server was installed successfully.

Check Gateway Configuration in the Database (Resolution)

To resolve this issue, check the Gateway configuration in the database.

Element properties:

Target

Microsoft.SystemCenter.MobileDeviceManager.2008.1_0.GatewayCentralManagementService.ClassType

Parent Monitor

System.Health.AvailabilityState

Category

StateCollection

Enabled

True

Alert Generate

True

Alert Severity

MatchMonitorHealth

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.Windows.2SingleEventLog2StateMonitorType

Remotable

True

Accessibility

Public

Alert Message

Database Connectivity Alert

{0}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.MobileDeviceManager.2008.1_0.GatewayCentralManagementService.DatabaseConnectivity.MobileDeviceManager.CheckGatewayConfigurationintheDatabase.EventBased.UnitMonitor" Accessibility="Public" Enabled="onEssentialMonitoring" Target="Microsoft.SystemCenter.MobileDeviceManager.2008.1_0.GatewayCentralManagementService.ClassType" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="true">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter.MobileDeviceManager.2008.1_0.GatewayCentralManagementService.DatabaseConnectivity.MobileDeviceManager.CheckGatewayConfigurationintheDatabase.EventBased.UnitMonitor.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/EventDescription$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Success" MonitorTypeStateID="FirstEventRaised" HealthState="Success"/>

    <OperationalState ID="Negative" MonitorTypeStateID="SecondEventRaised" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <FirstComputerName>$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</FirstComputerName>

    <FirstLogName>Mobile Device Manager</FirstLogName>

    <FirstExpression>

      <Or>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery>PublisherName</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value>Device Manager</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery>EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value>5251</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery>PublisherName</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value>Device Manager</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery>EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value>5263</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </Or>

    </FirstExpression>

    <SecondComputerName>$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</SecondComputerName>

    <SecondLogName>Mobile Device Manager</SecondLogName>

    <SecondExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery>PublisherName</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>Device Manager</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery>EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>5255</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </SecondExpression>

  </Configuration>

</UnitMonitor>