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.

Wireless Clients (swql)

Hi All,

A quick widget to show the wireless clients. 

SELECT
--n.caption AS [Node]
--,n.DetailsUrl AS [_LinkFor_Node]
--,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]
wc.IPAddress
,ap.displayname as [AP Name]
,'/Orion/Wireless/images/wireless_thin.gif' as [_IconFor_Ap Name]
,concat('/Orion/Wireless/WirelessAP.aspx?AccessPointID=',ap.ID) as [_LinkFor_AP Name]
,wc.SSID
,wc.SignalStrength as [dB]
,case when (wc.InTotalBytes/1000000) > 1 then concat(round(wc.InTotalBytes/1000000,2),' M')
When (wc.InTotalBytes/1000) > 1 then concat(round(wc.InTotalBytes/1000,2),' K')
else concat(round(wc.InTotalBytes,0),' b') end as [InTotal]
,case when (wc.OutTotalBytes/1000000) > 1 then concat(round(wc.OutTotalBytes/1000000,2),' Mbps')
When (wc.OutTotalBytes/1000) > 1 then concat(round(wc.OutTotalBytes/1000,2),' Kbps')
else concat((round(wc.OutTotalBytes,0)),' bps') end as [OutTotal]
,case when (wc.InBps/1000000) > 1 then concat(round(wc.InBps/1000000,2),' Mbps')
When (wc.InBps/1000) > 1 then concat(round(wc.InBps/1000,2),' Kbps')
else concat(round(wc.InBps,0),' bps') end as [Receive]
,case when (wc.OutBps/1000000) > 1 then concat(round(wc.OutBps/1000000,2),' Mbps')
When (wc.OutBps/1000) > 1 then concat(round(wc.OutBps/1000,2),' Kbps')
else concat((round(wc.OutBps,0)),' bps') end as [Transmit]
FROM Orion.Wireless.Clients wc
join Orion.nodes n on n.nodeid=wc.NodeID
left join Orion.Wireless.AccessPoints ap on ap.ID=wc.accesspointid
order by wc.InBps+wc.OutBps desc

Parents Reply Children
No Data