< BACK TO TO THE MAGIC OF SQL SCRIPTS SERIES LIST
My Dear Thwackers,
If you are sick and tired of having to deal with continuous noise from hundreds of alerts and customer complaints due to missed problems - you must have this report, now!
Fact: 80% of your alerts and frustrations come from 20% of stuff within your infrastructure!
It is quite obvious that most of the negative impact on performance and productivity within the NOC is being caused by noise and repetitive alerts that is just keep coming through... non-stop. Ability to highlight them in a most efficient manner has never been easy, until now 
I am here to offer you a gift - a custom made report that has served us for years in attacking and eliminating all the noise. It is compatible with Orion Platform 2015.1.2, NPM 11.5+ (also works with latest NPM 12)
Download > Import > Run > Action
... and just for fun - please publish a screenshot in the comments below of the top 5 stats that you will get - it is very interesting to know how this will play out in your environment 
To your monitoring success,
Alex Soul
[UPDATES]
[30/08/2017]: Below we have discussed some bug fixes around extracting EmailTo from description. In the attached report this workaround was implemented, so, it should work for you straight out-of-the-box
[31/08/2017]: I have added % column, which will calculate percentage from total umber of email alerts sent over the defined period. I have also updated they way variables are being defined, so, you can now just open SQL script and change them all in one place defined in SET function on top of the script
[04/09/2017]: As suggested by tdanner - there is a better way of extracting EmailTo and EmailCC. This has been implemented in version 1.3 of the report
Top Comments