• State Not Answered
  • Locked Locked
  • Replies 22 replies
  • Subscribers 38 subscribers
  • Views 7011 views
  • Users 0 members are here
Options
Related
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.

List of Muted Nodes

cscoengineer

NPM 12 introduced 'mute alerts', but no way to use 'group by'  to view the nodes affected by mute alerts,   This short SWQL will display the nodes affected by mute alerts.

select

n.caption as [Device], n.DetailsURL as [_LinkFor_Device]

,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Device]

,n.IP_Address as [IP], n.DetailsURL as [_LinkFor_IP]

, Alerts.SuppressFrom as [Mute from], Alerts.SuppressUntil as [Mute Until]

from Orion.AlertSuppression AlertS

join Orion.nodes n on n.uri = AlertS.EntityURI

pastedImage_0.png

Thanks

Amit

Parents
  • 0

    I realize this is really old but I'm stumbling through some of the same things. 

    I've tinkered and cobbled together solutions from other similar scripts.  The problem for me was that most all the statements were using UTC.  I used local w/ the following (harvested from other Thwack posts)

    ,tostring(tolocal(n.UnManageFrom)) AS [From]

    tostring(tolocal(n.UnManageUntil)) end AS [Until]

Reply
  • 0

    I realize this is really old but I'm stumbling through some of the same things. 

    I've tinkered and cobbled together solutions from other similar scripts.  The problem for me was that most all the statements were using UTC.  I used local w/ the following (harvested from other Thwack posts)

    ,tostring(tolocal(n.UnManageFrom)) AS [From]

    tostring(tolocal(n.UnManageUntil)) end AS [Until]

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,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 Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.