MSSQL 2012 : Découverte de groupe de haute disponibilité SQL Server Always On

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

Cette découverte d'objets remplit le groupe de haute disponibilité Always On avec tous les groupes de disponibilité SQL Server 2012 Always On.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

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

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

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

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

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

        <IncludeList>

          <MonitoringObjectId>297B6FC9-B1C7-45EF-19FF-15D3B12FBB3E</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

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

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

        <IncludeList>

          <MonitoringObjectId>9429553C-BA22-C465-572E-6A0ACD8173ED</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

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

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

        <IncludeList>

          <MonitoringObjectId>58F64176-F489-2D26-96E3-404E49283845</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>