Down interfaces by group

Question

How would I show all the down interfaces for a group rather than from all groups?

In "Edit Resource: Down Interfaces" it prompts to input a filters node (SQL), however, I'm unaware on how to retrieve the nodes that pertains to the "network group" to show those interfaces down on the switches.

Thanks

PavelSrot · Accepted Answer

For example on group detail page you can by using Customize add Custom Query resource and via Edit on this resource you into Custom SVQL Query field enter following query:

SELECT i.Caption AS [Interface Name]

FROM Orion.Groups g

INNER JOIN Orion.Nodes n on g.Members.MemberUri = n.Uri

INNER JOIN Orion.NPM.Interfaces i on n.NodeID=i.NodeID

WHERE g.ContainerId = ${Id} AND i.Status = 2

This will display you all down interfaces which belong nodes which was included for given group