Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Docs
Stories
News Ask around Schedule a demo Share your story COMPANY The handbook What people are saying
Pricing Try it yourself

Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

wifi_networks

click to open the table of contents
macOS logo

wifi​_networks

Wi-Fi networks previously connected to by this Mac, or that are otherwise in this computer's known/remembered Wi-Fi networks list.

Column Type Description
add_reason text Shows why this network was added, via menubar or command line or something else
added_at integer Time this network was added as a unix_time
auto_join integer 1 if this network set to join automatically, 0 otherwise
auto_login integer 1 if auto login is enabled, 0 otherwise
Not returned in SELECT * FROM wifi_networks.
captive_login_date integer Time this network logged in to a captive portal as unix_time
captive_portal integer 1 if this network has a captive portal, 0 otherwise
disabled integer 1 if this network is disabled, 0 otherwise
Not returned in SELECT * FROM wifi_networks.
last_connected integer Last time this network was connected to as a unix_time
Not returned in SELECT * FROM wifi_networks.
network_name text Name of the network
passpoint integer 1 if Passpoint is supported, 0 otherwise
Not returned in SELECT * FROM wifi_networks.
personal_hotspot integer 1 if this network is a personal hotspot, 0 otherwise
possibly_hidden integer 1 if network is possibly a hidden network, 0 otherwise
roaming integer 1 if roaming is supported, 0 otherwise
Not returned in SELECT * FROM wifi_networks.
roaming_profile text Describe the roaming profile, usually one of Single, Dual or Multi
security_type text Type of security on this network
ssid text SSID octets of the network
temporarily_disabled integer 1 if this network is temporarily disabled, 0 otherwise
was_captive_network integer 1 if this network was previously a captive network, 0 otherwise

Example

Find WiFi networks configured on Macs that are unencrypted and require a captive portal. This can be useful to understand how much people use laptops in hotels, airports and other environments, and is a good indicator that tools such as DNS-over-HTTPS would improve privacy of connectivity.

SELECT network_name FROM wifi_networks WHERE security_type='Open' AND captive_portal='1';
Edit page

Questions?

Ask us anything
{{table.title}} evented table