System Center Operations Manager - Data Warehouse Grooming Tool

Posted by : on

powershell   projects   operationsManager   troubleshooting

:book: Introduction

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.

:arrow_down_small: Latest Version

Latest Version
Download Count Releases
Download Count Latest

Check the changelog for the latest version: Latest Changes

:page_with_curl: How to Use

https://aka.ms/SCOM-DW-Grooming-Tool

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
  4. Download or Copy the Powershell Script to Powershell ISE: Text Format Alternative Download Link

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

:page_facing_up: 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 suit my customers, and my own needs.

Email :

Website :

About Blake Drumm

My name is Blake Drumm, I am working on the Azure Monitoring Enterprise Team with Microsoft. Currently working to update public documentation for System Center products and write troubleshooting guides to assist with fixing issues that may arise while using the products. I like to blog on Operations Manager and Azure Automation products, keep checking back for new posts. My goal is to post atleast once a month if possible.

Follow @blakedrumm
Useful Links