Windows Azure SQL Database Cloud Service Single Query Discovery Data Provider

Microsoft.SqlServer.Azure.Module.SingleQueryDiscoveryDataSource (DataSourceModuleType)

This module allows to execute single SQL query to discover objects in Windows Azure SQL Database Cloud Service.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SqlServer.Azure.Module.SingleQueryDiscoveryDataSource" RunAs="Microsoft.SqlServer.Azure.Profile.Workflow" Accessibility="Internal">

  <Configuration>

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

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

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

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

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

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

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

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

  </Configuration>

  <OverrideableParameters>

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

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

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

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.BaseScriptedDiscoveryDataSource">

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

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

          <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

          <DiscoveryName>$Config/DiscoveryName$</DiscoveryName>

          <Script>Param ($ServerName, $DatabaseName, $Username, $Password)



function Main {

    WithRetry {$connection = (Create-SqlConnection $ServerName $DatabaseName $Username $Password)} {

        $DiscoveryData = $ScriptApi.CreateDiscoveryData(0, '$MPElement$', '$Target/Id$')



        With ($command = $connection.CreateCommand()) {

            $command.CommandText = $Query

            $connection.Open()



            With (,($Reader = $command.ExecuteReader())) {

                $Config/ProcessingScript$

            }

        }



        $DiscoveryData

    }

}



                  $Query = @"

$Config/Query$

"@

                </Script>

          <Parameters>

            <Parameter>

              <Name>ServerName</Name>

              <Value>$Config/ServerName$</Value>

            </Parameter>

            <Parameter>

              <Name>DatabaseName</Name>

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

            </Parameter>

            <Parameter>

              <Name>Username</Name>

              <Value>$RunAs[Name="Microsoft.SqlServer.Azure.Profile.Sql"]/UserName$</Value>

            </Parameter>

            <Parameter>

              <Name>Password</Name>

              <Value>$RunAs[Name="Microsoft.SqlServer.Azure.Profile.Sql"]/Password$</Value>

            </Parameter>

            <Parameter>

              <Name>Query</Name>

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

            </Parameter>

          </Parameters>

        </DataSource>

      </MemberModules>

      <Composition>

        <Node ID="DS"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

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

</DataSourceModuleType>