MSSQL 2017: Generic Discover SQL Server Computer Group Membership

Microsoft.SQLServer.2017.Library.Discovery.SQLComputerGroup (Discovery)

Populates the computer group to contain all computers running SQL Server 2017 DB Engines.

Knowledge Base article:

Summary

This object discovery populates the computer group to contain all computers running SQL Server 2017 DB Engines.

Overrideable Parameters

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

Element properties:

Target	Microsoft.SQLServer.Generic.Presentation.ComputersGroup
Enabled	True
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Generic.Presentation.ComputersGroup

Member Modules:

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

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

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

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

        <Expression>

          <Contains>

            <MonitoringClass>$MPElement[Name="SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine"]$</MonitoringClass>

          </Contains>

        </Expression>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>