Blog Post: https://blakedrumm.com/blog/scom-dw-grooming-tool/
Latest Version: 1.0.5.4
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. You have the option of resetting the values to Defaults for the typical data sets in the Data Warehouse.
You have multiple ways to run the SCOM DW Grooming GUI Tool:
- Download and install the MSI: MSI Download
- Download and run the EXE: EXE Downloads
- Download or Copy the Powershell Script: Powershell Script
You will need to provide the Data Warehouse DB Server Name or Address, and the Data Warehouse Database Name. The script may auto detect these variables from the local registry on the machine you are running the script. To get started, you will need to press the Get Current Settings button. This will allow the script to gather the information from the Data Warehouse database server. Once you make the changes you can save the change with Set.
This script will log some actions to the Application Event Log. Look for the Event Source: SCOMDWTool
You will get prompted each time you run the script to accept the license agreement, unless you select do not ask me again, when you select this it will save a file to your ProgramData Directory: C:\ProgramData\SCOM-DataWarehouseGUI-AgreedToLicense.log