Can I generate an alert for a service level exception violation?
Security Manager 5.X
Operations Manager 3.X
Security Manager 3.X
Security Manager 4.X
Service level exceptions are alerts that have remained in a particular resolution state longer than a specified service level agreement time. These alerts may need attention as soon as possible. You can view these alerts from the MMC | Monitor | All Service Level Exceptions view. Currently, there isn't a native mechanism for alerting on violations to the 'Service Level Exception' policy set in the MMC from the Configuration | Global Settings | Alert Resolution States node.
You may use a SQL query to generate a list of the current Alerts violating SLE agreements, as established by the globally set alert resolution states policy. The parameters of this query are:
DECLARE @ServerUTC datetime
DECLARE @TZ_Bias smallint
EXEC master..xp_coordinatetime @TZ_Bias OUTPUT, @ServerUTC OUTPUT
select * from AlertView AV
inner join ResolutionState RS ON RS.ResolutionId = AV.ResolutionState
where LastTimeStateWasModified < dateadd(mi,-(RS.ExpectedMaxTime * RS.ExpectedMaxTimeUnits),@ServerUTC)
and ResolutionState < 255