MSSQL on Windows: All SQL Server Filegroups Group Discovery

Microsoft.SQLServer.Windows.Discovery.FilegroupsGroup (Discovery)

Discovery of All SQL Server Filegroups Group on Windows.

Knowledge Base article:

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Element properties:

TargetMicrosoft.SQLServer.Windows.FilegroupsGroup
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.Windows.Discovery.FilegroupsGroup" Target="Microsoft.SQLServer.Windows.FilegroupsGroup" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.Windows.FilegroupsGroup"/>
</DiscoveryTypes>
<DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="SqlDiscW!Microsoft.SQLServer.Windows.DBFilegroup"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Windows.FilegroupsGroupContainsDBFilegroup"]$</RelationshipClass>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="SqlDiscW!Microsoft.SQLServer.Windows.DBFilegroupFd"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Windows.FilegroupsGroupContainsDBFilegroupFd"]$</RelationshipClass>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="SqlDiscW!Microsoft.SQLServer.Windows.DBFilegroupFx"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Windows.FilegroupsGroupContainsDBFilegroupFx"]$</RelationshipClass>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>