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 …. 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 – …. 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 …. Read More
Tracing SCOM Workflows with PowerShell
To run an agent trace from the SCOM Console, see this postSCOM – Trace Workflow Agent Task There have been a number of documents written on tracing over the years but have made it this easy to trace SCOM agent workflows. Tracing is a way to spy on agent activity. This is very helpful, essential …. Read More
Keep Your Management Pack Files Organized
Easily organize and keep track of your management pack file versions.
