erratasystemsreport


Description

Patches out of compliance information with the details about the system.

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

errata_id numeric 131089 null

The id of the patch

advisory_name varchar 100 null

The unique name of this advisory

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

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 ;

synced_date timestamptz 35,6 null

The timestamp of when this data was last refreshed.

Relationships

View Definition