A common requirement for more complex MP’s is cookdown. Cookdown is a concept where multiple workflows run on a healthservice, and share a common datasource. When cookdown works properly, the datasource will only execute once, even when called by multiple workflows. This saves precious resources, as these are commonly…
Quick download: SCOM.GatewayMaintenanceMode (github.com) This is an often requested solution – how do we stop alert storms from agents being unavailable when there is a network outage causing it – not a real server down issue? This post is dedicated to a Management Pack based solution for such. This…
This script will modify a Group Membership rule in a management pack, and Add or Remove Windows Computer objects to a group using Explicit membership. This was originally written and published by Russ Slaten. I only modified it to be easier to use for Computer names, some structure, logging, etc.…
In SCOM, when a Cluster Resource Group is not online, or partially online, we have a monitor that alerts on this condition. This alert comes from a Rollup Monitor (Resource Group Rollup Monitor). The problem with using a Rollup Monitor that targets the Cluster Resource Group, is: 1. Rollup Monitors…
This is something I have worked with pretty much every customer on. If you assign agents manually to management servers or gateways, you might want to automate load balancing these agents across multiple management servers. There are some community solutions out there already, but they often can move agents every…
I get this question several times a year. Let’s find out for sure. Create a new Command Channel. For the configuration settings, I will use the following, as this will allow me to write all common alert fields to a logfile: Full Path of the command file: %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe Command line…
In SCOM we often need to create groups of Windows Computer objects, for using Maintenance Mode, Views, Notifications, Overrides, etc. A common need is to create a group of Windows Computers that host a specific application, like SQL, or a custom application class. This cannot easily be done using the…
Monitoring a Process in SCOM can be pretty straightforward, or it can be pretty tricky depending on the application. In this article, I will run through some examples of how to be successful, and what to avoid. First, SCOM provides a “Process Monitoring” template in the console, that works…
We recently released the SQL MP 7.0.32.0 available here: Download This MP brings some features requested by users, but also will require updating the security configuration on all your SQL servers to support these features. What’s New Added a new exclude list option for the “SQL Server Agent Job”…
When using the “Version Agnostic” Microsoft SQL Server Management Pack, one of the changes made was in how we monitor Database and Log free space. In the older version specific management packs, we were required to discover the DB Filegroups, DB files, and DB log files, and apply a…