MSSQL: Generic Replication Flow Group Discovery

Microsoft.SQLServer.Replication.Core.ReplicationFlowGroupDiscovery (Discovery)

Discovery of Memberships in a Replication Flow Group

Knowledge Base article:

Summary

Discovery of Memberships of Replication Flow Group. Memberships:

Distributor group,

Publisher group,

Subscriber group,

Distributor instance group,

Publisher instance group,

Subscriber instance group,

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes

Element properties:

Target	Microsoft.SQLServer.Replication.Core.ReplicationFlowGroup
Enabled	True
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Replication.Core.ReplicationFlowGroup

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Core.ReplicationFlowGroupDiscovery" Target="Microsoft.SQLServer.Replication.Core.ReplicationFlowGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.ReplicationFlowGroup"/>

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

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

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

      </MembershipRule>

      <MembershipRule>

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

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

      </MembershipRule>

      <MembershipRule>

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

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

      </MembershipRule>

      <MembershipRule>

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

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

      </MembershipRule>

      <MembershipRule>

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

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

      </MembershipRule>

      <MembershipRule>

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

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

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>