Author: Tyson Paul

0 commentsAzureAzure ADAzure SQLManagement PacksSCOM 2016

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

0 commentsSCOM 2016discoverymanagement packscom

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

0 commentsAuthoringManagement PacksSCOM 2016TroubleshootingHealthStateMaintenanceOperationsManager DBStale StateChangeState ChangeState Data

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

0 commentsAuthoringManagement PacksTroubleshooting

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

0 commentsAzure ADSCOM 2016Troubleshooting

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

0 commentsAuthoringManagement PacksTroubleshooting

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

0 commentsManagement PacksSCOM 2016SCOM 2019SCOM 2022

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

2 commentsSCOM 2016alertsmanagement packpowershellreset healthscom

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

0 commentsSCOM 2016

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