Description

The report allows checking audits on various tables in the Adonis database. Any view/table existing in the database with the prefix udfAuditLog can be transformed into a user-friendly format.

Dialog

Open

Audit Dataset - the list of system objects in the database prefixed 'udfAuditLog' to process its data only

Users - to limit modifications made by the selected users only

Date From / To - to limit the period of audits selection

Sample

Open

Fields/ Columns Specification

User ID - internal application identifier for the user.

Login Name - user's application login.

User Name - name as defined in ACC.

Session ID - unique identifier for the user's login session.

Session From / To - time stamps for the session start/end.

Change Time - time of modification on the server side.

Table Name - database table name.

PIN - unique identifier of a crew member who was the subject of modification.

SEQNO - unique identifier of the modified record in the table.

Field Changed - database name of a field that was the subject of modification.

Original / New Value - field value before/after modification.

Additional Details

N/A

Attachment