Clean All Obsolete MP References From Your SCOM Management Group
An easy way to clean out obsolete management pack alias references.
Create a group for disabled SQL engines
My customer has many custom monitoring workflows that target the MSSQL on Windows: DB Engine (Microsoft.SQLServer.Windows.DBEngine) class. For various reasons some of those engines are disabled and they wanted an easy way to override these workflows only for the disabled engines. My goal here is to dynamically populate a group with only disabled SQL engines. …. Read More
Reset SCOM Object Health and Alerts Task
Newly added to the SCOMAgentHelper management pack is a task that is capable of: In the example below you can see the Exchange Online service object has alerts generated from both a rule and a monitor. The task parameter, “ResetMontitorHealth”, is true and therefore will reset the health of the eligible monitors for the instance. …. Read More
ExpressionType variable may be ignored if not formatted correctly
you must not include newlines and/or spaces when referencing the expressiontype variable
SCOM Management Pack Comparison Organization Chart Made Easy with Powershell
Keeping your management packs in sync across management groups can be a challenge. Here’s an easy way to create a comparison chart/report with PowerShell.
Verify SQL Server Securables with SCOM Agent Task
This management pack contains two tasks as shown in the screenshot below.(Or run the scripts manually, see here.) History: 2022.01.07.1719 – v1.0.0.12 – Added ‘msdb.dbo.SQLAGENT_SUSER_SNAME’ per Hugh Scott’s suggestion.
Microsoft.SQLServer.Windows.Monitoring SQL Queries (v7.0.32.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
How do I change the passwords for accounts used in the M365 SMP?
As with most IT Organizations the requirement to change service account passwords has turned out to be a fairly common task. We recently received some questions about changing the passwords in the M365 SMP so I figured that we would cover this in a post and provide instructions on how to change the passwords for …. Read More
Windows Clusters – Discover Multiple Virtual Servers
I ran into a situation last month where my customer noticed that there were numerous Windows Failover Cluster role server names (aka ‘network name’ aka ‘virtual name’) that were not getting discovered by SCOM.
