Solutions
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Extend Fleet
Integrate your favorite tools with Fleet.
Customers
Stripe + Fleet
Stripe consolidates multiple tools with Fleet.
Foursquare + Fleet
Foursquare quickly migrates to Fleet for device management.
What people are saying
Stories from the Fleet community.
Pricing
More
Tables
Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
Apple
Linux
Windows
ChromeOS
system_info
system_info
System information for identification.
| Column | Type | Description |
|---|---|---|
| board_model | text | Board model Only available on macOS, Windows, and Linux |
| board_serial | text | Board serial number Only available on macOS, Windows, and Linux |
| board_vendor | text | Board vendor Only available on macOS, Windows, and Linux |
| board_version | text | Board version Only available on macOS, Windows, and Linux |
| computer_name | text | Friendly computer name (optional). For ChromeOS, if the extension wasn't force-installed by an enterprise policy this will default to 'ChromeOS' only |
| cpu_brand | text | CPU brand string, contains vendor and model |
| cpu_logical_cores | integer | Number of logical CPU cores available to the system Only available on macOS, Windows, and Linux |
| cpu_microcode | text | Microcode version Only available on macOS, Windows, and Linux |
| cpu_physical_cores | integer | Number of physical CPU cores in to the system Only available on macOS, Windows, and Linux |
| cpu_sockets | integer | Number of processor sockets in the system |
| cpu_subtype | text | CPU subtype Only available on macOS, Windows, and Linux |
| cpu_type | text | CPU type |
| emulated_cpu_type | text | Emulated CPU type Not returned in SELECT * FROM system_info.Only available on windows, win32, and cygwin |
| hardware_model | text | Hardware model. For ChromeOS, this is only available if the extension was force-installed by an enterprise policy |
| hardware_serial | text | The device's serial number. For ChromeOS, this is only available if the extension was force-installed by an enterprise policy |
| hardware_vendor | text | Hardware vendor. For ChromeOS, this is only available if the extension was force-installed by an enterprise policy |
| hardware_version | text | Hardware version Only available on macOS, Windows, and Linux |
| hostname | text | Network hostname including domain. For ChromeOS, this is only available if the extension was force-installed by an enterprise policy |
| local_hostname | text | Local hostname (optional) Only available on macOS, Windows, and Linux |
| physical_memory | text | Total physical memory in bytes |
| uuid | text | Unique ID provided by the system |
Example
See the CPU architecture of a machine as well as who made it and what its serial number is.
SELECT CPU_type, hardware_vendor, hardware_model, hardware_serial FROM system_info;Notes
- This table is not a core osquery table. This table requires the fleetd Chrome extension.
Questions?
SOC2 Type 2
