Monitoraggio a tre stati delle stored procedure MySQL

Microsoft.MySQLStoredProcedure.ThreeState.MonitorType (UnitMonitorType)

Element properties:

RunAs	Default
Accessibility	Public
Support Monitor Recalculate	True

Member Modules:

ID	Module Type	TypeId	RunAs
Scheduler	DataSource	System.Scheduler	Default
Probe	ProbeAction	Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction	Default
CD_MatchCritical	ConditionDetection	System.ExpressionFilter	Default
CD_MatchHealthy	ConditionDetection	System.ExpressionFilter	Default
CD_MatchWarning	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
Interval	int	$Config/Interval$	Intervallo di monitoraggio a tre stati delle stored procedure MySQL	Intervallo di monitoraggio a tre stati delle stored procedure MySQL
MySQLDatabaseName	string	$Config/MySQLDatabaseName$	Nome del database MySQL delle stored procedure MySQL	Nome del database MySQL delle stored procedure MySQL
MySQLPort	string	$Config/MySQLPort$	Porta MySQL delle stored procedure MySQL	Porta MySQL delle stored procedure MySQL
MySQLStoredProcedureName	string	$Config/MySQLStoredProcedureName$	Nome della stored procedure MySQL	Nome della stored procedure MySQL
MySQLStoredProcedureParameters	string	$Config/MySQLStoredProcedureParameters$	Parametri della stored procedure MySQL	Parametri della stored procedure MySQL

Source Code:

<UnitMonitorType ID="Microsoft.MySQLStoredProcedure.ThreeState.MonitorType" Accessibility="Public">

  <MonitorTypeStates>

    <MonitorTypeState ID="Healthy"/>

    <MonitorTypeState ID="Warning"/>

    <MonitorTypeState ID="Critical"/>

  </MonitorTypeStates>

  <Configuration>

    <IncludeSchemaTypes>

      <SchemaType>System!System.ExpressionEvaluatorSchema</SchemaType>

    </IncludeSchemaTypes>

    <xsd:element name="TargetSystem" type="xsd:string"/>

    <xsd:element name="Interval" type="xsd:unsignedInt"/>

    <xsd:element name="MySQLDatabaseName" type="xsd:string"/>

    <xsd:element name="MySQLPort" type="xsd:string" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="MySQLStoredProcedureName" type="xsd:string"/>

    <xsd:element name="MySQLStoredProcedureParameters" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="RowFilterExpression" type="ExpressionType"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="HealthyExpression" type="ExpressionType"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="WarningExpression" type="ExpressionType"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="CriticalExpression" type="ExpressionType"/>

  </Configuration>

  <OverrideableParameters>

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

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

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="Scheduler" TypeID="System!System.Scheduler">

        <Scheduler>

          <SimpleReccuringSchedule>

            <Interval Unit="Seconds">$Config/Interval$</Interval>

            <SyncTime/>

          </SimpleReccuringSchedule>

          <ExcludeDates/>

        </Scheduler>

      </DataSource>

      <ProbeAction ID="Probe" TypeID="Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction">

        <TargetSystem>$Config/TargetSystem$</TargetSystem>

        <MySQLDatabaseName>$Config/MySQLDatabaseName$</MySQLDatabaseName>

        <MySQLPort>$Config/MySQLPort$</MySQLPort>

        <MySQLStoredProcedureName>$Config/MySQLStoredProcedureName$</MySQLStoredProcedureName>

        <MySQLStoredProcedureParameters>$Config/MySQLStoredProcedureParameters$</MySQLStoredProcedureParameters>

        <RowFilterExpression>$Config/RowFilterExpression$</RowFilterExpression>

      </ProbeAction>

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

        <Expression>$Config/HealthyExpression$</Expression>

      </ConditionDetection>

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

        <Expression>$Config/WarningExpression$</Expression>

      </ConditionDetection>

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

        <Expression>$Config/CriticalExpression$</Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="Healthy">

        <Node ID="CD_MatchHealthy">

          <Node ID="Probe">

            <Node ID="Scheduler"/>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="Warning">

        <Node ID="CD_MatchWarning">

          <Node ID="Probe">

            <Node ID="Scheduler"/>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="Critical">

        <Node ID="CD_MatchCritical">

          <Node ID="Probe">

            <Node ID="Scheduler"/>

          </Node>

        </Node>

      </RegularDetection>

    </RegularDetections>

    <OnDemandDetections>

      <OnDemandDetection MonitorTypeStateID="Healthy">

        <Node ID="CD_MatchHealthy">

          <Node ID="Probe"/>

        </Node>

      </OnDemandDetection>

      <OnDemandDetection MonitorTypeStateID="Warning">

        <Node ID="CD_MatchWarning">

          <Node ID="Probe"/>

        </Node>

      </OnDemandDetection>

      <OnDemandDetection MonitorTypeStateID="Critical">

        <Node ID="CD_MatchCritical">

          <Node ID="Probe"/>

        </Node>

      </OnDemandDetection>

    </OnDemandDetections>

  </MonitorImplementation>

</UnitMonitorType>