MOM 2005 Event Storm past 1 day Part 2
This is just like Jason Harter SQL script, I just modified it to query the past 1 days worth of events.
To see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry
Reviewing this on a regular basis (depending on the size of your environment) will help you identify possible problems before they get out of control.
NOTE: Change "YOURSERVERNAME" to the name of a server that you'd like to review the events of.
-- MOM 2005 Event Storm past 1 day Part 2
-- Scott Moss 09/01/07
-- http://myitforum.com/cs2/blogs/smoss
-- OnePoint or SCDW MOM 2005
-- This is just like Jason Harter sql script, I just modified it to query the past day.
-- to see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry
Declare @Server varchar(30)
SET @Server = 'YOURSERVERNAME' -- type a server name
SELECT ComputerName, Message, COUNT(*) AS EventCount
FROM SDKEventView
WHERE (DateDiff(D, TimeGenerated, GetDate()) <= 1) AND ComputerName=@Server
GROUP BY Message,ComputerName
ORDER BY EventCount DESC