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 over 7 years ago

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

Thanks

Amit

Top Replies

0 mr.e over 7 years ago

This is a great report. Many thanks, cscoengineer.
By the way, I was wondering if there's a way to tweak this report so it will list who muted the alerts for each node. This would save us from having to click on each muted device to find out who did it. I am guessing that we'd need to join the AuditingEvents table. However, I am not very savvy on SQL, even less SWQL, so I am hoping someone can shed light on how to do this.
Many thanks again!!!
Cancel
Vote Up 0 Vote Down

Cancel
0 cscoengineer over 7 years ago

Hi mr.e
Don't see a way currently, as the muting of alerts do not seem to be audited. I muted an alert and am not seeing that event populated in the events table. Also the Orion.AlertSuppression does not have a username field.
I put in a feature request. Please vote up.

Thanks!
Amit
Cancel
Vote Up +1 Vote Down

Cancel
0 smcdonald over 7 years ago

Fantastic! I was just looking at how I could find Muted (but not Unmanaged) devices easily and this is perfect. Don't suppose you have a similar one for Unmanaged devices in the same format so I don't need to resort to using reports?
Thanks very much for this, a huge help!
Sean
Cancel
Vote Up 0 Vote Down

Cancel
0 xpowels over 6 years ago

Is there a way to see scheduled Mutes? I have an extended power even in a couple weeks and scheduled several devices to mute there alerts at a certain time, but i want to see the list and be sure it is correct.
Cancel
Vote Up 0 Vote Down

Cancel
0 mmcc0912 over 6 years ago

I see that field in the Nodes table. I don't use the UnManaged, glad to have the mute option so I can still have collected data. You should be able to do a query there and find what you're looking for.
Cancel
Vote Up 0 Vote Down

Cancel
0 ryan.wallace over 6 years ago

Awesome! Thank you so much! I wish they actually implemented this when they gave us mute, but thanks for throwing it out here for us!
Cancel
Vote Up 0 Vote Down

Cancel
0 lindseywiggins1234 over 6 years ago

Great! very useful
Cancel
Vote Up 0 Vote Down

Cancel
0 saw10 over 6 years ago

Thank You fro the time and effort on this. Very useful.
Cancel
Vote Up 0 Vote Down

Cancel
0 XM07535 over 6 years ago

I tried this sql query and it's not working for me. I just muted alerts for 70 Windows servers. The report doesn't return them. I have a sql query to give me unmanaged nodes.
SELECT
n.caption as Node
, unmanaged
, tolocal(UnManageFrom) as Unmanage
, daydiff(getdate(), UnManagefrom)as [Days till Unmanage]
, tolocal(UnManageUntil) as Remanage
, daydiff(getdate(), UnManageuntil)as [Days until Remanage]
FROM Orion.Nodes n
where
(
unmanaged = 'true' and
(minutediff(getdate(), UnManagefrom) >0)
)
or
(
minutediff(getdate(), UnManagefrom) >0
and minutediff(getdate(), UnManagefrom) <999999
)
order by unmanagefrom
Cancel
Vote Up 0 Vote Down

Cancel
0 XM07535 over 6 years ago

Never mind. I resolved my issue. ID10T error, I forgot to add columns based on the sql query.
Cancel
Vote Up 0 Vote Down

Cancel