MSSQL: Generic Monitoring Pool Watcher Discovery

Microsoft.SQLServer.Core.Discovery.SQLMonitoringPool (Discovery)

The discovery is designed to discover all the watcher nodes contained in the pool. If the pool is empty, it will mirror the contents of All Management Servers pool.

Knowledge Base article:

Summary

SQL Server Monitoring Pool provided with the MP contains SCOM server only. A user can configure this pool by adding a watcher node. Therefore, SQL Server Monitoring Pool Watcher Discovery is designed to discover all the watcher nodes contained in the pool. If the pool is empty, it will mirror the contents of All Management Servers pool.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow.

86400

Element properties:

TargetMicrosoft.SQLServer.Core.SQLMonitoringPool
EnabledTrue
Frequency86400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.Core.DataSource.SQLMonitoringPoolDiscovery Default

Source Code:

<Discovery ID="Microsoft.SQLServer.Core.Discovery.SQLMonitoringPool" Enabled="true" Target="Microsoft.SQLServer.Core.SQLMonitoringPool" ConfirmDelivery="false" Remotable="true" Priority="Normal">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="SC!Microsoft.SystemCenter.ManagementServicePoolWatcher">
<Property TypeID="System!System.Entity" PropertyID="DisplayName"/>
<Property PropertyID="PoolId"/>
<Property PropertyID="PoolName"/>
</DiscoveryClass>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.Core.DataSource.SQLMonitoringPoolDiscovery">
<IntervalSeconds>86400</IntervalSeconds>
</DataSource>
</Discovery>