MSSQL on Windows: SQL Server Express DB Engine Group Discovery

Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroup (Discovery)

This discovery rule populates the Express Group on Windows with all SQL Server Express DBEngines on Windows.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.Windows.Discovery.DBEngineExpressGroup" Enabled="true" Target="Microsoft.SQLServer.Windows.DBEngineExpressGroup" ConfirmDelivery="false" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Windows.DBEngineExpressGroupContainsDBEngine"/>

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.Windows.DBEngine"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.Windows.DBEngineExpressGroupContainsDBEngine"]$</RelationshipClass>

        <Expression>

          <RegExExpression>

            <ValueExpression>

              <Property>$MPElement[Name="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Edition$</Property>

            </ValueExpression>

            <Operator>ContainsSubstring</Operator>

            <Pattern>Express Edition</Pattern>

          </RegExExpression>

        </Expression>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>