Tables
Tables{{numberOfTablesDisplayed}}
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 |
| 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.
Edit page
Need more help?
Ask the community on Slack
SOC2 Type 2
© 2024 Fleet Inc.
Privacy
