SCOM-DataCollector - v3.6.8-1

• Added: WITH(NOLOCK) to some of the SQL queries in the Data Collector. These should no longer lock the tables when querying data.

• Other small changes.

SCOM-DataCollector - v3.6.8

• Fix Best Practice Analyzer for Event 33333 to include Monitor ID: f1baeb56-8cce-f8c7-79ae-d69796c9d926
• Added MP_EventDescription_BadPractice.sql to Operations Manager DB querys list. This will tell us if you are using EventDescription in a rule or monitor. Which is bad practice: https://kevinholman.com/2008/04/22/using-event-description-as-criteria-for-a-rule/

SCOM-DataCollector - v3.6.7-1

• -GetLocalSecurity : Fixed issue when attempting to parse SID's that don't have a Account in Active Directory.

SCOM-DataCollector - v3.6.7

• Added SQL Query to gather OMS/Advisor information from OpsMgr DB:

select * from MT_Microsoft$SystemCenter$Advisor$Settings

• Attempted fix for CSV Output of: -GetRunAsAccounts
• New Switch Added: -AdditionalEventLogs
  Example: .\DataCollector-v3.6.7.ps1 -AdditionalEventLogs Security, Setup

SCOM-DataCollector - v3.6.6

• 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.

SCOM-DataCollector - v3.6.5

• Fixed SCOM Port Checker invalid switch present in internal script.
• Added switch -GetNotificationSubscriptions which will allow you to gather your Notification Subscription Details.

SCOM-DataCollector - v3.6.4

• Added more Checks to Initial Accessibility Check for Management Servers and Agents.
  

• Updated Port Checker Script.

SCOM-DataCollector - v3.6.3

• Attempted some more fixes for General Information.txt output.
• Added new switch -LeastAmount , which will gather the least amount of data from SCOM. (only SQL Queries, Pending Management, and General Information)
• New Query added, HeathService_Avail_Last_7days.sql, this will gather the HealthService Availability Changes and why they changed.

SCOM-DataCollector - v3.6.2

• Fixed error with General Information gather on Remote Management Servers.
• Updated TLS Registry Checker to include more information.
• Other small updates.

SCOM-DataCollector - v3.6.1

• Renamed a few queries to *_OpsDB.sql.
• Added Orphaned.sql SQL Query.
• Added Best Practice Check to analyze whether you have (MMA) Agent Configured on a Management Server.