To create a report that shows for how long duration a ticket is in particular state for a particular

[Sohail Khilji]

Hi @vinod_yadav1507 ,

You need to create a report on metric table.

Refer this : 

There is a OOB meric Incident State Duration, which will capture the time spent on each state.

You need to create a report on metric_instance table with below filter condition,

Definition is incident State Duration.

[Dr Atul G- LNG]

Vinod, you can use OOtB metric definition which is available on Inc record and with same you can create the report as well.

[Maddysunil]

@vinod_yadav1507 

Below link will help you:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0793124 

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks

[AndersBGS]

Hi @vinod_yadav1507 

Create a metric defintion to capture state:

1.

2.

3. This will generate below result:

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

best regards

Anders