How to create a report for all active catalogs?

Helan
Tera Contributor

‎07-21-2025 02:53 AM

Hello, how to create a report for all active catalogues with Name, Document available(yes/no), If yes name of the document, attachment available(yes/no), URL available(yes/no) If yes, their name? Can anyone let me know on this?

 

0 Helpfuls
  • 319 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

‎07-21-2025 03:00 AM

Hi @Helan Do you need a report of the catalog items or the requests raised through the catalog?"

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

Helan
Tera Contributor
In response to Dr Atul G- LNG

‎07-21-2025 03:05 AM

Report of Catalog Items which has got Attachments, URL, Documents and Manger Approval attached

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Helan

‎07-21-2025 03:09 AM

Hi @Helan 

Are these explicit variables: Attachments, URL, and Documents?"

"For approvals, you need to use the 'sys_approval' 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]

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

Ankur Bawiskar
Tera Patron
Tera Patron

‎07-21-2025 03:35 AM

@Helan 

are those variables on your catalog item?

what's your exact requirement?

share screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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