Combine SWQL queries into 1

Nurullaht

Problem:

My access points that are down don't want to appear in the node down KPI widget. The query that I have used for the node-down is this one:

select count(status) as countnodes from orion.nodes where (status =2)

I made another widget just to show the Access points that are down:

select count(status) as countnodes from Orion.Packages.Wireless.AccessPoints n where (status =2)

My question would be: How do I combine these into a single query (single kpi) as I don't want 2 separate widgets to show down nodes and access points as it is very odd to look at?

Thanks in advance.

Seashore

select 
    count(n.status) +(select count(a.status) AS AP from Orion.Packages.Wireless.AccessPoints as a where (a.status =2)) as total
from orion.nodes as N
where (n.status =2)

Does this work for you?