Reports

spectura77
Tera Contributor

Hi all, 

 

Is there is a way we can create a report has the following information:

 

First one sctask is assigned to any one group ,then it is re assigned to service desk misroute group then they will re assign to to the correct group.

Whenever ever tickets is re assigned to service desk misroute in the first time need to create report for that.

 

I have tried the use the filter condition in sc_task table as  active is true & assignment group changes but that condition is not showing up in reports.

 Is there any other way?

 

Thanks in advance.

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@spectura77 

Did you try to use metrics for this?

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @spectura77 

 

yes, to do you need to create a metric on Sc_task table on assignment group

Then you can build DB with metric and sc_task

and then use that DB view for reporting.

 

OOTB Metrics example:

 

AGLearnNGrow_0-1734532586534.png

 

AGLearnNGrow_1-1734532616417.png

 

 

It is easy and straight forward. Give a try.

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

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

spectura77
Tera Contributor

ok i will try with metrics