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

[Purushotham1992]

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

want to know the timing(time frame) of the  incident, is assigned to group 

thanks in advance 

[Community Alums · Accepted solution]

@Purushotham1992 -

If you look at the metric_definition table there's an out of the box definition that calculates the duration of time an incident is assigned to an assignment group or user, 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. 

[Community Alums · Accepted solution]

@Purushotham1992 -

If you look at the metric_definition table there's an out of the box definition that calculates the duration of time an incident is assigned to an assignment group or user, 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. 

[AndersBGS · Accepted solution]

Hi @Purushotham1992 ,

You need to look into incident_metric and metric_definition. Here you can create a definition that capture the time for when an incident is assigned to a specific group. You can find the product documentation here: Define a metric (servicenow.com)

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[rituparnadeb]

I could fetch data from metric definitions table. but from report how can i fetch data from the inner  table with a filter from the main metric definition report table. Related List Condition not working for the table inside