How to use SWQL to get a table of the number of up and down Wireless Access Points?

Hello, I am in need of assistance using SWQL, I am able to get two columns Status and Total where total adds up the up nodes of all my up devices in one row and all down in the next row using:

SELECT SI.StatusName AS Status, COUNT(Status) AS Total FROM Orion.Nodes N INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status GROUP BY SI.StatusName ORDER BY Total DESC

However, I only want access points to be included in my table. I do know that they are under Orion.Wireless.AccessPoint, but there is no Orion.Wireless.AccessPoint.StatusInfo. How should I edit this query for only inluding access points?

For reference this is going into a google pie chart, which I will display on my dashbaord.

Find more posts tagged with

swql query

access point

wireless

Accepted answers

christopher.t.jones123

@fgdark, why dont you give the below query a try? Basically because the Acess Points Table has a status we can still do the join so it pulls in a Name for the status, and because we've changed the FROM table it will only bring in AP's.

SELECT SI.StatusName AS Status, COUNT(Status) AS Total 
FROM Orion.Packages.Wireless.AccessPoints AP
INNER JOIN Orion.StatusInfo SI ON SI.StatusId = AP.Status 
GROUP BY SI.StatusName 
ORDER BY Total DESC

All comments

Bry

Do all the access points have something specific in their name? I am really new to this myself so might be a better way but can you do a filter like:

WHERE
[si].[DisplayName] Like 'AP%')

The above should filter where displayname has AP (something in) e.g. AP1

This is under presumption their is a displayname field.

If not you might be able to filter

where

Orion.Node.ip like (specific ip range for access points) (not sure if its si.node or just node)

Orion.Node.name like

christopher.t.jones123

SELECT SI.StatusName AS Status, COUNT(Status) AS Total 
FROM Orion.Packages.Wireless.AccessPoints AP
INNER JOIN Orion.StatusInfo SI ON SI.StatusId = AP.Status 
GROUP BY SI.StatusName 
ORDER BY Total DESC