Home
  •  

Populate Microsoft SQL Server 2005 Replication Computers Group

Microsoft.SQLServer.2005.PopulateSQLServersReplicationGroup (Discovery)

This object discovery populates the SQL Server 2005 Replication Component computer group with all computers that are running an instance of SQL Server 2005 DB Engine and have some replication component configured.

Knowledge Base article:

Summary

This object discovery populates the SQL Server 2005 Replication Component computer group with all computers that are running an instance of SQL Server 2005 DB Engine and have some replication component configured.

Configuration

This discovery is enabled by default.

Element properties:

TargetMicrosoft.SQLServer.2005.ReplicationComputerGroup
EnabledTrue
RemotableFalse

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.2005.PopulateSQLServersReplicationGroup" Enabled="true" Target="Microsoft.SQLServer.2005.ReplicationComputerGroup">

  <Category>Discovery</Category>

  <DiscoveryTypes/>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Windows!Microsoft.Windows.Computer"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="SC!Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass>

        <Expression>

          <Contains>

            <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2005.Distributor"]$</MonitoringClass>

          </Contains>

        </Expression>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Windows!Microsoft.Windows.Computer"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="SC!Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass>

        <Expression>

          <Contains>

            <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2005.Publisher"]$</MonitoringClass>

          </Contains>

        </Expression>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Windows!Microsoft.Windows.Computer"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="SC!Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass>

        <Expression>

          <Contains>

            <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2005.Subscriber"]$</MonitoringClass>

          </Contains>

        </Expression>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>