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.

[rituparnadeb]

Thanks tera , I was able to resolve for incident using Created (mi_sys_created_on) and definition (incident assigned to Duration from incident_metric table but for Catalog Task  I think I have to create a metric on assigned to field and checkout. But I dont have access to Metrics Definiton. Checking out with our office servicenow team

You can consider this to be partly fixed once I test the other case

[Dr Atul G- LNG]

Hi @rituparnadeb 

Good to know you are able to move forward. You can watch my video of metrics:

https://youtu.be/jpGkiML3Ztc

[rituparnadeb]

Not working as per the suggestion. its not retrieving data properly. there is a field called sys
_updated_on. Not sure which table it belongs to

-

[Ankur Bawiskar]

@rituparnadeb 

if this is for incident then you can get this information from metrics

If not for incident, then check those and create metric definition for your table similar to incident one

check these links

I want report at what exact time an INC got assigned to particular group 

How to pull the time when the incident was assigned to any Assignement Group 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@rituparnadeb 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.