Microsoft.SQLServer.Replication.Windows.Discovery SQL Queries (v7.0.28.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Microsoft.SQLServer.Replication.Windows.Monitoring SQL Queries (v7.0.28.0)
Now that the SQL management packs rely heavily on DLLs it’s not easy to determine what the workflows are doing or how they do it. These are the queries used for many of the workflows within this management pack.
Add Custom Kusto KQL Syntax Highlight to OneNote
1) Install NoteHighlight2016 https://github.com/elvirbrk/NoteHighlight2016/tree/master 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
SCOM Agent Proxy Management Pack v2
Download NEW! Added support for Windows System (HKCU) proxy settings. First, the bad news: This new MP version requires a rip and replace of your previous version (and any overrides). The good news: Now you can manage your System proxy settings easily. Why might you need to manage your Windows System proxy settings? When your …. Read More
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