Client Monitoring Error Group Entities' Grooming Rule

Microsoft.SystemCenter.CM.AEM.Internal.DeleteErrorGroups (Discovery)

This rule enables grooming of error groups.

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SystemCenter.CM.AEM.Internal.DeleteErrorGroups" Target="AEMLib!Microsoft.SystemCenter.CM.AEM.CrashListener" Enabled="true" ConfirmDelivery="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"/>

  </DiscoveryTypes>

  <DataSource ID="AemMEDataForDeletionDS1" TypeID="Microsoft.SystemCenter.CM.AEM.Internal.AemMEDataForDeletionDS">

    <Days>14</Days>

    <Query1>DECLARE @ViewName NVARCHAR(1000), @Query NVARCHAR(1000);SELECT @ViewName = ManagedTypeViewName FROM ManagedType WHERE TypeName = 'Microsoft.SystemCenter.CM.AEM.WatsonBucket';SET @Query = N'SELECT wb.ApplicationName, wb.ApplicationVersion, wb.Parameter1, wb.Parameter2, wb.Parameter3, wb.Parameter4, wb.Parameter5, wb.Parameter6, wb.Parameter7, wb.Parameter8, wb.Parameter9, wb.Parameter10, wb.Parameter11, wb.BucketType FROM ' + @ViewName + ' wb JOIN AemCrashCounters acc ON wb.BaseManagedEntityId = acc.SourceEntityId WHERE datediff(dd, acc.LastModified, getutcdate()) &gt;=</Query1>

    <Query2>AND acc.EntityTypeId = 1';EXEC sp_executesql @Query</Query2>

    <ManagedEntity>

      <Detailed>

        <TimeGenerated UseCurrent="true"/>

        <DiscoveryType>Remove</DiscoveryType>

        <DiscoverySourceType>Rule</DiscoverySourceType>

        <SourceObjectId>$MPElement$</SourceObjectId>

        <SourceManagedEntityId>$Target/Id$</SourceManagedEntityId>

        <Properties>

          <Evaluate If="//Columns/Column[1]">

            <Property ID="KeyValuesParamSet">//Columns/Column</Property>

          </Evaluate>

        </Properties>

        <PropertySets/>

        <ClassInstances>

          <ClassInstance If="//Columns/Column[1]">

            <TypeId>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]$</TypeId>

            <Properties>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.Application"]/ApplicationName$</Name>

                <Value>KeyValuesParamSet[0]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.Application"]/ApplicationVersion$</Name>

                <Value>KeyValuesParamSet[1]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter1$</Name>

                <Value>KeyValuesParamSet[2]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter2$</Name>

                <Value>KeyValuesParamSet[3]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter3$</Name>

                <Value>KeyValuesParamSet[4]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter4$</Name>

                <Value>KeyValuesParamSet[5]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter5$</Name>

                <Value>KeyValuesParamSet[6]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter6$</Name>

                <Value>KeyValuesParamSet[7]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter7$</Name>

                <Value>KeyValuesParamSet[8]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter8$</Name>

                <Value>KeyValuesParamSet[9]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter9$</Name>

                <Value>KeyValuesParamSet[10]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter10$</Name>

                <Value>KeyValuesParamSet[11]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/Parameter11$</Name>

                <Value>KeyValuesParamSet[12]</Value>

              </Property>

              <Property>

                <Name>$MPElement[Name="AEMLib!Microsoft.SystemCenter.CM.AEM.WatsonBucket"]/BucketType$</Name>

                <Value>KeyValuesParamSet[13]</Value>

              </Property>

            </Properties>

          </ClassInstance>

        </ClassInstances>

        <RelationshipInstances/>

      </Detailed>

    </ManagedEntity>

  </DataSource>

</Discovery>