Standard AQ - Audit

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.

mceclip1.png

 

 

Parameters

mceclip0.png

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, ...)

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share