Filter Modern dashboards to specific Node Groups?

Question

Hello,

I've recently set up the following dashboards to monitor servers and networks.

https://thwack.solarwinds.com/kb/articles/3725-networks-summary?utm_source=community-search&utm_medium=organic-search&utm_term=Networks+Summary

https://thwack.solarwinds.com/kb/articles/3730-servers-summary?utm_source=community-search&utm_medium=organic-search&utm_term=servers+summary

We've found these dashboards to be incredibly useful, but as we have different teams for different servers, we would like to be able to filter these down so that our other team can have a dashboard showing just their servers instead of the whole environment. Is there a good solution for this? I thought about adding a WHERE clause to the query and joining the Nodes, Applications, and Groups tables based on the NodeID but I figured there must be an easier way.

jrussell134415 · Answer

Well this DID work on 2026.1 until I updated to 2026.2. Now I get this string of errors when I try to filter. If I turn filtering off I can still see everything. I validated that the queries did not change, and can properly validate/receive data. Here's one of the queries that was working, but broke after the update:

Select A.Name as [Application Name] ,A.DetailsUrl as [ADetailsUrl], A.Status as ApplicationStatus, A.Node.Caption as [Node Name], A.Node.Status as NodeStatus, A.Node.DetailsURL as [NDetailsUrl]
FROM Orion.APM.Application A
JOIN Orion.NodesCustomProperties cp ON cp.NodeID = A.NodeID

bourlis · Answer

I tried the route Chad noted but I ran into issues.  I don't recall if it was performance issues or return issues, so I pivoted and went a slightly different route.  Its pretty much the same thing as Chad's example but, someone correct me if I'm wrong, I have smaller returns on the nested query than the normal join option.

Here's my slight deviation on a group filter:

select 

n.caption as [System Name] 
<redacted?
, n.CustomProperties._Disposition as [Dispo]

FROM

    (SELECT c.Name

    ,c.Container.Name

    FROM Orion.ContainerMembers c

where c.EntityDisplayName = 'Node' 

      and c.Container.Name like '%GIS%') as m

left JOIN Orion.Nodes n ON n.caption = m.name

ORDER by n.Caption

Here's how I built my filters around disposition

select 

n.caption as [System Name] 
<redacted>
, n.CustomProperties._Disposition as [Dispo]

from orion.nodes n

where n.customproperties.Service = 'GIS AccelaGIS'

     and (n.CustomProperties._Disposition is not Null

     or n.CustomProperties._Disposition is Null)

chad.every · Answer

Yes, you'll need a join for each SWQL query to the custom properties entity. You don't have to reference any property inside of the select statement, only the JOIN.

https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-edit-filter.htm#link4