Gegevensbron voor lengte van de berichtenwachtrij in Service Management Automation

Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.MessageQueueLength (DataSourceModuleType)

Gegevensbronmodule die verbinding maakt met de database en het aantal records in de tabel Berichtenwachtrij verzamelt.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.MessageQueueLength" RunAs="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DatabaseAccount" Accessibility="Internal" Batching="false">

  <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>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

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

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

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

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

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

          <Query>select count(*) from Queues.Message</Query>

        </DataSource>

        <ConditionDetection ID="DBConnection" 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>

        <ConditionDetection ID="MapToPerf" TypeID="Performance!System.Performance.DataGenericMapper">

          <ObjectName>Orchestrator Worker Performance Counters</ObjectName>

          <CounterName>Message Queue Length</CounterName>

          <InstanceName/>

          <Value>$Data/Columns/Column$</Value>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="MapToPerf">

          <Node ID="DBConnection">

            <Node ID="DB"/>

          </Node>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>Performance!System.Performance.Data</OutputType>

</DataSourceModuleType>