Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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

jamshad2712

Find more posts tagged with

Accepted answers

All comments

bobmarley

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.

bobmarley

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