Document toolboxDocument toolbox

14.1 sp418_system_state_audit

This table is the audit table for sp417_system_state. 

 

Housekeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
sequence_nonumber (error)
timestampdate (error)
user_idvarchar2(256) (tick)
old_statenumber (error)
old_osuservarchar2(256) (tick)
old_master_hostvarchar2(64) (tick)
old_system_startdate (tick)
old_system_enddate (tick)
new_statenumber (error)
new_osuservarchar2(256) (tick)
new_master_hostvarchar2(64) (tick)
new_system_startdate (tick)
new_system_enddate (tick)

Keys

None.

 

Column Descriptions

FieldDescription
sequence_no Unique identifier: the sequence number of the update.
timestampDate and time at which these details were saved. Uses the time zone of the DBMS server machine.
user_idOperating system user. 
old_stateOld value for ServiceOptimizer instance state.
old_osuserOld value for OS user that ran the last master system monitor process.
old_master_hostOld value for server machine that ran the last master system monitor process. 
old_system_startOld value for date and time at which the ServiceOptimizer instance was last started.
old_system_end Old value for date and time at which the ServiceOptimizer instance ended.
new_stateNew value for ServiceOptimizer instance state. 
new_os_userNew value for OS user that ran the last master system monitor process. 
new_master_hostNew value for server machine that ran the last master system monitor process. 
new_system_start New value for date and time at which the ServiceOptimizer instance was last started.
new_system_endNew value for date and time at which the ServiceOptimizer instance ended.