클라이언트 모니터링 오류 그룹 - 영향 받은 고유 사용자 수 성능 수집 규칙

Microsoft.SystemCenter.CM.AEM.Internal.BucketUserCountPerfCollection (Rule)

이 규칙은 오류 그룹마다 영향 받은 총 고유 사용자 수와 관련된 성능 데이터를 수집할 수 있도록 합니다.

Knowledge Base article:

Element properties:

Member Modules:

Source Code:

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

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="Scheduler" TypeID="System!System.Scheduler">

      <Scheduler>

        <SimpleReccuringSchedule>

          <Interval Unit="Minutes">15</Interval>

        </SimpleReccuringSchedule>

        <ExcludeDates/>

      </Scheduler>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="PerfDataWriter" TypeID="Microsoft.SystemCenter.CM.AEM.Internal.MapQueriedPerfData">

      <Query>DECLARE @TableName NVARCHAR(1000), @Query NVARCHAR(1000);SELECT @TableName = ManagedTypeTableName FROM ManagedType WHERE TypeName = 'Microsoft.SystemCenter.CM.AEM.WatsonBucket';SET @Query = N'select count(*), SourceEntityId from AemRelationship AR join [' + @TableName + '] WB on AR.SourceEntityId = WB.BaseManagedEntityId where RelationshipTypeId = 0 and EntityTypeId = 1 group by SourceEntityId';EXEC sp_executesql @Query</Query>

      <ObjectName>Bucket</ObjectName>

      <CounterName>BucketUniqueUsersAffected</CounterName>

      <Value>Columns/Column[1]</Value>

      <ManagedEntityId>Columns/Column[2]</ManagedEntityId>

      <RuleId>$MPElement[Name="AEMViewsInternal!Microsoft.SystemCenter.CM.AEM.Views.Internal.BucketUserCountPerfCollector"]$</RuleId>

    </WriteAction>

  </WriteActions>

</Rule>