此发现规则将发现 SQL Server 2016 数据库引擎实例的 SQL Server 代理。每个数据库引擎实例仅应有一个 SQL Server 代理实例。
此发现规则将发现 SQL Server 2016 数据库引擎实例的 SQL Server 代理。每个数据库引擎实例仅应有一个 SQL Server 代理实例。
名称 | 说明 | 默认值 |
已启用 | 启用或禁用工作流。 | 是 |
频率(秒) | 运行工作流的重复间隔时间(秒)。 | 14400 |
Target | Microsoft.SQLServer.2016.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper | Microsoft.SQLServer.DiscoveryAccount |
<Discovery ID="Microsoft.SQLServer.2016.AgentDiscovery" Target="Microsoft.SQLServer.2016.DBEngine" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2016.Agent">
<Property TypeID="Microsoft.SQLServer.2016.Agent" PropertyID="ServiceName"/>
<Property TypeID="Microsoft.SQLServer.2016.Agent" PropertyID="Account"/>
<Property TypeID="Microsoft.SQLServer.2016.Agent" PropertyID="DisplayName"/>
</DiscoveryClass>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper" RunAs="GPMP!Microsoft.SQLServer.DiscoveryAccount">
<NameSpace>\\$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$\root\Microsoft\SqlServer\ComputerManagement13</NameSpace>
<Query>SELECT ServiceName, StartName, DisplayName FROM SqlService WHERE ServiceName="$Target/Property[Type="Microsoft.SQLServer.2016.DBEngine"]/AgentName$"</Query>
<Frequency>14400</Frequency>
<ClassId>$MPElement[Name="Microsoft.SQLServer.2016.Agent"]$</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.ServerRole"]/InstanceName$</Name>
<Value>$Target/Property[Type="Microsoft.SQLServer.2016.ServerRole"]/InstanceName$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2016.Agent"]/ServiceName$</Name>
<Value>$Data/Property[@Name='ServiceName']$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2016.Agent"]/Account$</Name>
<Value>$Data/Property[@Name='StartName']$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2016.Agent"]/DisplayName$</Name>
<Value>$Data/Property[@Name='DisplayName']$</Value>
</Setting>
</Settings>
</InstanceSettings>
</DataSource>
</Discovery>