inventoryreport


Description

List of all registered systems, together with hardware and software information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 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

minion_id varchar 256 null

The identifier of the minion, if the system is a Salt Minion

machine_id varchar 256 null

The identifier of the machine

registered_by varchar 64 null

The user account who onboarded this system

registration_time timestamptz 35,6 null

When this system was onboarded

last_checkin_time timestamptz 35,6 null

When this system was visible and reachable last time

kernel_version varchar 64 null

The version of the kernel installed on this system

organization varchar 128 null

The organization that owns this data

architecture varchar 64 null

The architecture of the system

hardware text 2147483647 null

A brief description of the hardware specification of this 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 ;

configuration_channels text 2147483647 null

The list of configuration channels the system is subscribed to, separated by ;

entitlements text 2147483647 null

The list of entitlements of the system, separated by ;

system_groups text 2147483647 null

The list of groups of the system, separated by ;

virtual_host numeric 131089 null

The id of the host of the system, if any

is_virtualized bool 1 null

True if the system is virtualized

virt_type varchar 128 null

The type of virtualization, if the system is virualized

software_channels text 2147483647 null

THe list of software channels the system is subscribed to, separated by ;

packages_out_of_date int8 19 null

The number of packages installed on the system that can be updated

errata_out_of_date int8 19 null

The number of patches that can be applied to the system

synced_date timestamptz 35,6 null

The timestamp of when this data was last refreshed.

Relationships

View Definition