Version 2

    Cisco Prime has a function to detect when a radio on an AP is down.  This is extremely useful as the AP can be up and the "a" radio can be down, but the "g" radio is up.

     

    Unfortunately, Orion does not tell us the status of the radios (feature request!!!!!).  ugh!!   We can probably infer that the radio is down if there is minimal traffic and zero clients.

     

     

    ok.   With this in mind, here are two resources - er - widgets which provides a good summary for the APs.

    SELECT

    t.DisplayName as [Access Point]

    ,concat('/Orion/View.aspx?NetObject=WLTAP:',t.id) as [_linkfor_Access Point]

    ,case when t.Available=1 then '/Orion/Wireless/Images/Object-WAP_Thin-Up.png'

              when t.Available=0 then '/Orion/Wireless/Images/Object-WAP_Thin-Down.png'

          end as [_iconfor_Access Point]

    ,t.IPAddress

    ,t.Clients as [Clients]

    ,case when t.Clients >= 40 then '/Orion/images/StatusIcons/Small-Critical.gif'

          when t.Clients >= 30 then '/Orion/images/StatusIcons/Small-Warning.gif'

          else '/Orion/images/StatusIcons/Small-Up.gif'

          end as [_iconfor_Clients]

    ,round(t.InBps,0) as [INbps]

    ,round(t.OutBps,0) as [Outbps]

    FROM Orion.Wireless.AccessPoints.Thin t

    order by t.available asc, t.Clients desc

     

    SELECT                                                                                                                                                             

    t.DisplayName as [Access Point]

    ,concat('/Orion/View.aspx?NetObject=WLTAP:',t.id) as [_linkfor_Access Point]

    ,case when t.Available=1 then '/Orion/Wireless/Images/Object-WAP_Thin-Up.png'

          when t.Available=0 then '/Orion/Wireless/Images/Object-WAP_Thin-down.png'

          end as [_iconfor_Access Point]

    ,t.IPAddress

    ,i.Clients as [Clients]

    ,case when i.Clients > 40 then '/Orion/images/StatusIcons/Small-Critical.gif'

          when i.Clients > 30 then '/Orion/images/StatusIcons/Small-Warning.gif'

          else '/Orion/images/StatusIcons/Small-Up.gif'

          end as [_iconfor_Clients]

    ,i.radiotype

    ,round(i.InBps,0) as [InBps]

    ,round(i.OutBps,0) as [OutBps]

    FROM Orion.Wireless.AccessPoints t

    join Orion.Wireless.Interfaces i on i.id = t.id

    order by t.available asc, i.Clients desc

     

    btw – make sure you uncheck the two default settings in advanced config (/Orion/Admin/AdvancedConfiguration/Global.aspx)

    The RemoveDisappearedAPs will let you know if an AP is down (disappears).  In some cases, the SaveRouguesToHistory gives us extremely large tables.  This should generally be turned off unless there is a specific need.

     

    Thank You,

    Amit