I found this in the content exchange area and think it may be a good starting point for you.
I havent looked at it yet, but regardless, it should provide something close to what you are asking for based on the description.
Thanks for your help. I think this is kind of what I'm looking for. However, how would the SQL query be modified to display the utilization above 75% - instead of 65%?
SELECT Nodes.Caption AS NodeName,
(SELECT TOP 1
FROM Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime
AND EndTime.EventType = 5001
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
(StartTime.EventType = 5000)
(StartTime.Message LIKE '%Utilization%')
StartTime.EventTime between dateadd(month,-1, getdate()) and getdate()
ORDER BY 2 DESC
this works from the network utilization events. The thresholds are whatever you have set as the interface utilization alarms in the NPM thresholds (i.e. the 65%/75% are not coded into the query)
Richard: I noticed that the time displayed in the report itself didn't match the time from when the alert e-mail was first sent and the reset e-mail that was sent later on. For instance, an alert e-mail was sent today at around 3:10 PM and the reset at 3:21 PM. However, the SQL query report did not match the e-mail time (11 minutes); I think the report itself showed something like 15 minutes. Should this be the case? Also, would there be a way to modify the "Where statement" to filter from the past seven days whenever the report is opened: "StartTime.EventTime between dateadd(month,-1, getdate()) and getdate()?" I am somewhat of a SQL beginner.
Events != Alerts
If your alert setting has to wait for 5 minutes before sending an email for an over-utilization alert you will get a difference, this report works off events.
google is your friend... DATEADD (Transact-SQL)
I'd try something like ... StartTime.EventTime between dateadd(week,-1, getdate()) and getdate() ...
If you are going to be working with SQL I recommend SQL for Dummies (it's quite a well-written book). I've been doing database for many years now and I still check functions in the manuals and use ANSI-SQL. (the above query is not ansi-sql and won't work on many other databases)