MSSQL on Windows Integration Services: Server Roles Group Discovery

Microsoft.SQLServer.IS.Windows.ServerRolesGroupDiscovery (Discovery)

This object discovery populates the Server Roles group to contain all SQL Server Roles.

Knowledge Base article:

Summary

This object discovery populates the Server Roles group to contain all SQL Server Roles.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Element properties:

TargetMicrosoft.SQLServer.Core.ServerRolesGroup
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.IS.Windows.ServerRolesGroupDiscovery" Target="SqlCoreLib!Microsoft.SQLServer.Core.ServerRolesGroup" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="SqlCoreLib!Microsoft.SQLServer.Core.ServerRolesGroup"/>
</DiscoveryTypes>
<DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="IS!Microsoft.SQLServer.IS.Windows.LocalInstance"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="Microsoft.SQLServer.IS.Windows.Relationships.ServerRolesGroupContainsServerRoles"]$</RelationshipClass>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>