Skip to content

Releases: blakedrumm/SCOM-Scripts-and-SQL

SCOM-DataCollector - v3.8.8

28 Jul 15:47
6a2f432
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed columns returned with User Rights Assignment (-GetLocalSecurity).

Additions

Download Count v-3.8.8

SCOM-DataCollector - v3.8.7

18 Jul 19:36
cc34efe
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed Latency checker Best Practice Analyzer.

Additions

  • Added TLS Cipher Suites to the -CheckTLS parameter.

Download Count v-3.8.7

SCOM-DataCollector - v3.8.6

14 Jul 15:43
8fbb580
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed the -MSInfo32 switch to allow it gather with the -All switch.

Download Count v-3.8.6

SCOM-DataCollector - v3.8.5

28 Jun 19:29
4dc052c
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed DBSize Query for OperationsManager and Data Warehouse Databases.
  • Modified the Grooming_Logs_OpsDB.sql query to not include seconds in the value field.

Additions

  • Added WinHTTP Proxy information to General Information.

Download Count v-3.8.5

SCOM-DataCollector - v3.8.4

16 Jun 06:14
025ccea
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed small issue with the -GetConfiguration switch.
  • Fixed issue with Product Version Detection for SCOM 2022 Agent.
  • Updated internal SCOM / SQL Build Version lists.

Additions

  • Modified -GetConfiguration switch to gather registry data on more paths:
    • HKLM:\SYSTEM\CurrentControlSet\services\HealthService
    • HKLM:\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0
    • HKLM:\SOFTWARE\Microsoft\System Center\2010
    • HKLM:\SOFTWARE\Microsoft\System Center Operations Manager\12
  • Added User Roles, so you will now get a full list of User Roles and their Members.

Download Count v-3.8.4

SCOM-DataCollector - v3.8.3

07 Jun 18:08
0a68847
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fixed All Menu Option, now will gather Configuration as originally intended.
  • Local Security / User Rights will now collect again, there was a bug that has been fixed.
  • Fixed alot of tiny bugs.
  • Script will now run from Powershell ISE as intended.

Download Count v-3.8.3

SCOM-DataCollector - v3.8.2

05 Apr 15:58
81d8697
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • Fix issue with Output Folder not being created when running the parameter -SQLOnly. (Thank you Pascal Wechsler for reporting this issue)
  • Added better error handling for select-object with OpsMgrAC registry key, when running -CheckTLS.
  • Attempt to fix the output of the Best Practice Analyzer so that all detected items are not written to the same line.

Additions

  • Added new SQL Query: Maintenance_Mode_ManagementServers.sql

More Information

Download Count v-3.8.2

SCOM-DataCollector - v3.8.1

18 Mar 20:53
437b800
Compare
Choose a tag to compare

Change Log

Bug Fixes

  • You will now get prompted everytime you run the script without a -Yes parameter, that asks you if you want to run the script as another account.
  • Attempted to fix GpResult to allow it to return correctly.
  • Fixed several small bugs in General Information.
  • Attempt to fix error reporting to Error.log.
  • Updated -CheckTLS it will now verify if you have OBDC Driver v11, 13, 17, or 18 installed.
  • Updated -GetRulesAndMonitors, it will now return the correct data for Rules / Monitors where it would fail before.
  • Fixed issue with -GetLocalSecurity not returning correctly for the local machine. Also attempted to add better error handling.
  • Fixed issue with -GetInstallLogs where it would not correctly copy the files due to paths being invalid.
  • $ManagementServer internal variable that would return incorrectly due to an issue with how I was calculating the correct server, this is now fixed.
  • Configuration Checker has been fixed to work with the -ManagementServers parameter.
  • Fixed issue when relaunching the script as another account, this was caused by the first question (Do you want to run as SDK?), this is now fixed and should no longer be an issue.
  • Connectivity test to remote file shares should no longer fail if you are actually able to access them.
  • Other small unlisted fixes.

Additions

  • Linux Agent Authentication Type has been added to General Information.txt (Kerberos / Basic) - https://docs.microsoft.com/en-us/system-center/scom/manage-linux-kerberos-auth?view=sc-om-2019#enable-or-disable-kerberos-authentication-on-a-management-or-a-gateway-server

  • Updated script internal SQL Product version list to latest released.

  • Added ability to output script runtime information into the version file that is in the output zip (datacollector-v3.8.1 file).

    Script Running as User:
    contoso\Administrator
    
    Script Running on Server:
    MS01-2019
    
    Script Path:
    C:\DataCollector\DataCollector.ps1
    
    Parameters Passed:
    -AssumeYes  -SkipConnectivityTests  -ManagementServers MS02-2019 
    
    Script execution started on date/time:
    March 18, 2022 @ 1:49 PM
    
    Script execution completed on date/time:
    March 18, 2022 @ 1:54 PM
    
  • New Parameter -SkipConnectivityTests

  • New Parameter -SkipGeneralInformation

  • New Parameter -SkipSQLQueries

  • New Script Auto Updater will be included. This will allow you to download the latest version of the Data Collector from the internet. (Option 4 in the Built-in Menu OR the new file included in the release Script-Auto-Updater.ps1).

  • Added System Uptime to General Information.

  • Added w32tm gathering to the General Information text file, to assist with issues relating to time skew.

  • Added Best Practice Anaylzer to Output of Script Execution.

  • Added ability for Best Analyzer to be run against local and remote Management Servers.

  • The Report Builder will be included in the Release Assets going forward.


More Information

  • You now have more control over the Data Collector with the ability to skip checks / general information gathering.

    Example 1

    If you want to gather the Event Logs from all Management Servers and THATS IT:

    .\DataCollector.ps1 -SkipSQLQueries -SkipGeneralInformation -GetEventLogs

    Example 2

    If you want to skip connectivity checks and attempt to get as much data as possible:

    .\DataCollector.ps1 -SkipConnectivityTests -All
    
  • The only gathering the script does by default when the script is run, is the General Information.txt file and the SQL Queries. But you can exclude these with the following parameters: -SkipGeneralInformation -SkipSQLQueries

Download Count v-3.8.1

SCOM-DataCollector - v3.8.0

05 Feb 19:45
08c3d8d
Compare
Choose a tag to compare

Bug Fixes

  • Fixed General Information Gathering for DB information.
  • Note.txt is now working as intended.
  • Updated a few SQL Queries.
  • Improved Web Console version detection.

Additions

  • You can now see if Always On is Enabled for the SCOM SQL DB Instances. This information is in the General Information text file, as well as the SQL Properties for the Operations Manager and Data Warehouse databases.

Known Issues

  • Configuration Checker does not work correctly when you specify specific Management Servers with the -ManagementServers parameter.

Download Count v3.8.0

SCOM-DataCollector - v3.7.9

07 Jan 00:57
0d6699f
Compare
Choose a tag to compare

Bug Fixes

  • Fixed Is_Broker_Enabled detection for OpsMgr and DW databases in General Information.txt.
  • Fixed a few issues with General Information.
  • Other minor fixes.

Additions

  • Source will now be included in the assets with each release, named: SCOM-DataCollector-Source.zip

Download Count v3.7.9