Idera SQL DM MonitorType Instance Alert Counts

Idera.SQLDM.MonitorType.InstanceAlertCounts (UnitMonitorType)

This MonitorType examines the alerts counts for a specified SQL Instance and generates the current health state (Critical, Warn or Normal)

Element properties:

Show References:
- Unit Monitors (1)

RunAs	Default
Accessibility	Public
Support Monitor Recalculate	False

Member Modules:

ID	Module Type	TypeId	RunAs
DataSource	DataSource	Idera.SQLDM.DataSource.SqlInst.AlertCounts	Default
CritFilter	ConditionDetection	System.ExpressionFilter	Default
NormFilter	ConditionDetection	System.ExpressionFilter	Default
WarnFilter	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector
Debug	bool	$Config/Debug$
SyncTime	string	$Config/SyncTime$
IntervalSeconds	int	$Config/IntervalSeconds$

Source Code:

<UnitMonitorType ID="Idera.SQLDM.MonitorType.InstanceAlertCounts" Accessibility="Public">

  <MonitorTypeStates>

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

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

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

  </MonitorTypeStates>

  <Configuration>

    <xsd:element minOccurs="1" name="Debug" type="xsd:boolean"/>

    <xsd:element minOccurs="1" name="IntervalSeconds" type="xsd:integer"/>

    <xsd:element minOccurs="1" name="SyncTime" type="xsd:string"/>

    <xsd:element minOccurs="1" name="InstanceName" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="Debug" Selector="$Config/Debug$" ParameterType="bool"/>

    <OverrideableParameter ID="SyncTime" Selector="$Config/SyncTime$" ParameterType="string"/>

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DataSource" TypeID="Idera.SQLDM.DataSource.SqlInst.AlertCounts">

        <Debug>$Config/Debug$</Debug>

        <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

        <SyncTime>$Config/SyncTime$</SyncTime>

        <InstanceName>$Config/InstanceName$</InstanceName>

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Integer">Property[@Name='CriticalAlerts']</XPathQuery>

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Integer">Property[@Name='WarningAlerts']</XPathQuery>

                </ValueExpression>

                <Operator>Greater</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Integer">Property[@Name='CriticalAlerts']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Integer">Property[@Name='CriticalAlerts']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Integer">Property[@Name='WarningAlerts']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="CriticalState">

        <Node ID="CritFilter">

          <Node ID="DataSource"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="WarningState">

        <Node ID="WarnFilter">

          <Node ID="DataSource"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="NormalState">

        <Node ID="NormFilter">

          <Node ID="DataSource"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>