Home
  •  

MSSQL 2016: Erkennen von SQL Server 2016 Integration Services (Windows Server)

Microsoft.SQLServer.2016.IntegrationServices.Discovery.Instance (Discovery)

Diese Objekterkennung erkennt, ob SQL Server 2016 Integration Services installiert ist.

Knowledge Base article:

Zusammenfassung

Diese Objekterkennung erkennt, ob SQL Server 2016 Integration Services installiert ist.

Parameter, die außer Kraft gesetzt werden können

Name

Beschreibung

Standardwert

Aktiviert

Aktiviert oder deaktiviert den Workflow.

Ja

Intervall (Sekunden)

Das periodische Intervall in Sekunden, in dem der Workflow ausgeführt werden soll.

14400

Element properties:

TargetMicrosoft.SQLServer.2016.IntegrationServices.Seed
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.IntegrationServices.DataSource.InstanceDiscovery Microsoft.SQLServer.DiscoveryAccount

Source Code:

<Discovery ID="Microsoft.SQLServer.2016.IntegrationServices.Discovery.Instance" Enabled="true" Target="Microsoft.SQLServer.2016.IntegrationServices.Seed">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2016.IntegrationServices.Instance">

      <Property TypeID="Microsoft.SQLServer.2016.IntegrationServices.Instance" PropertyID="InstanceName"/>

      <Property TypeID="Microsoft.SQLServer.2016.IntegrationServices.Instance" PropertyID="ServiceName"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2016.IntegrationServices.DataSource.InstanceDiscovery" RunAs="GPMP!Microsoft.SQLServer.DiscoveryAccount">

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

    <ServiceName>MsDtsServer130</ServiceName>

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2016.IntegrationServices.Instance"]$</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="Microsoft.SQLServer.2016.IntegrationServices.Instance"]/InstanceName$</Name>

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

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2016.IntegrationServices.Instance"]/Type$</Name>

          <Value>Integration Services</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="Microsoft.SQLServer.2016.IntegrationServices.Instance"]/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>

      </Settings>

    </InstanceSettings>

  </DataSource>

</Discovery>