MSSQL 2014: detección de grupo de roles de servidor

Microsoft.SQLServer.2014.ServerRolesGroupDiscovery (Discovery)

Esta detección de objetos rellena el grupo de roles de servidor para que contenga todos los roles de SQL Server.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.ServerRolesGroupDiscovery" Target="Generic!Microsoft.SQLServer.Generic.Presentation.ServerRolesGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Discovery!Microsoft.SQLServer.2014.ServerRole"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.Relationships.ServerRolesGroupContainsServerRoles"]$</RelationshipClass>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>