System Center Operations Manager - Data Warehouse Grooming Tool

Posted by : on

Category : powershell   projects   operationsManager

Latest Version

Latest Version
Download Count Latest


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.

How to Use

You have multiple ways to download the SCOM DW Grooming GUI Tool:

  1. Download and install the MSI: MSI Download
  2. Download and run the EXE: EXE Downloads
  3. Download or Copy the Powershell Script to Powershell ISE: 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 from. You can run on any machine that has network connectivity to the SCOM DW SQL Server. 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

More Information

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

If you have any questions or concerns, please leave a comment and I will do my best to assist!

Page Views

Share on:
About Blake Drumm
Blake Drumm

I like to collaborate and work on projects. My skills with Powershell allow me to quickly develop automated solutions to suite my customers, and my own needs.

Email : [email protected]

Website :

About Blake Drumm

This is the personal technical blog for Blake Drumm. Currently primarily focused towards Microsoft System Center Enterprise Management Products. I am an Microsoft Support Engineer on the System Center North America Support Team. I am new to blogging. July 6th, 2021 marks my first day as a Microsoft FTE converting from a contractor. I had been working as a contractor since January 2020. Continue to check back for new posts or tips. I like to continually update this page as time permits.

Follow @blakedrumm
Useful Links