Audit Trail Reports

General Audit Trail Report

The Audit Trail records actions of operators throughout the system. Each entry has a date time stamp, the action and the operator that performed that action. The audit trail can be enabled or disabled via Operational #40.

To view booking audit trail, right click on the booking-->view-->audit trail

Alternatively, access the same report via right click on customer grid-->view-->audit trail

Scope

Narrow your audit trail selection based on the available scope below

Sample Output

Querying the Database

For users interested in creating their own audit trail reports, all general audit trail entries are saved in tblAudit. The audit codes are saved as an integer and relate to the following actions:

Open Return Audit Trail

This report details a list of all bookings that were partially or fully returned in an Open Return session. Scope can be narrowed down multiple ways.

Asset Audit Trail

The Asset Audit Trail writes to tblassettrail and reports on the following actions:

1. Create Asset
2. Delete Asset
3. Change Asset product code
4. Change Asset Stock Number
5. Change Asset Barcode
6. Change Asset Disposal Type
7. Change Asset Home Location 
8. Change Asset Service Status
9. Move Asset to a different product
10. Move Asset to a different product and stock number changed

Audit Trail general

This Audit Trail General Report shows who changed an expiry date on technician secondary skill records and when the change was made.

Running the report

First choose the date range for your report

Then select a particular operator or click ALL operators

Next enter the table name ContactSecondarySkills

Information stored in RentalPoint

Each Technician has a contact record which allows for a record of the technicians Secondary Skills

If you Add/Delete/Change Secondary skill Expiry Date, then tblAuditTrailGeneral will contain records of these actions

select * from tblAuditTrailGeneral