SWQL not working


To start I am new to SolarWinds and SWQL.... I have a query that is working and it gets the total count of all my nodes  in those groups:
SELECT COUNT(1) AS countnodes
FROM Orion.ContainerMembers n
WHERE n.ContainerID IN ('60','61')

What I am needing to do is basically use that same query but tell me what nodes are down which I believe is <>1 and also use the query to give me all nodes that are up. I'm stuck

Thank you


Parents Reply Children
No Data