Interesting SQL Queries

To get a list of unqiue networks captured:

SELECT DISTINCT mac, essid FROM iwscan_readings;

---

Looking at channel network counts:

SELECT DISTINCT channel,COUNT(DISTINCT mac) FROM iwscan_readings GROUP BY channel;

---

Looking at encryption scheme network counts:

SELECT encryption, count(DISTINCT mac) FROM iwscan_readings GROUP BY encryption;

Note: The off network count can be misleading because of eero mesh hidden network.

---

To look at unencrypted network vendor strings:

SELECT DISTINCT iwscan_readings.mac,iwscan_readings.essid,oui_lookup.vendor_str FROM iwscan_readings INNER JOIN mac_vendor_str on mac_vendor_str.mac_full = iwscan_readings.mac INNER JOIN oui_lookup on oui_lookup.entry_id = mac_vendor_str.oui_lookup_entry_id WHERE iwscan_readings.encryption = 'off';