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