...

• event_time - The time the change occured
• log_id - The auto incrementing ID of the log table
• log_action - The type of action that occurred. 1=delete; 2=insert (or add); 3=update(changed record); 4=view(data read)
• server_name - Name of the DB server registered in the preferences window
• table_name - Name of the table affected by the action
• column_name - Name of the column (field) affected by the action
• pk_data - Primary key data for the record being changed/viewed. 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 (will be null for views)
• new_data - The new data value after the change or the data that is read from database
• user_uid - The UID value for the user making the action.  This can be set during the login process or is stored in the repository if using basic authentication.

Logging Client statistics

The (de)registering of clients will be logged in a table called client_stats in the log server (if the table exists).

This table can be created using the "Create Client Statistics Table" button in the server editor for the log server.
By default this table uses servoy-sequence for its primary key generation. This can be modified to other generators (like UUID or database-sequence). Currently, database-identity is not supported.