How does the Servoy Audit Log work?

Audit Log information

The audit log table records information about changes made to data in tables in a solution. Servoy documentation can lead you through setting up the audit log table through the Security options in Developer. See pgs 503-507 in the Servoy Developer User's Guide for more details on setting up audit logging in Servoy.

Once the audit log has been created, changes to selected tables will be recorded in the audit log table. Below is a listing of all the values in the audit log table and what they mean (in Servoy 3.5.5).

FIELD NAME	INFORMATION
event_time	The time the change occured
log_id	The auto incrementing ID of the log table
log_action	The type of change that occurred. 1 = delete; 2=insert (or add); 3=update(changed record)
server_name	Name of the DB server registered in the preferences window.
table_name	Name of the table affected by the change
column_name	Name of the column (field) in the affected by the change
pk_data	Primary key data for the record being changed. Format: x.yyyy; x=number of characters in the key. y=the actual key value. Multiples are separated by semicolons.
old_data	The old data value before the change.
new_data	The new data value after the change.
user_uid	The UID value for the user making the change. To see your userâ??s UIDs, run the following statement against the servoy_repository: SELECT * from servoy_users