MSSQL on Windows Replication: Discover Local Alert Collections

Microsoft.SQLServer.Replication.Windows.LocalAlertCollectionDiscovery (Discovery)

This rule discovers a Local Alert Collection for a MSSQL on Windows Replication. This object is used to collect module errors and warnings from event log of SCOM agents that monitor Local SQL Server DB Engine instances.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Windows.LocalAlertCollectionDiscovery" Enabled="true" Target="SqlDiscW!Microsoft.SQLServer.Windows.LocalDiscoverySeed" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="SqlDiscW!Microsoft.SQLServer.Windows.DataSource.LocalAlertCollectionDiscovery">

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

    <DisplayName>Microsoft SQL Server on Windows Replication Local Alert Collection</DisplayName>

    <MonitoringPoolClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection']$</MonitoringPoolClassId>

    <IntervalSeconds>14400</IntervalSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <SyncTime/>

  </DataSource>

</Discovery>