Skip to main content

Create a Report for Audit Table Data

Overview Each table that is being audited will have a corresponding audit table. Audit Table information can be freely reported on using a standard User Report. Note that each audit table: Has the sa

Updated over 2 weeks ago

Overview

Each table that is being audited will have a corresponding audit table. Audit Table information can be freely reported on using a standard User Report. Note that each audit table:

  • Has the same set of fields plus additional audit columns (as described below)

  • Will be named AAL_TABLENAME (eg: Assignment will have AAL_ASSIGNMENT)

  • Will include a view comparing old and new values per change on each record

For more information on column names, refer to the main Audit Logging article here

Creating the Report

The first step to access audit data is to create a User Report Type with the required Audit Table as the base table (eg AAL_TABLENAME). This will then make the table data available to your new User Report.

user_report_type_base_table.png

You can then create a User Report using the Report Type you previously created:

user_report_details.png

Once created, all table data can be utilized to build a report as required, using filters and existing User Report functions.

Did this answer your question?