MSSQL 2014 : Découverte de réplicas SQL Server Always On

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

Cette découverte d’objets remplit le réplica Always On pour contenir tous les réplicas de disponibilité SQL Server.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnReplicasDiscovery" Enabled="true" Target="GPMP!Microsoft.SQLServer.Generic.Presentation.AlwaysOnAvailabilityReplicasGroup" ConfirmDelivery="true" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

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

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

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>