MSSQL 2014: detección de grupos de alta disponibilidad Always On de SQL Server

Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnGroupOfGroupsDiscovery (Discovery)

Esta detección de objetos rellena el grupo de alta disponibilidad Always On para que contenga todos los grupos de disponibilidad Always On de SQL Server 2014.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnGroupOfGroupsDiscovery" Enabled="true" Target="Views2014!Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailability" ConfirmDelivery="true" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityGroupGroup"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityReplicaGroup"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsDatabaseReplicaGroup"/>

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Views2014!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityGroupGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>D0D74F41-07B0-4700-FF62-FED63B4306DB</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Views2014!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsAvailabilityReplicaGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>8D9D7DCB-36CB-7D9E-41FD-49EDA24E2335</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Views2014!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnHightAvailabilityContainsDatabaseReplicaGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>D7187FC0-F516-6E52-2A82-E9C28766B1D4</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>