Operations Manager 2007: Severity and Resolution State Values for Alerts
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'
Expect a few more example queries in a few weeks.