In sys_audit (history) table all the data is not visible only few records were visible at a time

[AshwiniSawant]

Hello @Uncle Rob ,

We have below requirement -

1. We have our own module for Security Incidents and user want to calculate the below -

2. There is automation due to which tickets got assigned to robot and then team members get those ticket assigned to themselves (reassignment).

3. User want to fetch the data like which assignee have reassigned that ticket in how much time since its open. i'e update time of the ticket.

4. When we try to check data in audit history table, all required data is not visible , can you please help me why all the required data is not fetched at the same time. Only few records were visible at a time, and we need to find data by searching individuals name but overall its doesn't showing all the data. 

Below is the result column we want -

Thank you in advance !

[Ankur Bawiskar]

@AshwiniSawant 

Thank you for marking my response as helpful.

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.