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.

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