Network Management

Widget to view Unmanaged Nodes, Nodes under Maintenance

With multiple Users on a SolarWinds instance, it might get difficult to track which nodes have been placed under maintenance while Alerts may be getting missed on those nodes as Alerts are Muted

First published date

4/23/2025 11:31 PM

Last published date

7/23/2025 3:20 PM

Overview

SWQL Query Provided can be used in widget to show details regarding nodes under Maintenance

Only an Account with Admin Permissions will be able to view the Dashboard, this is because the SWQL query queries audit events which are only available for user accounts with Admin Permissions.

Product section

Network Performance Monitor

Resolution

1. In SolarWinds web console, Go to the view/dashboard to customize.
2. Click the pencil icon on the upper left.
image.png 
3. Click the Add Widgets button on the upper right and search for "Custom Query" and press enter.
image.png 
4. Select the "Custom Query" widget from results and click Add (drag and drop to left)
5. Click Done Editing on top right
6. New "Customer Query" widget will be visible on the Dashboard / view, Click Edit
image.png 
7. It will look like this, copy and past the One of the below query and click submit. Note: Only One query per widget.
image.png 



/* SWQL query to find muted Node Names*/

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
select

' ' + n.caption as [Node Name], n.DetailsURL as [_LinkFor_Node Name]
,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name]
,n.IP_Address as [IP Address], n.DetailsURL as [_LinkFor_IP Address]
,Addhour(-5,Alerts.SuppressFrom) AS [Mute From], Addhour(-5,Alerts.SuppressUntil) AS [Mute Untill]
, AE.AuditEventMessage, AE.AccountID As [Muted By]
from Orion.AlertSuppression Alerts
 
INNER join Orion.nodes n on n.uri = Alerts.EntityURI
Left outer join Orion.AuditingEvents AE on AE.NetObjectID=n.NodeID where AE.ActionTypeID='66'
 
-- AND (alerts.SuppressUntil >= GETUTCDATE() or alerts.SuppressUntil is NULL)
 
order by Alerts.SuppressFrom DESC;


You might need to change the value  AE.ActionTypeID='66' in the query 
to verify this 
  • Open Database Manager from the SolarWinds Application server 
  • Add Orion Server
  • Right click SolarWinds Orion DB ,select New Query ,run the query below 
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT * FROM [dbo].[AuditingActionTypes]
where ActionTypeDisplayname = 'Alerts Muted'

The resulting Widget will look like this

Image.png