MSSQL 2016: 填充 SQL Server Express 2016 实例组

Microsoft.SQLServer.2016.ExpressInstancesGroupContainsDBEngine.Discovery (Discovery)

此发现规则将使用所有 SQL Server Express 2016 数据库引擎填充 Express 实例组。

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2016.ExpressInstancesGroupContainsDBEngine.Discovery" Target="Microsoft.SQLServer.2016.ExpressInstancesGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2016.ExpressInstancesGroup"/>

  </DiscoveryTypes>

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

    <RuleId>$MPElement$</RuleId>

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

    <MembershipRules>

      <MembershipRule>

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

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2016.ExpressInstancesGroupContainsDBEngine"]$</RelationshipClass>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>Express Edition</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>