Script: Monitoring and Reporting MOM Console Connections for Multiple Mgmt Servers

If you want to skip the chat and get the script from the MOMResources.org script archive (in the MOM Administration section), click  here.   And for the rest of you, here's a quick runthrough of the scripts functionality. I've always thought it would be handy to have a way to track MOM console connections in a meaningful way. Specifically, I wanted a script that would Report Connections to Management Servers Individually Dynamically chart connections in a performance object per Management Server Raise a warning event if we get close to the max recommended of 15 on a given management server So, I started with a T-SQL String I found in a Tim Minter post:   master","SELECT program_name, count(*) FROM Master.DBO.sysprocesses WHERE ecid=0 and program_name='Microsoft Operations Manager - DAS Operations Console' GROUP BY program_name ORDER BY count(*) desc   And modified it slightly to expose connections for individual mgmt servers, like so.   SELECT hostname, program_name, count(*) as ConnCount FROM Master.DBO.sysprocesses WHERE ecid=0 and program_name='Microsoft Operations Manager - DAS Operations Console' GROUP BY hostname,program_name ORDER BY count(*) desc   Wrote a simple script and added sub routines for 1) Dynamically charting connections for any mgmt server added to your environment without any intervention on your part 2) A call to a sub routine to generate a warning in MOM if connections break a user-defined threshold.   In terms of shortcomings, there is the fact that the script doesn't account for 0 connections, but just leaves the datapoint blank in the performance charts and goes on. I suppose we could get creative and work around that, but I found I really didnt care, because I just wanted to watch the upper limit (and 0 connections doesn't happen in my environment much :) ). I am sure someone creative out there in the community will address that.     Cheers, Pete