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
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
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