Author: Tyson Paul

0 commentsSCOM 2016

Add Custom Kusto KQL Syntax Highlight to OneNote

1) Install NoteHighlight2016 2) Modify Ribbon file “C:\Program Files\CodingRoad\NoteHighlight2016\ribbon.xml“ Add this line as shown in the screenshot: 3) Create custom .lang file for your language Understanding the .lang File Markup The .lang file is a configuration file used by the NoteHighlight extension to highlight the syntax of code. Here’s a breakdown of the structure: ….  Read More

0 commentsAuthoringManagement PacksTroubleshooting

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

0 commentsM365PowershellSCOM 2016M365Microsoft Graph APIpowershell

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

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 ( ). 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