I want to generate a report where I am the approver and also I need to know the catalog item name.

divyal09
Tera Contributor

‎03-19-2024 07:46 AM

I want to generate a report where I am the approver and also I need to know the catalog item name where I am approver.

0 Helpfuls
  • 235 Views
2 REPLIES 2

sushantmalsure
Mega Sage
Mega Sage

‎03-19-2024 07:52 AM - edited ‎03-19-2024 07:53 AM

You can hit following link , just replace instance_name with your instance name

 

https://<instance_name>.service-now.com/sysapproval_approver_list.do?sysparm_query=approverDYNAMIC90d1921e5f510100a9ad2572f2b477fe%5Esysapproval.sys_class_name%3Dsc_req_item&sysparm_view=

 

This list will give you list of all RITMs which where loggedin user is approver.

From here, you can also add column in list (RITM > item) from configure list to show the catalog name as column in list.

 

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

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-19-2024 07:57 AM

Hi @divyal09 

 

You need to create a DB view of Approval table and RITM table to get both results. 

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

****************************************************************************************************************
0 Helpfuls