Description: Looks for active wireless interfaces
What The Data Shows: Shows all active wireless interfaces, the data can be used to check for rouge APs.
SQL:
SELECT id.description,ia.address,id.mac
FROM interface_details as id join interface_addresses as ia using (interface)
where id.type = 71;