Frågedatakälla för Service Management Automation-databas

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

Datakällmodul som ansluter till databasen och kör en fråga.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.DataSource.DatabaseQuery" 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"/>

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

  </Configuration>

  <OverrideableParameters>

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

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

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

          <Scheduler>

            <SimpleReccuringSchedule>

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

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ProbeAction ID="OleDbProbe" TypeID="System!System.OleDbProbe">

          <ConnectionString>Provider=SQLNCLI11;Server=$Config/DatabaseServer$\$Config/DatabaseInstance$;Database=$Config/DatabaseName$;Integrated Security=SSPI</ConnectionString>

          <Query>$Config/Query$</Query>

          <GetValue>true</GetValue>

          <QueryTimeout>0</QueryTimeout>

          <GetFetchTime>true</GetFetchTime>

        </ProbeAction>

      </MemberModules>

      <Composition>

        <Node ID="OleDbProbe">

          <Node ID="Scheduler"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>System!System.OleDbData</OutputType>

</DataSourceModuleType>