Options

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

AlexSoul
Anonymous
  • 9 months ago

    Hey - I've been meaning to implement this in our environment. It looks fab but I'm a tad confused (usual state of affairs I know)....

    When I run this in our setup, the email to / cc columns are mostly empty. Does that simply mean the event didn't result in an eMail? If so, what's the easiest way to add in showing what did happen?

    Also, the 'sent' column is just the number of times an eMail (or trigger) was actioned so if I simply remove the two email columns, remove failed and change the name of sent to say triggered then this would give a more accurate picture of our setup - yes/no?

  • over 3 years ago

    Hi Alex, a newbie here. May I please know what the 'STATUS' values mean?

    CLEARED means alert has been cleared? ACTIVE means not yet acknowledged?

    Thanks much mate.

  • over 4 years ago

    Hi, looks like columns in your report do not have tickbox ticked to allow HTML. Please open report in web-based editor and check column settings. You should see tickbox ticked for "allow HTML". If it is not - tick it. That should do the trick

  • over 4 years ago

    A bit more info. If I preview results on the Query page they appear as I would expect them to, but once I add the code to layout it then presents it with all the html code...

    pastedImage_0.png

    Thanks,

    Craig

  • over 4 years ago

    Hi Alex,

    They are both written in web based reports. If I do it in report writer I get the same issue though. It must be something to do with how the one server reads the script.

    Thanks,

    Craig

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.