Dear,
A while ago I made a request here to add access points and down nodes into one widget with SWQL. This got fixed but now we also want to apply this to another widget down below:
The SWQL querry is as follows for this:
SELECT COUNT ([N].NodeID) AS Quanity
, [N].Status AS [Node Status]
FROM Orion.Nodes AS [N]
GROUP BY [N].Status
ORDER BY [N].Status
So at the down status we also want to see our down access points but don't have the ability to do so. Any help would be appreciated.
PS: We also want to add an ''all nodes '' value here as well
Thanks in advance.