SWSQL queries in the modern dashboards

IPeaFreely

I have 3 tiles All nodes, Nodes UP, and Nodes Down. and the Up and Down node do not add up the the All Nodes.

All network switch, core and APs
select count(1) as countnodes from orion.nodes n where (((([n].[CustomProperties].[Equipment_Type]) = ('SW'))) or ([n].[CustomProperties].[Equipment_Type]) = ('CS') or ([n].[CustomProperties].[Equipment_Type]) = ('AP') or (([n].[CustomProperties].[Equipment_Type]) = ('WLC')))

All nodes that are up
select count(1) as countnodes from orion.nodes n where ((status = 1) and ((([n].[CustomProperties].[Equipment_Type]) = ('SW'))) or ([n].[CustomProperties].[Equipment_Type]) = ('CS') or ([n].[CustomProperties].[Equipment_Type]) = ('AP') or (([n].[CustomProperties].[Equipment_Type]) = ('WLC')))

All Node that are down
select count(1) as countnodes from orion.nodes n where ((status <>1) and ((([n].[CustomProperties].[Equipment_Type]) = ('SW'))) or ([n].[CustomProperties].[Equipment_Type]) = ('CS') or ([n].[CustomProperties].[Equipment_Type]) = ('AP') or (([n].[CustomProperties].[Equipment_Type]) = ('WLC')))

@chad.every

bobmarley

You may have some nodes that are not in an up or down state in your grand total. There can also be unmanaged, external...