Report on SCTASK associated to Catalog Item

Brian Valente · ‎11-17-2023

I have been asked to create a report showing the groups handling SCTASKs associated with Catalog Items. Is there a way to report on Catalog Item usage based on associated SCTASKs?

Dr Atul G- LNG · ‎11-17-2023

Hi @Brian Valente

Create a report of sc_task table.

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

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

View solution in original post

Dr Atul G- LNG · ‎11-17-2023

Hi @Brian Valente

Create a report of sc_task table.

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

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

Jaspal Singh · ‎11-17-2023

Hi Brian,

You can create a report on Catalog Task table and then dot-walk to Request Item. Item to get the Catalog items associated with the Catalog Tasks. Report can be of type pivot, bar, etc. as you would like it to be visually.

Brian Valente · ‎11-17-2023

Thank you for the response, unfortunately when I add either Item(cat_item) or Item(u_cat_item) both show up as empty

Jaspal Singh · ‎11-17-2023

Can you share, what you have tried. A screenshot or two would be of much help.