This will give you widget for Wireless APs. The advantage of a custom widget is the amount of control over the query.
SELECT
--n.caption AS [Node]
SUBSTRING(n.caption,1,case charindex('.',n.caption,1) when 0 then length(n.caption) else (charindex('.',n.caption,1)-1) end) as [Controller]
,n.DetailsUrl AS [_LinkFor_Controller]
,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Controller]
,apt.DisplayName as [AP Name]
,case when apt.Status=2 then '/Orion/Wireless/images/Object-WAP_Thin-Down.png' else
'/Orion/Wireless/images/Object-WAP_Thin-Up.png' end as [_IconFor_AP Name]
,concat('/Orion/Wireless/WirelessAP.aspx?AccessPointID=',apt.ID) as [_LinkFor_AP Name]
,apt.IPAddress
,case when (apt.InBps/1000000) > 1 then concat(round(apt.InBps/1000000,2),' Mbps')
When (apt.InBps/1000) > 1 then concat(round(apt.InBps/1000,2),' Kbps')
else concat(round(apt.InBps,0),' bps') end as [Receive]
,case when (apt.OutBps/1000000) > 1 then concat(round(apt.OutBps/1000000,2),' Mbps')
When (apt.OutBps/1000) > 1 then concat(round(apt.OutBps/1000,2),' Kbps')
else concat((round(apt.OutBps,0)),' bps') end as [Transmit]
,apt.Clients as [Clients]
FROM Orion.Wireless.AccessPoints apt
join Orion.Nodes n on n.nodeid=apt.NodeID
order by apt.Status, apt.Clients desc
Thank you,
Amit Shah
Loop1 Systems
