Découverte des groupes de fichiers de base de données SQL Server 2008

Microsoft.SQLServer.2008.DBFileGroupDiscovery (DataSourceModuleType)

Ce type de module permet de découvrir les instances du groupe de fichiers de base de données SQL Server 2008

Element properties:

Show References:
- Discoveries (1)

Type	DataSourceModuleType
Isolation	Any
Accessibility	Internal
RunAs	Microsoft.SQLServer.SQLDiscoveryAccount
OutputType	System.Discovery.Data

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.EventProvider	Default
Script	ProbeAction	Microsoft.SQLServer.2008.DBFileGroupScriptProbeDiscovery	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
TimeoutSeconds	int	$Config/TimeoutSeconds$	Délai d'expiration (en secondes)	Spécifie la durée pendant laquelle le flux de travail est autorisé à s'exécuter avant d'être fermé et marqué comme ayant échoué.

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2008.DBFileGroupDiscovery" Accessibility="Internal" RunAs="SQL!Microsoft.SQLServer.SQLDiscoveryAccount">

  <Configuration>

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

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

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

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

  </Configuration>

  <OverrideableParameters>

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.EventProvider">

          <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

          <LogName>Operations Manager</LogName>

          <Expression>

            <And>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery>PublisherName</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value>Health Service Script</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

                    <XPathQuery>EventDisplayNumber</XPathQuery>

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value>4001</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <RegExExpression>

                  <ValueExpression>

                    <XPathQuery>Params/Param[1]</XPathQuery>

                  </ValueExpression>

                  <Operator>ContainsSubstring</Operator>

                  <Pattern>Management Group: $Target/ManagementGroup/Name$. Database Discovery: $Config/SQLInstanceName$</Pattern>

                </RegExExpression>

              </Expression>

            </And>

          </Expression>

        </DataSource>

        <ProbeAction ID="Script" TypeID="Microsoft.SQLServer.2008.DBFileGroupScriptProbeDiscovery">

          <NetworkName>$Config/NetworkName$</NetworkName>

          <SQLConnectionString>$Config/SQLConnectionString$</SQLConnectionString>

          <SQLInstanceName>$Config/SQLInstanceName$</SQLInstanceName>

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

        </ProbeAction>

      </MemberModules>

      <Composition>

        <Node ID="Script">

          <Node ID="DS"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

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

</DataSourceModuleType>