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
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
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
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!
An easy way to clean out obsolete management pack alias references.
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
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
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 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
2023.07.31: Update – Due to recent changes in Azure/Graph the Services management pack now requires the user account to be assigned the “Message Center Reader” role. We plan to update the MP guide in the near future.(Ref: https://monitoringguys.com/2023/07/28/graph-api-healthoverviews-403-forbidden/ ). We recently updated v3 of the M365 Services Supplemental MP to provide some performance improvements, feature …. Read More