Here is a quick one - Thought it would be interesting to see a chart on the number of wireless clients across various APs on a controller.
SELECT
wav.controllername [Controller]
,wav.name [AP Name]
,Wireless_AccessPointsHistory.[LastUpdate]
,Wireless_AccessPointsHistory.[Clients]
,[InBytes]
,[OutBytes]
,Wireless_AccessPointsHistory.[InBps]
,Wireless_AccessPointsHistory.[OutBps]
FROM [L1SOrion].[dbo].[Wireless_AccessPointsHistory]
join [Wireless_AccessPoints_View] wav on wav.[Index]=Wireless_AccessPointsHistory.[index]
where wav.controllername='xxx2504' and
datediff(dd,Wireless_AccessPointsHistory.lastupdate,getdate()) <=7
-Thanks
Amit
Comments