MSSQL: Individuazione gruppo di disponibilità elevata Always On di SQL Server

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

Questo processo di individuazione oggetti popola il gruppo di disponibilità elevata Always On affinché contenga tutti i gruppi di disponibilità Always On di SQL Server.

Knowledge Base article:

Riepilogo

Questo processo di individuazione oggetti popola il gruppo di disponibilità elevata Always On affinché contenga tutti i gruppi di disponibilità Always On di SQL Server.

Parametri di cui è possibile eseguire l'override

Nome	Descrizione	Valore predefinito
Attivato	Abilita o disabilita il flusso di lavoro.	Sì

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>