MOM 2005 SQL Script: Alerts past 1 day Part 2
After using part 1 to get a list of the offending computer names, use part 2 to find out what all the noise is about. Don't forget to change 'YOURCOMPUTERNAMEHERE' to one of your computer names from part 1. Enjoy!
-- Alerts past 1 day Part 2
-- Scott Moss 10/03/07
-- OnePoint MOM 2005
-- Enter Computer name and get the alert details
-- for all alerts past 1 day with repeat count higher than 0.
Declare @Server varchar(30)
SET @Server = 'YOURCOMPUTERNAMEHERE' -- type a server name
SELECT ComputerName, [Name], COUNT(*) AS AlertCount
FROM SDKAlertView
WHERE RepeatCount > 0
and (DateDiff(D, TimeOfLastEvent, GetDate()) <= 1) AND ComputerName=@Server
GROUP BY [Name],ComputerName
ORDER BY AlertCount DESC