MSSQL 2014: Populate SQL Server 2014 Database Group

Microsoft.SQLServer.2014.DatabaseGroupDiscovery (Discovery)

This discovery rule populates the Database group with all SQL Server 2014 Databases.

Knowledge Base article:

Summary

This discovery rule populates the Database group with all SQL Server 2014 Databases.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Element properties:

TargetMicrosoft.SQLServer.2014.DatabaseGroup
EnabledTrue
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.DatabaseGroupDiscovery" Target="Microsoft.SQLServer.2014.DatabaseGroup" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2014.DatabaseGroup"/>
</DiscoveryTypes>
<DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2014.Database"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.DatabaseGroupContainsDatabase"]$</RelationshipClass>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>