Custom Widgets for thin client Access Points

Question

I am trying to create a custom widget on our main monitor page to show down AP's from our WLC controllers.  The goal is to have our NOC have a one glance view into down AP's from the home monitoring page.  I have come up with this SWQL that will give me all the down Access Points, but I am having trouble figuring out how to make the status show as the down.gif icon.

SELECT DisplayName
, IPAddress
, Status
FROM Orion.Wireless.AccessPoints
WHERE Status = '0'

I want it to show up like the nodes in "Down Nodes" widget with the red circle next to the down AP

gadbekr · Answer

Thank you so much.  That worked like a charm.  I had to modify it a bit to only show down access points, but that was the direction I needed.  Much appreciated.

jm_sysadmin · Answer

If this is a modern dash you should be able to get an icon using a status format with the status value. Generally status 0 is unknown, 1 is up and 2 is down. Since the APs go unknown, if you want to force it to look down, make a case statement that when status is 0 then return 2.

If this is a classic dashboard, you will need to add a case statement to add an icon, I mapped unknown to down here in the case statement. Something like this:

SELECT WAP.DisplayName as [WAP]
, WAP.IPAddress
, WAP.Status
, Case 
    When ( WAP.Status = 0 ) Then '/Orion/images/StatusIcons/small-Down.gif'
    When ( WAP.Status = 1 ) Then '/Orion/images/StatusIcons/small-Up.gif'
  End as [_IconFor_WAP]
FROM Orion.Wireless.AccessPoints WAP
WHERE Status = '0' and WAP.WirelessType like  'Thin'

Which looks this (I had none down, so this is up) :