Audit Logging

This screen allows you to identify a specific field in an Ostendo Database which, when a record is added, changed, or deleted and this field is contained in that record then an Audit Log is created that records the old value and the new value along with the User that carried out the action and the Date and Time it was carried out

Entry and Display fields

Table Name:  From the drop-down select the Ostendo Table Name against which you are carrying out this Audit Log.

Field Name:  For the Table Name selected in the previous field Ostendo will present you with a drop-down list of all Field Names used by that Table.  Select the Field Name against which you are carrying out this Audit Log.

SQL Type:  From the drop-down list select the screen event at which this Audit Log will be applied.  The options are Insert, Update, or Delete.

Buttons

Close: This will close the Audit Log screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will take you to a new line for entry of a new Audit Log record.

Save: This will save the current data without exiting the screen

Cancel: Any changes made to the Audit Log record or the last time the ‘Save’ Button was pressed will be lost.

Delete: This will delete the highlighted Audit Log record