Skip to content

SCOM-DataCollector - v3.6.6
Compare
Choose a tag to compare
@blakedrumm blakedrumm released this 09 Aug 22:24
· 926 commits to master since this release
v-3.6.6
1010e61
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
  • Removed the -GetNotificationSubscriptions from the -All switch.
  • New Query Added to Data Warehouse Queries: DW_Perf_byManagedEntity.sql
  • Updated SQL Query RunasProfiles.sql to include the Domain of the Account.
select r.RuleDefaultName, pr.ObjectName, pr.CounterName, mp.ManagementPackDefaultName as MPName, COUNT(me.ManagedEntityDefaultName) AS Total
from Perf.vPerfRaw perf
join vPerformanceRuleInstance PRI on perf.PerformanceRuleInstanceRowId = PRI.PerformanceRuleInstanceRowId
join vPerformanceRule pr on PRI.RuleRowId = PR.RuleRowId
join vManagedEntity me on perf.ManagedEntityRowId = ME.ManagedEntityRowId
join [dbo].[vRule] r on r.RuleRowId = PR.RuleRowId
join vManagementPack mp on r.ManagementPackRowId = mp.ManagementPackRowId
where perf.DateTime > GetUTCDate() -48
GROUP BY PR.ObjectName, PR.CounterName, r.ruledefaultname, mp.ManagementPackDefaultName
ORDER BY COUNT (me.ManagedEntityDefaultName) DESC
  • Updated the Best Practice Analyzer to detect for Mismatch between DW Writer Account in the DW and the RunAs Profile for the Data Warehouse Action Account.

Download Count v3.6.6

Assets 3
Loading