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.

.. code-block:: sql

   SELECT * FROM system_info;