Service Management Automation Database Connection Monitor Type

Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.MonitorType.DatabaseConnection (UnitMonitorType)

Monitor type to test connection to database.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<UnitMonitorType ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.MonitorType.DatabaseConnection" Accessibility="Internal">

  <MonitorTypeStates>

    <MonitorTypeState ID="ConnectionFailure" NoDetection="false"/>

    <MonitorTypeState ID="NoConnectionFailure" NoDetection="false"/>

  </MonitorTypeStates>

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="Interval" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseServer" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseInstance" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="1" name="DatabaseName" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="Interval" Selector="$Config/Interval$" ParameterType="int"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DataSource" TypeID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.DatabaseQuery">

        <Interval>$Config/Interval$</Interval>

        <DatabaseServer>$Config/DatabaseServer$</DatabaseServer>

        <DatabaseInstance>$Config/DatabaseInstance$</DatabaseInstance>

        <DatabaseName>$Config/DatabaseName$</DatabaseName>

        <Query/>

      </DataSource>

      <ConditionDetection ID="CDFailed" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Integer">HRResult</XPathQuery>

            </ValueExpression>

            <Operator>Less</Operator>

            <ValueExpression>

              <Value Type="Integer">0</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="CDPassed" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Integer">HRResult</XPathQuery>

            </ValueExpression>

            <Operator>GreaterEqual</Operator>

            <ValueExpression>

              <Value Type="Integer">0</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="ConnectionFailure">

        <Node ID="CDFailed">

          <Node ID="DataSource"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="NoConnectionFailure">

        <Node ID="CDPassed">

          <Node ID="DataSource"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>