nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
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
Store

Need SWQL to get all WLC devices and its Access points details to create the modern dashboard

santhoshadapa

Hi Team,
Could you please provide us if any SWQL to get all WLC devices and its Access points details to create the modern dashboard.

Find more posts tagged with

Comments

naveensingh43

@santhoshadapa you can try below query

SELECT[WLCs].DisplayName AS ControllerName,
[WLCs].ThinAPsCount AS TotalAPs,
[WLCs].Status AS ControllerStatus,
COUNT([DownThinAPs].ID) AS DownAPCount,
ROUND((1.0 * COUNT([DownThinAPs].ID)) / [WLCs].ThinAPsCount * 100, 2) AS DownPercent
FROM
Orion.Wireless.Controllers AS [WLCs]
INNER JOIN
Orion.Wireless.AccessPoints.Thin AS [DownThinAPs]
ON [WLCs].ID = [DownThinAPs].ControllerID
AND [DownThinAPs].Status = 2 -- Status 2 typically means 'Down'
GROUP BY
[WLCs].DisplayName,
[WLCs].ThinAPsCount,
[WLCs].Status

Quick Links

Dynamic Interface Dashboard; HTML/JS
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices