xccdscanresult


Description

The list of results for a SCAP scan

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
xccdscan.mgm_id xccdscanresult_scan_fkeyR
system.mgm_id xccdscanresult_system_fkeyR

The id of the SUSE Manager instance that contains this data

scan_id numeric 131089 null
xccdscan.scan_id xccdscanresult_scan_fkeyR

The id of the security scan

rule_id numeric 131089 null

The id of the rule

idref varchar 255 null

The reference of the rule

rulesystem varchar 80 null

The name of the rule system

system_id numeric 131089 null
system.system_id xccdscanresult_system_fkeyR

The id of the system

ident varchar 255 null

The CCE v5 id of this rule

result varchar 16 null

The result of the scan for this rule

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
xccdscanresult_pk Primary key Asc/Asc/Asc mgm_id + scan_id + rule_id

Check Constraints

Constraint Name Constraint
vn_xccdscanresult_ident (((ident)::text <> ''::text))
vn_xccdscanresult_rulesystem (((rulesystem)::text <> ''::text))
vn_xccdscanresult_idref (((idref)::text <> ''::text))
vn_xccdscanresult_result (((result)::text <> ''::text))

Relationships