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

Microsoft.SQLServer.Core.Discovery.AlwaysOnGroupOfGroups (Discovery)

Cette découverte d'objets remplit le groupe de haute disponibilité Always On pour qu'il contienne tous les groupes de disponibilité Always On SQL Server.

Knowledge Base article:

Résumé

Cette découverte d'objets remplit le groupe de haute disponibilité Always On pour qu'il contienne tous les groupes de disponibilité Always On SQL Server.

Paramètres remplaçables

Nom	Description	Valeur par défaut
Activé	Active ou désactive le flux de travail.	Oui

Element properties:

Target	Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroup
Enabled	True
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroup
Discovered relationships and their attribuets:
Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityGroupGroup Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityReplicaGroup Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsDatabaseReplicaGroup

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SystemCenter.GroupPopulator	Default

Source Code:

<Discovery ID="Microsoft.SQLServer.Core.Discovery.AlwaysOnGroupOfGroups" Enabled="true" Target="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroup" ConfirmDelivery="true" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroup"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityGroupGroup"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityReplicaGroup"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsDatabaseReplicaGroup"/>

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Core.AvailabilityGroupGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityGroupGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>$MPElement[Name="Microsoft.SQLServer.Core.AvailabilityGroupGroup"]$</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Core.AvailabilityReplicaGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsAvailabilityReplicaGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>$MPElement[Name="Microsoft.SQLServer.Core.AvailabilityReplicaGroup"]$</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Core.DatabaseReplicaGroup"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Core.AlwaysOnHighAvailabilityGroupContainsDatabaseReplicaGroup"]$</RelationshipClass>

        <IncludeList>

          <MonitoringObjectId>$MPElement[Name="Microsoft.SQLServer.Core.DatabaseReplicaGroup"]$</MonitoringObjectId>

        </IncludeList>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>