Discover SQL Server Components Group membership

Microsoft.SQLServer.ComponentsGroupDiscovery (Discovery)

Populates the Components group with all SQL Server 2008, 2008 R2 and 2012 related components.

Knowledge Base article:

Summary

This object discovery populates the Components group to contain all SQL Server 2008, 2008 R2 and 2012 related components.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Element properties:

TargetMicrosoft.SQLServer.ComponentsGroup
EnabledTrue
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
Discovered relationships and their attribuets:

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.ComponentsGroupDiscovery" Target="Microsoft.SQLServer.ComponentsGroup" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.ComponentsGroup"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.ComponentsGroupContainsEntity"/>
</DiscoveryTypes>
<DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="Microsoft.SQLServer.ServerRole"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.ComponentsGroupContainsEntity"]$</RelationshipClass>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Component"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.ComponentsGroupContainsEntity"]$</RelationshipClass>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Database"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.ComponentsGroupContainsEntity"]$</RelationshipClass>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="Microsoft.SQLServer.DBPerspective"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.ComponentsGroupContainsEntity"]$</RelationshipClass>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>