As you might seen your Alert History information is groomed out from the OperationsManagerDB for non resolved alerts in Operations Manager 2007. This is caused of the stored procedure p_AlertGrooming. The part of the stored procedure that makes this is:
DELETE dbo.AlertHistory
WHERE TimeAdded < @GroomingThresholdUTC
and if you like me would like to have your Alert History intact until the Alert is resolved you should change this to:
DELETE dbo.AlertHistory
WHERE TimeAdded < @GroomingThresholdUTC
AND ResolutionState = 255
With this change of the stored procedure the Alert History is intact until the Alert is Resolved.
Sunday, January 13, 2008
Alert History groomed out before Alert is Resolved
Posted by
Pontus Blomqvist
at
12:34 PM
