System information for identification.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: system_info

  • Windows
  • Linux
  • Mac OSX
  • Free BSD

Table schema

Name Type Description
hostname TEXT Network hostname including domain
uuid TEXT Unique ID provided by the system
cpu_type TEXT CPU type
cpu_subtype TEXT CPU subtype
cpu_brand TEXT CPU brand string, contains vendor and model
cpu_physical_cores INTEGER Number of physical CPU cores in to the system
cpu_logical_cores INTEGER Number of logical CPU cores available to the system
cpu_microcode TEXT Microcode version
physical_memory BIGINT Total physical memory in bytes
hardware_vendor TEXT Hardware or board vendor
hardware_model TEXT Hardware or board model
hardware_version TEXT Hardware or board version
hardware_serial TEXT Device or board serial number
computer_name TEXT Friendly computer name (optional)
local_hostname TEXT Local hostname (optional)

Query examples

Select all the results for the given table.

SELECT * FROM system_info;