This is where all scripts and SQL Queries I find useful for SCOM and SQL will be stored. If you have any questions, please feel free to submit an issue or a pull request.
Started tracking on February 13th, 2021
Read the blog post here: https://blakedrumm.com/blog/scom-data-collector/
This tool can be used to modify the System Center Operations Manager Data Warehouse Grooming retention days, allows you to see grooming history, you can manually run grooming, and you may also export the current configuration so you can keep a backup of your settings.
Go to script location: Click Here
This tool allows you to reconfigure System Center Operations Manager's Databases in the configuration file, registry, and SQL Database Tables. This tool utilizes Powershell to provide a GUI for being able to easily navigate and verify the settings.
Go to script location: Click Here