Standard AQ - Audit

Overview

Updated 04/05/2022

• Click here for information on Standard Reports
• Click here for information on Advanced Queries
• Click here for information on Self-Serve Utilities

Report Description
Parameters
Report Fields

Report Description

This report lists all changes made to any table along with the value prior to the change, the date the change was made, and the user that made the change.

Parameters

Parameter Name	Options	Description
Start Date (Audit Date Modified)		Date Modified
End Date (Audit Date Modified)		Date Modified
User Description		Filters results by User Description
Table Name		Filters results by Table Names
Column Name		Filters results by Column Names

Report Fields

Field Name	Description
Audit Type	Type of change done. Like – Update, Delete.
Table Name	List the table names in which changes were made
ColumnName	Name of the columns in which changes were made
OldValue	The old value before a change
NewValue	The new value after a change
DateModified	The date in which modification was done
UserName	The name of the user who did the changes
UserDescription	The description of the user who did the changes
AdditionalNotes
EntityID	The ID associated with the Entity (Customer, Employee, ...)
EntityName	The name of the Entity (Customer, Employee, ...)
EntityType	The Type of Entity (Customer, Employee, ...)