Report purpose need to set a query on the tickets(incidents) which are in pending more than 30mnts

[Community Alums]

Hi All, 

For reporting purpose need to apply a query on the incident table to get the pending duration time. 

for the tickets which are in pending state more than 30mnts. 

as we have the pending duration column in the table but there is no data in it. 

Any suggestions. 

[Danish Bhairag2]

Hi @Community Alums ,

You can check the below link that will help u to create report on this. Kindly add additional filter to it for state is pending

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

Thanks,

Danish

[AndersBGS]

Hi @Community Alums ,

You can create an incident metric definition for pending duration. 

Based on above, you can create a report based on the incident_metric table where condition should be definition is pending duration and value is On Hold".

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

Best regards

Anders 

[AndersBGS]

Hi @Community Alums 

If my answer has helped with your question, please mark my answer  as accepted solution.

Best regards

Anders