erratalistreport


Description

Patches out of compliance information with their details.

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 the advisory

advisory_type varchar 32 null

The type of patch. Possible values: Product Enhancement Advisory, Security Advisory, Bug Fix Advisory

cve varchar 4000 null

A list of CVE ids that this patch addresses, separated by ;

synopsis varchar 4000 null

The brief description of this patch

issue_date timestamptz 35,6 null

When this advisory was first issued

update_date timestamptz 35,6 null

When this advisory was last updated

affected_systems int8 19 null

The number of system affected by this advisory

synced_date timestamptz 35,6 null

The timestamp of when this data was last refreshed.

Relationships

View Definition


Possibly Referenced Tables/Views