system_info

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;