Repetitive Email Alerts (Noise) - MUST HAVE REPORT!!!

< 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 emoticons_grin.png

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 emoticons_wink.png

pastedImage_0.png

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

pastedImage_2.png

pastedImage_3.png

[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

Anonymous
  • Hi Alex,

    I've been using this script for a while on our main server and it works great, so thank you.

    pastedImage_0.png

    We've recently taken over a few servers for one of our customers, and when I use the script on their servers it creates the report and gets the data but it is presented with the whole html code attached, but not on all of the columns:

    pastedImage_1.png

    Do you have any ideas on how to fix that?

    The one that works is on ver 12.1, customer servers are on ver 12.0. It was a while ago when I originally started using this. Do I need to download the .xml code to the server? It was a while ago and I can't remember if I did that originally.

    Thanks,

    Craig

  • This report is designed for web-based interface. If you want it in writer - all you need to do is to copy SQL script into writer report and configure columns. Script itself is same SQL for both writer and web-based, but structure of columns will be different.

  • Hi Alex....can you explain to me how I can get your report in report writer so I can use it in one of my Orion views...for some reason I don't know how to get this to show up or put it into report writer. Appreciate your support.

  • I wanted to create the custom view using your SQL but, when i execute it in report writer I get a pop-up that states "SQL error: syntax error or access violation". Appreciate your feedback. thank you