How to show the date of a ticket that is assigned to various assignment groups?

[Kathrina Yvonne]

I need to create a report that shows tickets that were resolved, as well as the dates they were re-assigned to another group (in case they are reassigned). In case a certain ticket is reassigned, it should show 2 tickets, with each ticket having different assignment groups. If it's been reassigned 3 times, then it should show 3 tickets, and so on. How can I do this? Thanks a lot to those who'll help!

For example: Ticket 1 - assigned to group 1 on Monday

                      Ticket 1 - assigned to group 2 on Tuesday

                      Ticker 1 - assigned to group 3 on Wednesday

Report: Ticket 1 - Group 1 - January 1, 2022

             Ticket 1 - Group 2 - January 2, 2022

             Ticket 1 - Group 3 - January 3, 2022

[Sai Kumar B]

@Kathrina Yvonne Cruz 

You can find Record history in the sys_history_line table, You can report on that table to find out Assignment group new/old values along with the date-time stamp.

[Kathrina Yvonne]

sys_history_line doesn't show under the available tables when creating a report. I'm also gonna use the incident table, just want to fetch data from related list to the table but still dont know how. 

[Sai Kumar B]

@Kathrina Yvonne Cruz  

Go to the table and right-click on one of the columns and select "Bar chart" or "Pie chart". That starts the report engine. From there you can customize and configure the report as you need.

[ShannaH]

What if you do not have a sys_history_line table?

I am trying to get my aging ticket report to show the dates the ticket was assigned to an assignment group.

I am pulling from the incident table.

When I search for the table you mention it is not found.

Is there a field from the incident table that would show the date a ticket is assigned to an assignment group?