SolarWinds THWACK - Celebrating 20 Years!
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • SolarWinds Observability
      • Hybrid Cloud Observability
      • DevOps
    • The Orion Platform
      • Forum
      • Scalability Engines (HA, APE, AWS)
      • Enterprise Operations Console (EOC)
      • Orion SDK
      • Alert Lab
      • Report Lab
    • Network Management
      • Network Performance Monitor (NPM)
      • NetFlow Traffic Analyzer (NTA)
      • Network Configuration Manager (NCM)
      • IP Address Manager (IPAM)
      • User Device Tracker (UDT)
      • VoIP & Network Quality Manager (VNQM)
      • Log Analyzer
      • Engineer’s Toolset
      • Network Topology Mapper (NTM)
      • Kiwi CatTools
      • Kiwi Syslog Server
      • ipMonitor
    • Systems Management
      • Server & Application Monitor (SAM)
      • Virtualization Manager (VMAN)
      • Storage Resource Monitor (SRM)
      • Server Configuration Monitor (SCM)
      • SolarWinds Backup
      • Web Performance Monitor (WPM)
    • Database Management
      • Database Performance Analyzer (DPA)
      • SQL Sentry
      • Database Performance Monitor (DPM)
      • Database Mapper
      • Task Factory
    • Application Management
      • AppOptics
      • Loggly
      • Papertrail
      • Pingdom
      • DevOps
    • IT Security
      • Access Rights Manager (ARM)
      • Identity Monitor
      • Security Event Manager (SEM)
      • Patch Manager
      • Serv-U FTP & MFT
    • IT Service Management
      • SolarWinds Service Desk (SWSD)
      • Web Help Desk (WHD)
      • DameWare Remote Support (DRS)
      • DameWare Remote Everywhere (DRE)
      • DameWare Mini Remote Control (MRC)
  • Resources
    • THWACK Command Center
    • DevOps
    • What We're Working On
    • Blogs
      • Community Announcements
      • Product Blog
      • Monitoring Central
      • Geek Speak
      • The DevOps Blog
    • THWACK Tech Tips
    • Movies and Mainframes
    • Support
      • Success Center
      • Documentation
      • Submit a Support Ticket
      • Customer Portal
      • Renew Maintenance
    • Community Groups
      • New To THWACK
      • Federal & Government
      • User Experience
      • EMEA Group
      • Japan Group
  • Events, Missions, & Musings
    • Events
      • THWACK Livecast
      • THWACK Livecast Archive
      • SolarWinds Lab
      • SolarWinds Lab Archive
      • THWACKcamp 2022 On Demand
      • SolarWinds User Groups
      • SolarWinds Events Calendar
    • Missions & Contests
      • Monthly Mission: More Than Meets The ITSM
      • THWACK 101
    • Musings
      • Water Cooler
      • Geek Tank
      • IT Tech Jobs/Careers
      • Monitoring for Managers
    •  
      •  
  • Content Exchange
    • The Orion Platform
      • Alerts
      • Custom HTML
      • Custom Queries
      • Modern Dashboards
      • Reports
      • Scripts
    • Network Performance Monitor
      • Device Pollers
      • Universal Device Pollers (UnDP)
    • Network Configuration Manager
      • Config Change Scripts
      • Device Templates
      • Firmware Upgrade Templates
      • Policy Documents
    • Server & Application Monitor
      • API Pollers
      • Application Monitor Templates
    • Server Configuration Monitor
      • Policies
      • Profiles
    • Database Performance Analyzer
      • Custom Alerts
      • Custom Metrics
      • Custom Queries
    • Web Help Desk
      • Style Sheets
  • Academy
    • Newsroom
    • Forums
      • Classroom Discussions
      • SolarWinds Certified Professional (SCP)
    • Training & Certification
  • Free Tools & Trials
  • Store
The Orion Platform
  • Content Exchange
  • More
The Orion Platform
Reports Repetitive Email Alerts (Noise) - MUST HAVE REPORT!!!
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName

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

  • Alert
  • alert count
  • noise
  • Network Performance Monitor (NPM)
  • Alerts
  • alert history
AlexSoul
AlexSoul
  • 10 Jun 2016
  • 135 Downloads
  • Share
  • More
  • Cancel
Anonymous

Top Comments

  • AlexSoul
    AlexSoul over 7 years ago +2

    this is my version from another fresh instance of NPM 12... Good we do not push those to our NOC yet emoticons_grin.png ... also, all of them failed anyway (due to miss-configured email gateway), which is another great…

  • i_like_eggs
    i_like_eggs over 5 years ago +2

    I like this report you can also look at it in another perspective on the node details page. emoticons_happy.png it will need to be stuck in to a report writer first

    pastedImage_0.png

    SQL:

    SELECT

    'Small-Relative-2.gif'

       ,ahv.Name AS 'AlertName…

  • AlexSoul
    AlexSoul over 5 years ago +2

    hey guys, check this out... I have added percentage column. Go ahead and download a new version 1.2 above. It will also have some bug fixes with extracting EmailTo strings

    pastedImage_0.png

  • stuartd
    stuartd 9 months ago

    Hey AlexSoul - 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?

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • crisostomo420
    crisostomo420 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.

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • AlexSoul
    AlexSoul 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

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • craigsg
    craigsg 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

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • craigsg
    craigsg 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

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
>

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.