Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Is there any way to figure out the used time to close a ticket?

GaominZ
Tera Contributor

For supportdesk management, I want to know how many days my staff are using to answer and close a ticket. 
Is there any table having related data, and any way to show the number of it?

6 REPLIES 6

Hi @GaominZ 

 

Is your issue is resolved?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Bhuvan
Giga Patron

@GaominZ 

 

You can track more information of incident state field using sys_history_set and sys_history_line tables. You can create a report using these tables to show more details of incident state breakdown.

Bhuvan_2-1755150531307.png

Bhuvan_4-1755150566160.png

Bhuvan_1-1755150483093.png

Thanks,

Bhuvan