How to get incident assigned time

[srikanth shesha]

I have a requirement to create a report on the incident assigned at time ,  can anyone please help?

[Michael Lee1]

I would try creating the report on the metric_instance table. If you look on the metric_definition table there's an out of the box definition that calculates the duration of time an incident is assigned to a person, who it's assigned to etc. If you look in the related lists section it will have all the records it creates for that particular definition. Those records exist on the metric_instance table. 

So create your report on the metric_instance table and in the condition builder choose "Definition is assigned to duration" and "table is incident." 

In your columns add "value, ID, duration," and then group them by ID. 

Hope this helps.

[newnowlearner]

Hi Michael, i was going through this post... im very very new to service nowthis solution really helped me create a report on the duration aspect of an agent from the incident table. Additionally, i was trying to achieve the ticket assignment time to a user from a particular group only. I've tried but i could only get the duration aspect of a user on a record OR the duration aspect of a group on a record but not both together.  Your help would be much appreciated. thank you

[srikanth shesha]

From metric_instance table, I’m able to get the ticket assignment time to a User. Can I know, from which table I can get the ticket assignment time of a group?

[Paul Curwen]

The OOTB Metric should do it: