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 |
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;