Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Muted Nodes

I've been searching through THWACK and I think I know the answer but I will ask again.

I've been using SolarWinds for somewhere in the neighborhood of 7 to 8 years.

Have they still not come up with an out of the box report for displaying muted nodes? I can't believe a product gives us the ability to perform a function, but not be able to display if that function has been performed. I don't think we should have to rely on the user community to come up with solutions that should be part of the product.

Am I just missing the report somehow?

Find more posts tagged with

Accepted answers

All comments

planglois

Here's what I use on my Orion sumary... Simply create a new Custom ressource and use the following custom SWQL Query:

-- REF: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/33940/muted-nodes-resource/113375#113375
SELECT DISTINCT
       CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[Caption]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[FullName]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'
             THEN [AA].[FullyQualifiedName]
          ELSE 'SomethingElse'
       END AS [Element],
       CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[DetailsUrl]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[DetailsUrl]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'
             THEN [AA].[DetailsUrl]
          ELSE 'SomethingElse'
       END AS [_LinkFor_Element],
       [AE].AccountID AS [By],
       ToLocal([SuppressFrom]) AS [Start],       
       ToLocal([SuppressUntil]) AS [End]
FROM Orion.AlertSuppression AS [AlertSup]
LEFT OUTER JOIN Orion.Nodes AS [N]
   ON [AlertSup].[EntityUri] = [N].[Uri]
LEFT OUTER JOIN Orion.NPM.Interfaces AS [I]
   ON [AlertSup].[EntityUri] = [I].[Uri]
LEFT OUTER JOIN Orion.APM.Application AS [AA]
   ON [AlertSup].[EntityUri] = [AA].[Uri]
LEFT OUTER JOIN Orion.AuditingEvents AS [AE]
   ON [AE].AuditEventMessage LIKE CONCAT('%', CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[NodeName]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[InterfaceCaption]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'
             THEN [AA].[Name]
          ELSE 'Wrong'
       END, '%') AND [EntityUri] LIKE CONCAT('%=', [AE].NetObjectID)
INNER JOIN Orion.AuditingActionTypes AS [AT]
   ON [AE].ActionTypeID = [AT].ActionTypeID
WHERE [AT].ActionType IN  ( 'Orion.AlertSuppressionAdded', 'Orion.AlertSuppressionChanged' )
ORDER BY [SuppressFrom]

themossman

Thanks. I appreciate the feedback. I already have an sql query that pulls the results. I got it from Thwack probably 4 years ago. My question was why SolarWinds has not made this a standard part of the product rather than letting the user community figure it out. It just seems like it would be a basic function of the product.

spaghettishapes

Came across this whilst looking at muted/unmanaged reporting in views
Made a feature request in case it had not been done before