Just a reminder.(I have written about this before the SP1). In Ops Mgr 2007 SP1 (and without) the alert history is groomed out before the alerts is resolved with the result that open alerts get an empty alert history.
But by own experience, I forgot to re-apply the fix to the stored procedure p_AlertGrooming after upgrading to SP1. So again my alert history is groomed out before the alerts is closed. So the Ops Mgr 2007 SP1 still have this small but annoying BUG. Upgrading to SP1 over writes your fixed stored procedure. You can fix it with this little change to the stored procedure.
Edit the stored procedure p_AlertGrooming in the Ops Mgr DB like this:
1. Log into the server that hosts the OperationsManager database.
2. Open Microsoft SQL Server Management Studio.
3. Expand Databases > OperationsManager > Programmability > Stored Procedures > dbo.p_AlertGrooming.
4. Right-click dbo.p_AlertGrooming and select Modify.
5. Find the following two lines in the SQLQuery:
DELETE dbo.AlertHistory
WHERE TimeAdded < @GroomingThresholdUTC
6. Comment-out these two lines with “--" and add a comment:
-- Changed to keep alert history until alert is resolved
-- DELETE dbo.AlertHistory
-- WHERE TimeAdded < @GroomingThresholdUTC
7. Execute the query, which will "save" the stored procedure.
8. Close the query, and when prompted to save changes, click No.
Now the Alert History stays intact until the Alert is Resolved.
