MSSQL 2017 on Linux Always On: Discover Monitoring Pool Alert Collections

Microsoft.SQLServer.2017.AlwaysOn.Linux.Discovery.MonitoringPoolAlertCollection (Discovery)

This rule discovers a Monitoring Pool Alert Collection for a MSSQL 2017 on Linux Always On. This object is used to collect module errors and warnings from event log of nodes that are the members of the SQL Server 2017 Monitoring Pool.

Knowledge Base article:

Summary

Overrideable 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.	14400
Synchronization Time	Synchronization Time

Element properties:

Target	Microsoft.SystemCenter.AllManagementServersPool
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2017.AlwaysOn.Linux.MonitoringPoolAlertCollection

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2017.Library.DataSource.MonitoringPoolAlertCollectionDiscovery	Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2017.AlwaysOn.Linux.Discovery.MonitoringPoolAlertCollection" Target="SC!Microsoft.SystemCenter.AllManagementServersPool" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2017.AlwaysOn.Linux.MonitoringPoolAlertCollection"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="SQL2017L!Microsoft.SQLServer.2017.Library.DataSource.MonitoringPoolAlertCollectionDiscovery">

    <SyncTime/>

    <IntervalSeconds>14400</IntervalSeconds>

    <MonitoringPoolAlertCollectionClassId>$MPElement[Name='Microsoft.SQLServer.2017.AlwaysOn.Linux.MonitoringPoolAlertCollection']$</MonitoringPoolAlertCollectionClassId>

    <DisplayName>Microsoft SQL Server 2017 on Linux Always On Monitoring Pool Alert Collection</DisplayName>

  </DataSource>

</Discovery>