Browse by Tags
All Tags »
SQL Query (
RSS)
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 computers -- that belong to a specific computer...
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 this query you will be able to display your HP ProLiant...
The following SQL Query will list the unmanaged Windows Server Cluster Computers in the OnePoint Database. -- Scott Moss -- 01-02-2008 -- MOM 2005 Query to enumerate only managed Windows Server Cluster...
This SQL Script will enumerate all Managed Windows Server Cluster Computers in your Onepoint database. -- Scott Moss -- 01-02-2008 -- MOM 2005 Query to enumerate only managed Windows Server Cluster Computers...
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 to brush up on my TSQL. One of the many things...
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 Moss -- 12/16/2007 -- MOM 2005 OnePoint DB Query ...
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' to one of your computer names...
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 for our 11th wedding anniversary and my 36th...
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 Computer group. The results will not include Cluster...
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 all computers that is in the OnePoint Database...
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.live.com/blog/cns!39CE28DB5474A6C7!332.entry Reviewing...
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.live.com/blog/cns!39CE28DB5474A6C7!332.entry Reviewing...
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 to figure out what entries its adding to the OnePoint...
Ever wonder what performance counters are being captured in the OnePoint Database? This SQL script will shed some light as to what is actually being inserted into the one point database. This script specifically...
Useful information if you're going to be creating custom queries against the OperationsManager db Alert table or AlertView. Resolution State ID Resolution State 0 = New 255 = Closed Severity Values...
This query utilizes the SDKAlertView (SQL View) in the OnePoint Database. This query will count the number of alerts per server for a specified period of time. -- SQL CODE -- Count alerts from SDKAlertView...
The following query uses the SDKAlertView (SQL View) to show the number of alerts by severity between a users specified time period. This can be used on both the OnePoint and SystemCenter Reporting Databases...
Run the following query against your OnePoint database, and it will output all the managed computer names --SQL QUERY select Name from Computer WHERE [IsConfigManager]=0 AND ManagedType = '2' AND...