Custom Reports - Triggered Alerts

Question

Hello.

I would like to build a custom report that displays the Top 10 nodes that trigger the most alerts.  alerts not events.  I'm not a SQL person and was wondering if any here could assist me with the sql query.

Thanks in advance.

Valisha

berger · Accepted Answer

Hi Valisha,

This seemed somewhat useful for us as well, so I made one and uploaded to content exchange ">.

If you want top 10 for past 25 days, just add

the line "TOP 10" after SELECT, e.g.:

"SELECT TOP 10"

and if you want a different time period, or just all time periods either edit or remove the

"( DateDiff(dd, Events.EventTime, getDate()))<25"

line (25 is days, if you remove it completely also remove the "AND" following it)

Feel free to pm me if you need any help