Can I generate an alert for a service level exception violation? (NETIQKB2045)

goal
Can I generate an alert for a service level exception violation?

fact
Security Manager 5.X

fact
Operations Manager 3.X

fact
Security Manager 3.X

fact
Security Manager 4.X

fix
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

 

Formerly known as NETIQKB2045