MSSQL on Windows Integration Services: Alerts Scope Group Discovery

Microsoft.SQLServer.IS.Windows.AlertsScopeGroupDiscovery (Discovery)

This object discovery populates the Alerts Scope group to contain all SQL Server Roles.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.IS.Windows.AlertsScopeGroupDiscovery" Target="SqlCoreLib!Microsoft.SQLServer.Core.SQLServerAlertsScopeGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="SqlCoreLib!Microsoft.SQLServer.Core.SQLServerAlertsScopeGroup"/>

  </DiscoveryTypes>

  <DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">

    <RuleId>$MPElement$</RuleId>

    <GroupInstanceId>$Target/Id$</GroupInstanceId>

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="IS!Microsoft.SQLServer.IS.Windows.LocalInstance"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.IS.Windows.Relationships.AlertsScopeGroupContainsServiceRoles"]$</RelationshipClass>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="IS!Microsoft.SQLServer.IS.Windows.LocalSeed"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.IS.Windows.Relationships.AlertsScopeGroupContainsSeed"]$</RelationshipClass>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>