Group population - VSAE

Dashboard Server
, , ,
2

When deailing with groups I found this URL helpful:

http://blog.scomskills.com/create-a-computer-or-instance-group/

 

I’ve created a group that contains all SQL instances which are hosted on TMG servers.

CLASS Defintion:
<ClassType ID="ABC.Various.Groups.Microsoft.SQLExpress.Instances.TMG" Base="InstanceGroup!Microsoft.SystemCenter.InstanceGroup" Accessibility="Public" Abstract="false" Hosted="false" Singleton="true" Comment="SQL Express DBs used by Microsoft TMG." />

GROUP Discovery:

  <RuleId>$MPElement$</RuleId>
  <GroupInstanceId>$Target/Id$</GroupInstanceId>
  <MembershipRules>
    <MembershipRule>
      <MonitoringClass>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]$</MonitoringClass>
      <RelationshipClass>$MPElement[Name="InstanceGroup!Microsoft.SystemCenter.InstanceGroupContainsEntities"]$</RelationshipClass>
      <Expression>
        <And>
          <Expression>
            <SimpleExpression>
              <ValueExpression>
                <Property>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/Edition$</Property>
              </ValueExpression>
              <Operator>Equal</Operator>
              <ValueExpression>
                <Value>Express Edition</Value>
              </ValueExpression>
            </SimpleExpression>
          </Expression>
          <Expression>
            <RegExExpression>
              <ValueExpression>
                <Property>$MPElement[Name="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</Property>
              </ValueExpression>
              <Operator>MatchesRegularExpression</Operator>
              <Pattern>^[a-zA-Z]{5}VMFW[0-9]{3}.[a-zA-Z0-9]{1,}$</Pattern>
            </RegExExpression>
          </Expression>
        </And>
      </Expression>
    </MembershipRule>
  </MembershipRules>

Hope it helps.

1 Like