systemhardware


Description

The list of hardware information of managed systems

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 0 null
system.mgm_id systemhardware_system_fkeyR

The id of the Uyuni instance that contains this data
system_id numeric 0 null
system.system_id systemhardware_system_fkeyR

The id of the system
machine_id varchar 256 √ null

The identifier of the machine
architecture varchar 64 √ null

The architecture of the system
cpu_bogomips varchar 16 √ null

The CPU bogomips value
cpu_cache varchar 16 √ null

The CPU cache size in KiB
cpu_family varchar 32 √ null

The CPU family
cpu_mhz varchar 16 √ null

The CPU frequence in MHz
cpu_stepping varchar 16 √ null

The CPU stepping
cpu_flags varchar 2048 √ null

The CPU flags
cpu_model varchar 64 √ null

The CPU model
cpu_version varchar 32 √ null

The CPU version
cpu_vendor varchar 32 √ null

The CPU vendor
nrcpu numeric 0 √ 1

The total number of CPUs of the system - sometimes called vCPUs
nrsocket numeric 0 √ 1

The total number of CPU Sockets of the system
nrcore numeric 0 √ 1

The number of Cores of a single CPU
nrthread numeric 0 √ 1

The number of Threads of a single Core
ram numeric 0 √ null

The amount of RAM of the system in MiB
swap numeric 0 √ null

The amount of swap space of the system in MiB
vendor varchar 256 √ null

The system vendor
system varchar 256 √ null

Additional information about the system
product varchar 256 √ null

The Product information of the system
bios_vendor varchar 256 √ null

The bios vendor
bios_version varchar 256 √ null

The bios version
bios_release varchar 256 √ null

The bios release date
asset varchar 256 √ null

The assets of the system
board varchar 256 √ null

The board information of the system
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemhardware_pk Primary key Asc/Asc mgm_id + system_id

Check Constraints

Constraint Name Constraint
vn_systemhardware_cpu_mhz (((cpu_mhz)::text <> ''::text))
vn_systemhardware_cpu_cache (((cpu_cache)::text <> ''::text))
vn_systemhardware_cpu_bogomips (((cpu_bogomips)::text <> ''::text))
vn_systemhardware_cpu_family (((cpu_family)::text <> ''::text))
vn_systemhardware_cpu_flags (((cpu_flags)::text <> ''::text))
vn_systemhardware_board (((board)::text <> ''::text))
vn_systemhardware_bios_release (((bios_release)::text <> ''::text))
vn_systemhardware_machine_id (((machine_id)::text <> ''::text))
vn_systemhardware_cpu_model (((cpu_model)::text <> ''::text))
vn_systemhardware_cpu_version (((cpu_version)::text <> ''::text))
vn_systemhardware_bios_version (((bios_version)::text <> ''::text))
vn_systemhardware_product (((product)::text <> ''::text))
vn_systemhardware_vendor (((vendor)::text <> ''::text))
vn_systemhardware_bios_vendor (((bios_vendor)::text <> ''::text))
vn_systemhardware_architecture (((architecture)::text <> ''::text))
vn_systemhardware_cpu_stepping (((cpu_stepping)::text <> ''::text))
vn_systemhardware_cpu_vendor (((cpu_vendor)::text <> ''::text))
vn_systemhardware_asset (((asset)::text <> ''::text))
vn_systemhardware_system (((system)::text <> ''::text))

Relationships

Close relationships within degrees of separation