This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom report to show SolarWinds objects with current - or scheduled - supressed alerts

mmatec01 over 6 years ago

I am looking for EITHER custom SQL/SWQL query OR a way to put together a Web-based Report Manager report showing me all objects in maintenance mode with either current or scheduled (in the future) suppressed (muted) alerts. As you know the ability to mute alerts is a new feature with NPM 12.1. This is a great feature indeed, the ability to suspend triggering alerts. So I would like to run a report of all objects in SolarWinds that either are or are scheduled to go into maintenance mode with muted alerts. And by objects I mean nodes, interfaces, volumes, applications, transactions, etc...basically anything that you can click on 'Maintenance Mode' in web GUI. And again, this is different than showing specific objects in SolarWinds (like nodes or applications) which are unmanaged. That has been discussed bunch of times and I think I can run a report for unmanaged nodes relatively easily. This is different. Thanks!

Top Replies

0 mmatec01 over 6 years ago

Actually I think I just found an answer. Right here: Find muted entities - SolarWinds Worldwide, LLC. Help and Support
Cancel
Vote Up +2 Vote Down

Cancel
0 st.crispan over 6 years ago in reply to mmatec01

I could use a copy of this report for muted and unmuted. Any suggestions?
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 6 years ago in reply to mmatec01

This report seems to be written in SWQL. Does anyone know how to do this in raw TSQL? We'd like to be able to run this a query from a job engine external to Orion with no access to the SWQL api.. Thanks!
Cancel
Vote Up 0 Vote Down

Cancel
0 tmeyers over 6 years ago

Hi... would also Like access to this report.... any thoughts on where I can go to get a copy?
Cancel
Vote Up 0 Vote Down

Cancel
0 mesverrum over 6 years ago in reply to tmeyers

Current Muted Alerts (v5) [SAM & NPM]
Cancel
Vote Up +2 Vote Down

Cancel
0 tmeyers over 6 years ago in reply to mesverrum

Excellent! Thank You!
Cancel
Vote Up 0 Vote Down

Cancel
0 battles over 6 years ago

Alternatively you can write a reverse alert when putting circuits into maintenance or muting them SPECIFIC to interface/node/original condition WHERE device or interface IS muted/in maintenance and original condition is NOT EQUAL to previous condition etc... If that makes sense... it's sort of a rigged way to do it but can be written rather quickly if you need a quick patch.
Cancel
Vote Up +3 Vote Down

Cancel