The CreatorCon Call for Content is officially open! Get started here.

Report Help

Ralton Stewart
Tera Guru

Hello Community I need  to create a report to find out all the tickets or tasks, that were closed or resolved by a specific group, or tickets which were at any point were in that group which were then routed to another queue.

 

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Ralton Stewart 

 

You can use the Metrics for this. There are OOTB metrics

LearnNGrowAtul_0-1706612213019.png

 

 

You can create the definition and then get the details. 

*************************************************************************************************************
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]

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

I found it thanks can you talk me through how to actually create it using that metric please?

 

Hi @Ralton Stewart 

 

LearnNGrowAtul_0-1706614592215.png

 

click n definition

Click on New

Fill details

LearnNGrowAtul_1-1706614668098.png

 

 

You can check OOTB Metrics for reference.

*************************************************************************************************************
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]

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

AndersBGS
Tera Patron
Tera Patron

Hi @Ralton Stewart ,

 

It really depends if you have had configured a metric to capture the assignment / re-assignment or not. for tickets that were closed or resolved by a specific group - this can easily be done through the report designer. for "or tickets which were at any point were in that group which were then routed to another queue." - if no metric has captured the re-assignment, then the only option is in the sys_history_line (though, i don't think it will provide you the overview that you're looking for).

 

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

 

best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/