This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SWQL- Need to create total access point status (KPI Widget) ...Please help

SWQL- Need to create total access point status (KPI Widget) ...Please help

  • The data is located in these tables

    Here is an example query for Thin AP Status

    SELECT TOP 10 DisplayName, IPAddress, Clients, Status
    ,CASE WHEN Status = 1 THEN '/Orion/images/StatusIcons/Small-Up.gif'
          WHEN Status = 2 THEN '/Orion/images/StatusIcons/Small-Down.gif'
          WHEN Status = 3 THEN '/Orion/images/StatusIcons/Small-Warning.gif'
          WHEN Status = 9 THEN '/Orion/images/StatusIcons/Small-Unmanaged.gif'
          WHEN Status = 14 THEN '/Orion/images/StatusIcons/Small-Critical.gif'
          ELSE '/Orion/images/StatusIcons/Small-Unknown.gif'
          END AS [IconStatus]
    FROM Orion.Wireless.AccessPoints.Thin
    

    You may want to take out the TOP 10 or put a WHERE in it but that should get you started. There are several other fields available in those tables. 

  • Here is the query for a KPI widget to show total number of AP's up/down. 

    Here is the UP widget, change the Status to 2 for a Down Widget, 3 for Warning, etc

    Here is a nice guide: 

    A Step-by-Step Guide to Building Modern Dashboards on the Orion® Platform – SolarWinds Lab Episode #93

    SELECT COUNT (Status) as APStatus
    FROM Orion.Wireless.AccessPoints.Thin
    Where STATUS = 1
    Order by COUNT (Status) DESC