Recently I came across a requirement where we needed a report which shows all the Incidents ever updated by a specific user. We needed a capability to filter those incidents by User, showing the changes which was made with date.

I achieved it using a database view using sys_audit and incident table and wanted to share it here. We can use any table we want to audit(change, problem etc). Below are the steps:

1. Create a Database view something similar to below

2. Add the required fields to both the tables.

3. Configure a list view something like below:

Please note that the user field is a string field so you may need to enter the user ID rather selecting from references.