Home › Frequently Asked Questions › Development

How does the Servoy Audit Log work?

Thu, 03/13/2008 - 14:56 — jmeunier

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

Comments

Post new comment