systemaction


Description

The list of the actions performed on a system

Columns

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

The id of the SUSE Manager instance that contains this data
system_id numeric 131089 null
xccdscan.system_id xccdscan_system_action_fkeyR
system.system_id systemaction_system_fkeyR

The id of the system
action_id numeric 131089 null
xccdscan.action_id xccdscan_system_action_fkeyR

The id of the action
hostname varchar 128 √ null

The hostname of the system
scheduler_id numeric 131089 √ null

The id of the account who scheduled the action
scheduler_username varchar 64 √ null

The username of the account who scheduled the action
earliest_action timestamptz 35,6 √ null

The earliest time this action was schedule for execution
archived bool 1 √ null

True if the action is archived
pickup_time timestamptz 35,6 √ null

When this action was picked up by the scheduling system
completion_time timestamptz 35,6 √ null

When this action was completed
action_name varchar 128 √ null

The name of the action
status varchar 16 √ null

The current status of the action. Possible values Queued, Picked Up, Completed, Failed
event varchar 100 √ null

The type of event triggered by this action
event_data text 2147483647 √ null

Additional information related to the event triggered by this action
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemaction_pk Primary key Asc/Asc/Asc mgm_id + system_id + action_id

Check Constraints

Constraint Name Constraint
vn_systemaction_event (((event)::text <> ''::text))
vn_systemaction_status (((status)::text <> ''::text))
vn_systemaction_scheduler_username (((scheduler_username)::text <> ''::text))
vn_systemaction_action_name (((action_name)::text <> ''::text))
vn_systemaction_hostname (((hostname)::text <> ''::text))

Relationships

Close relationships within degrees of separation