Hi, I am trying to create a report from sys_audit table to access past data. The requirement is to create a report that shows me the ticket data in a specified timeframe that is either handled/touched by agent. I know reporting against sys_audit is not the best practice, but this is a client requirement which can't be denied. Now I'm trying to create a database view since audit table stores everything in sys ids,
1. I'm connecting "New value" with user table to get the data on fields like "Assigned to"
2. Linking document key with incident sys id.
I'm planning to create separate DB views for incidents, sctasks, change likewise...
Now the issue is, there is a vast difference in record count between DB table and audit table records even after applying necessary filters.
