I used the instruction provided here https://support.solarwinds.com/SuccessCenter/s/article/Custom-query-to-find-muted-nodes-or-interfaces?language=en_US to create a custom widget showing muted interfaces but without the node name it's hard to tell where the muted interface is located. Need the query to also display the node name.
try this query, I just tested it
SELECT T2.Node.Caption as [Node Name] ,T2.caption FROM Orion.AlertSuppression T1join Orion.NPM.Interfaces T2on T1.entityuri= T2.Uri
you should be able to add T2.Node.Caption as [Node Name] to your select statement and it'll bring it in
I tried to add T2.Node.Caption before T2.caption in the below query but it wouldn't display. I was able to replace T2.caption with T2.Node.Caption but it displayed only the node name. Can both be displayed? maybe with a dash in between?
SELECT T2.caption FROM Orion.AlertSuppression T1join Orion.NPM.Interfaces T2on T1.entityuri= T2.Uri
You can try adding FullName
SELECT T2.caption, T2.FullName FROM Orion.AlertSuppression T1join Orion.NPM.Interfaces T2on T1.entityuri= T2.Uri
That worked. Thank you!
There's also this report that pulls everything. You can easily import it and then edit it to see the Query used behind the scenes.
