Here is the SQL that I am using to get a list of Unclassified APs where the Signal Strength indicates that the AP might be close to (or even inside) our building:
------- sql
select ssid,
bssid,
max(signal) as strength,
manuf,
securitymode,
radioband,
channel,
onwire as on_wire,
(case apstatus when 0 then ' unclassified' when 1 then ' rogue' when 2 then ' accepted' when 3 then ' suppressed' else ' others' end) as ap_full_status
from $log
where $filter
and apstatus=0
and bssid is not null
and onwire=' no'
and logid=' 43521'
and signal > -75
group by ssid,
bssid,
manuf,
securitymode,
radioband,
channel,
on_wire,
ap_full_status
order by strength desc
