MSSQL 2016: 探索 SQL Server 2016 Integration Services (Windows Server)

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

此物件探索會探索是否已安裝 SQL Server 2016 Integrate Services。

Knowledge Base article:

摘要

此物件探索會探索是否已安裝 SQL Server 2016 Integration Services。

可覆寫的參數

名稱

描述

預設值

已啟用

啟用或停用該工作流程。

間隔 (秒)

執行工作流程的週期性時間間隔 (秒)。

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>