Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction (ProbeActionModuleType)

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<ProbeActionModuleType ID="Microsoft.MySQLStoredProcedure.WSMan.RetrieveRows.ProbeAction" Accessibility="Public" Batching="true" PassThrough="false">

  <Configuration>

    <IncludeSchemaTypes>

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

    </IncludeSchemaTypes>

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

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

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

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

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

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

  </Configuration>

  <OverrideableParameters>

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

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

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <ProbeAction ID="PA" TypeID="Oss!Microsoft.Oss.WSMan.Enumerate.ProbeAction">

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

          <Uri>http://schemas.microsoft.com/wbem/wscim/1/cim-schema/2/MySQL_StoredProcedureRow_AsXML?__cimnamespace=root/mysql</Uri>

          <Filter>Select RowXMLValue From MySQL_StoredProcedureRow_AsXML where DatabaseName= "$Config/MySQLDatabaseName$" OR StoredProcedureName= "$Config/MySQLStoredProcedureName$" OR parameters="$Config/MySQLStoredProcedureParameters$" OR Port="$Config/MySQLPort$"</Filter>

          <OutputErrorIfAny>true</OutputErrorIfAny>

          <SplitItems>true</SplitItems>

        </ProbeAction>

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

          <Expression>

            <Exists>

              <ValueExpression>

                <XPathQuery Type="String">/DataItem/WsManData/*[local-name(.)="MySQL_StoredProcedureRow_AsXML"]/*[local-name(.)="RowXMLValue"]</XPathQuery>

              </ValueExpression>

            </Exists>

          </Expression>

        </ConditionDetection>

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

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

        </ConditionDetection>

        <ConditionDetection ID="Mapper" TypeID="Microsoft.Test.XmlStringToDataItemMapper">

          <XmlString>$Data/WsManData/*[local-name(.)="MySQL_StoredProcedureRow_AsXML"]/*[local-name(.)="RowXMLValue"]$</XmlString>

          <DataItemName>Results</DataItemName>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="RowFilter">

          <Node ID="Mapper">

            <Node ID="CheckIfValid">

              <Node ID="PA"/>

            </Node>

          </Node>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>WSM!Microsoft.SystemCenter.WSManagement.WSManData</OutputType>

  <TriggerOnly>true</TriggerOnly>

</ProbeActionModuleType>