Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
wifi_survey
Scan for nearby WiFi networks.
Column | Type | Description |
---|---|---|
bssid | text | The current basic service set identifier |
channel | integer | Channel number |
channel_band | integer | Channel band |
channel_width | integer | Channel width |
country_code | text | The country code (ISO/IEC 3166-1:1997) for the network |
interface | text | Name of the interface |
network_name | text | Name of the network |
noise | integer | The current noise measurement (dBm) |
rssi | integer | The current received signal strength indication (dbm) |
ssid | text | SSID octets of the network |
Count the amount of wireless networks visible to the computer.
SELECT COUNT ( DISTINCT network_name ) AS "Number of wireless networks visible" FROM wifi_survey;
bssid
and country code
are only available for macOS 11 and earlier because they would enable geolocation.