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: 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 in an …. 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
Visual Studio New SCOM Management Pack Project HRESULT: 0x80041FE1
If Visual Studio doesn’t have the necessary components installed, VS may fail to open your management pack project. Here’s an example of a failure when creating a new SCOM management pack. The ActivityLog.xml shows some interesting entries… C:\Users\typaul\AppData\Roaming\Microsoft\VisualStudio\17.0_56cc09fb Notice all the failures related to “Modeling.Sdk“ Solution Launch the Installer to modify the VS 2022 installation …. Read More
SQL Always On Availability Group Listener monitoring management pack
New! 2023.06.22: Now supports Distributed Network Names (DNN)! Make sure you have the newest version. Version History: Download: Requirements: Discovery This MP contains a single discovery workflow which targets the MSSQL on Windows: Local DB Engine class and uses two PowerShell modules. The first module will query the SQL instance to obtain information about all …. Read More
Configure default schema for SCOM management pack fragments in Visual Studio / VSAE
If you’ve ever used Visual Studio with the Visual Studio Authoring Extensions (VSAE) for authoring a management pack for SCOM you have likely run into the annoying problem where VS forgets how to identify the schema for SCOM stuff which causes Intellisense to fail. I can’t explain why it sometimes will or won’t auto load …. 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
SCOM Console Web Page View: index of all rules and monitors with knowledge articles
Required: Create a new Rule. Create a new MP with name: “IndexOfWorkflowKnowledge” Rule Name: GenerateWorkflowIndex Timed PowerShell Script RuleRule Target: Management ServerRule is not enabled. Override: ENABLE for one specific mgmt server to start with, the one you connect to with your Console. Add additional mgmt servers if needed. Create a new Web Page View …. Read More