SCOM-DataCollector

• Fixed Menu not working with Gather All.
• Fixed Overrides.sql Output

SCOM-DataCollector

• Added Menu for Navigating the Options for the Script, Menu will show when you run without any switches, ie. .\DataCollector.ps1.

SCOM-DataCollector

• Modified Overrides.sql Query to gather more information. Thank you Tiago Fernandes!

SCOM-DataCollector

• Added -SQLLogs Switch to allow gathering the OperationsManager and DataWarehouse DB's Logs, outputs to: '.\SQL Logs'

SCOM-DataCollector

• Updated .\OpsDB\Overrides.sql query to provide more information regarding overrides, the output now has the following columns:
  • WorkflowType
  • WorkflowName
  • overridename
  • overrideableparametername
  • OverrideValue
  • OverrideDescription
  • OverrideEnforced
  • OverrideScope
  • TargetedInstanceName
  • TargetedInstancePath
  • ORMPName
  • ORMPDescription
  • ORMPSealed
  • OverrideLastModified
  • OverrideCreatedOn

SCOM-DataCollector

• Added new function to now gather from TLS Configuration from Registry Settings with the -CheckTLS Switch. (Thank you Mike K, Brook H and other SCEM Engineers)

SCOM-DataCollector

• Added SQL Log Location TSQL Query for the OpsDB and DW (thank you Mike K).
• Updated Management Pack Export. It now by default exports both Sealed and Unsealed Management Packs.

SCOM-DataCollector

Add ability to gather UseMIAPI from registry for every Management Server 2016 RTM and up.