how to get assignment date, when a ticket is assigned to a person

[rituparnadeb]

How to generate a report where we want to fetch the date ,  when a ticket was assigned to a pariticular assignee. No common fields I found under assigned to or assignment group.

[J Siva]

Hi @rituparnadeb 
You can get those details in Incident Metric table (incident_metric). Created (mi_sys_created_on) field provides the date and time when the ticket was assigned to a specific assignee.

Hope this helps.
Regards,
Siva

[rituparnadeb]

Its not working, not fetching the right data some date getting missed. there must be a field called sys_updated_on

_

[rituparnadeb]

No it does not work, the behavior is not consistent. I need assigned date of an assignee(even historial data it should give)
 not fetching .

[Dr Atul G- LNG]

Hi @rituparnadeb 

Out of the box, no field captures the information regarding when an incident has been assigned to a user. You can create the metric on the Assigned to field, and checkout metrics for the same.