Home
  •  

SQL Server 2012 Integration Services (Windows Server) ermitteln

Microsoft.SQLServer.2012.IntegrationServicesDiscoveryRule.Server (Discovery)

Diese Objektermittlung ermittelt, ob SQL Server 2012 Integration Services installiert ist.

Knowledge Base article:

Zusammenfassung

Diese Objektermittlung ermittelt, ob SQL Server 2012 Integration Services installiert ist.

Überschreibbare Parameter

Name

Beschreibung

Standardwert

Aktiviert

Aktiviert oder deaktiviert den Workflow.

Ja

Häufigkeit (Sekunden)

Das wiederkehrende Zeitintervall in Sekunden, in dem der Workflow ausgeführt wird.

14400

Element properties:

TargetMicrosoft.SQLServer.2012.Seed
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2012.IntegrationServicesDiscoveryDataSource Microsoft.SQLServer.SQLDiscoveryAccount

Source Code:

<Discovery ID="Microsoft.SQLServer.2012.IntegrationServicesDiscoveryRule.Server" Enabled="true" Target="Microsoft.SQLServer.2012.Seed">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2012.IntegrationServices">

      <Property TypeID="SQL!Microsoft.SQLServer.ServerRole" PropertyID="InstanceName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.IntegrationServices" PropertyID="ServiceName"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2012.IntegrationServicesDiscoveryDataSource" RunAs="SQL!Microsoft.SQLServer.SQLDiscoveryAccount">

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

    <ServiceName>MsDtsServer110</ServiceName>

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2012.IntegrationServices"]$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

          <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

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

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</Name>

          <Value>$Data/Property[@Name='Name']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.IntegrationServices"]/ServiceName$</Name>

          <Value>$Data/Property[@Name='Name']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="System!System.Entity"]/DisplayName$</Name>

          <Value>$Data/Property[@Name='Name']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.ServerRole"]/Type$</Name>

          <Value>Integration Services</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

  </DataSource>

</Discovery>