Browse by Tags
All Tags »
SQL Query »
SCOM 2007 (
RSS)
One of the users on SystemCenterCommunity requested a SQL query for scom to get the following information: Managed computer, Alert description and Alert severity. I wrote the following SQL query to do...
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...
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...
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...