SQL MP Debug Logging – On/Off with a Simple Agent Task
Sometimes you need to activate SQL Management Pack debugging. The SCOM product group makes it relatively easy; by creating a registry key to instantly begin writing debug information to the Operations Manager event log. ‘HKLM:\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\SQL Management Packs\EnableEvtLogDebugOutput\SQL Server MP’ To make things even easier, here are two tasks: Enable: Disable Logging should begin …. Read More
M365 Monitoring – Filter Service Alerts with Selective Discovery
The current version of the management pack has really cool logic baked into the service incident alert rules so that only one alert should exist at any given time for a specific incident, regardless of how many updates are added to the incident. However, every time an update is provided, the previous alert is closed …. Read More
Microsoft Graph API test script for M365 Services
Here’s an easy snippet for doing some basic testing of M365 services via Microsoft Graph. Don’t forget that your app registration permissions must be correct before you will find any success with this test. App Registration Permission App registration permissions shown below at the time of this writing.NOTE: Message Center Reader role is required as …. Read More
M365 Services Supplemental Monitoring Management Pack v3
We recently updated v3 of the M365 Services Supplemental MP to provide some performance improvements, feature enhancements and address a few general housekeeping items, we are excited to announce it is now available for download!
Clean All Obsolete MP References From Your SCOM Management Group
An easy way to clean out obsolete management pack alias references.
SCOM Management Pack for Azure SQL Managed Instance
This won’t be an exhaustive tutorial on all facets of the MP, only my notes on my experiences with manual vs automatic monitoring setup of the Azure SQL MI MP ( https://www.microsoft.com/en-US/download/details.aspx?id=101203 ). It will mostly be screenshots and notes of how I accomplished setup for both approaches specifically for my lab. Basic Requirements Note: …. Read More
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
Cleaning old health state change data made easy
The SCOM Maintenance MP that I published in 2022 made purging discovery data and config synch effortless. Newly added to the MP are the following agent tasks: OpsDB DW State change history is recorded for every monitored object when the health state for any monitor changes between Healthy, Warning, and Critical. If the object is …. Read More
Detected malicious verification code error
Detected malicious verification code when verifying element of type Microsoft.EnterpriseManagement.Configuration.ManagementPackRule with inner exception: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary When building a management pack in Visual Studio you may run into this very ambiguous error shown below. This can happen for a number of reasons Summary I should have used the …. Read More
Graph API healthOverviews 403 Forbidden
Heading I use the M365 Services Supplemental Monitoring management pack in my lab. I recently noticed that calls to:https://graph.microsoft.com/v1.0/admin/serviceAnnouncement/healthOverviews within my application have been failing with “403 Forbidden“. A few other folks that I know started seeing the same problem. Nothing had changed on our ends, we all checked absolutely everything. All other Graph calls …. Read More