Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 0 | √ | null |
|
|
The id of the Uyuni instance that contains this data |
|
| system_id | numeric | 0 | √ | null |
|
|
The id of the system |
|
| profile_name | varchar | 128 | √ | null |
|
|
The unique descriptive name of the system |
|
| hostname | varchar | 128 | √ | null |
|
|
The hostname that identifies this system |
|
| machine_id | varchar | 256 | √ | null |
|
|
The identifier of the machine |
|
| architecture | varchar | 64 | √ | null |
|
|
The architecture of the system |
|
| cpus | numeric | 0 | √ | null |
|
|
The total number of CPUs of the system - sometimes called vCPUs |
|
| sockets | numeric | 0 | √ | null |
|
|
The total number of CPU Sockets of the system |
|
| cores | numeric | 0 | √ | null |
|
|
The number of Cores of a single CPU |
|
| threads | numeric | 0 | √ | null |
|
|
The number of Threads of a single Core |
|
| 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 |
|
| memory_size | numeric | 0 | √ | null |
|
|
The amount of RAM of the system in MiB |
|
| swap_size | 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 |
|
| primary_interface | varchar | 32 | √ | null |
|
|
The name of the system primary network interface |
|
| hardware_address | varchar | 96 | √ | null |
|
|
The MAC address of the network interface |
|
| ip_address | varchar | 64 | √ | null |
|
|
The IPv4 address of the primary network interface of the system |
|
| ip6_addresses | text | 2147483647 | √ | null |
|
|
The list of IPv6 addresses and their scopes of the primary network interface of the system, separated by ; |
|
| is_virtualized | bool | 1 | √ | null |
|
|
True if the system is virtualized |
|
| synced_date | timestamptz | 35,6 | √ | null |
|
|
The timestamp of when this data was last refreshed. |
Relationships
Close relationships within degrees of separation
