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