Discover SQL Server Computer Group membership

Microsoft.SQLServer.Library.GenericComputerGroupDiscovery (Discovery)

Populates the computer group to contain all computers running SQL Server 2008, 2008 R2 or 2012.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.Library.GenericComputerGroupDiscovery" Target="Generic!Microsoft.SQLServer.Generic.Presentation.ComputersGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Generic!Microsoft.SQLServer.Generic.Presentation.ComputersGroup"/>

  </DiscoveryTypes>

  <DataSource ID="DiscoveryDataSource" 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.ServerRole"]$</MonitoringClass>

          </Contains>

        </Expression>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>