Setting up Data Audit

Data Audit enables you to audit many of the data tables in the business unit groups and the domain in your system.

Note: 
  • Data must be input in order for data audit data to be extracted.
  • To be able to setup and maintain Data Auditing you must be a member of the main Data Access Group on the Maintenance Plan and a member of the Extract and Clear Down Data Access Group.
  • These steps must be repeated for each business unit group or domain for which data auditing is required.
  1. Set up a maintenance plan to define the following:
    • Actions to audit. That is, insert, update and delete.
    • Retention periods.
  2. Set up the Data Audit Configuration in which you can assign maintenance plans to specific tables. This activates the audit actions defined on the Maintenance Plan for the table it is attached to.
  3. Run the Data Audit Extract. This results in an Excel spreadsheet output file containing the audit data which you can then sort, interrogate and print, as required.
  4. Clear down data which is no longer required.