Search

Search for words used in entries on this website

Enter the words[s] to search for here:

Sponsors

OpsMgr 2007: Severity and Resolution State Values for Alerts

Scott Moss writes: 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 for Alerts
0 = INFORMATIONAL
1 = WARNING
2 = CRITICAL

Example Query using OperationsManager database, this query will display all alerts that are Critical: select * from dbo.Alert where Severity = '2'

Name:			Remember personal info? Yes No
Email:
URL:
Comment:		Emoticons / Textile
Before sending a comment, you have to correctly answer a simple question you know the answer to. This is a countermeasure against automated spam bots. What are the first four letters of Techlog?     ( Register your username / Log in )
Notify:		Yes, send me email when someone replies.
Hide email:		Yes, hide my email address.
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.