Browse by Tags

All Tags » SQL Query (RSS)
The following should help MOM Admins get a good picture of what is going on in their onepoint database. It will require you to groom out all but one days...
Posted by smoss | with no comments
Filed under: ,
One of the users on SystemCenterCommunity requested a SQL query for scom to get the following information: Managed computer, Alert description and Alert...
Posted by smoss | with no comments
Well someone finally asked for this so I'm sharing. Enjoy! -- Scott Moss -- 04-11-2008 -- mom 2005 query to enumerate managed windows server cluster...
Posted by smoss | 1 comment(s)
Filed under: ,
After adding the HP ProLiant Server ver 1.0 MP for Operations Manager I noticed the addition of some HP tables in the Operations Manager database. Using...
Posted by smoss | with no comments
The following SQL Query will list the unmanaged Windows Server Cluster Computers in the OnePoint Database. -- Scott Moss -- 01-02-2008 -- MOM 2005 Query...
Posted by smoss | with no comments
Filed under: ,
This SQL Script will enumerate all Managed Windows Server Cluster Computers in your Onepoint database. -- Scott Moss -- 01-02-2008 -- MOM 2005 Query to...
Posted by smoss | with no comments
Filed under: ,
Well this week was a hoot, its always fun the week before you take a week off. Anyway I got a chance to spend a few hours with a Microsoft SQL Guru, trying...
The following query will find all clients whose configuration or data package is being rejected by the MOM Management Server in the past day. -- Scott...
Posted by smoss | with no comments
Filed under: ,
After using part 1 to get a list of the offending computer names, use part 2 to find out what all the noise is about. Don't forget to change 'YOURCOMPUTERNAMEHERE'...
Posted by smoss | with no comments
Filed under: ,
Woot I'm finally caught up from being off work for 4 days two weeks ago. My wife and I were able to escape the children for a few days in the mountains...
Posted by smoss | with no comments
Filed under: ,
MOM 2005 SQL Query to return Only Managed computers that belong to a Computer Group This query returns only Agent Managed Computers names for a specific...
Posted by smoss | with no comments
Filed under: ,
The following SQL Script will return a count of the number of computers that belong to each computer group in your OnePoint Database. This count includes...
Posted by smoss | with no comments
Filed under: ,
This is just like Jason Harter SQL script, I just modified it to query the past 1 days worth of events. To see the original go to http://jharter.spaces...
Posted by smoss | with no comments
Filed under: ,
This is just like Jason Harter SQL script, I just modified it to query the past 1 days worth of events. To see the original go to http://jharter.spaces...
Posted by smoss | with no comments
Filed under: ,
After using the script in part one, you notice a server that is dumping a large number of performance counters into the OnePoint database, use this script...
Posted by smoss | with no comments
Filed under: ,
More Posts Next page »