Add permissions to an Azure App Registration
Detailed guide to add delegated Azure app registration permissions.
Verify SQL Server Securables with SCOM Agent Task
This management pack contains two tasks as shown in the screenshot below.(Or run the scripts manually, see here.) History: 2022.01.07.1719 – v1.0.0.12 – Added ‘msdb.dbo.SQLAGENT_SUSER_SNAME’ per Hugh Scott’s suggestion.
Verify SQL Server Securables with PowerShell
Display the access configuration status of SQL Server Database securables on Windows.(There’s also a management pack with agents tasks located here.) DBEngine Securables Database Securables
Microsoft.SQLServer.Windows.Monitoring SQL Queries (v7.0.32.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.
SCOM Agent Proxy Management Pack
New! Version 2 Here This is an easy solution to configure your SCOM agents to use an HTTP proxy. The SCOM agent uses a special configuration file for Powershell probe HTTP traffic. The agent takes its orders from a local config file located at: <agent install path>\MonitoringHost.exe.config( In the case of my test agent-managed computer: …. Read More
Where is my SCOM group?
Groups are defined in management packs. When you create a group in the Console, it gets stored in an unsealed management pack. At the time of this writing, there is no easy way to determine where groups are saved/stored/defined. This can become painful when trying to create monitors or rules in the Console with the …. Read More
Workflow Analyzer for SCOM is back!
2022.06.21 UPDATE: New version (v2) released. Get it here. Good news! The workflow troubleshooting tool that you might remember from over a decade ago is back and better than ever. Some good folks with the System Center product group have recently listened to this engineer’s crying and pleading. It has finally been rebooted with a …. Read More
SCOM – Trace Workflow Agent Task
Launch a task, see what the agent is doing. It’s that easy. This post is going to be short and sweet, right to the point with brief instructions on how to get agent trace data in front of your eyeballs as fast as possible. There are basically two types of SCOM traces:1) General – Capture …. Read More
Configuring SQL Logins for SCOM Accounts Made Easy
Credit where it’s due: tidbytez and K. Brian Kelley on mssqltips.com There are two scenarios that I’ll cover here: Clone an existing SQL login with comprehensive stored procedures. This is useful when changing/replacing existing SCOM accounts.Create new logins with appropriate permissions based on login type/role. This is useful for:- Moving/restoring a SCOM database to a new …. Read More