Creating reports on service catalog

Anna_Servicenow
Tera Guru

I am in need of a report that shows the number of times catalog items on serviceportal have been used. Usage from this year would be a good date range. Is this possible?

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Anna_Servicenow 

 

What do you mean by used? We can create report how many Req has been raised against catalog item.

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

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

Dr Atul G- LNG
Tera Patron
Tera Patron

This way:

 

AGLearnNGrow_0-1718285790590.png

 

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

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

Erik Gardner1
Giga Guru

Hi Anna,

 

This is a very good article on how Service Offering, Catalog Items and the resulting requests are supposed to work together. It's actually a bit more complicated than one might think.

 

https://www.servicenow.com/community/common-service-data-model/csdm-amp-request-catalog-service-offe... 

scott barnard1
Kilo Sage

Hi Anna

There is a table sp_log, you can query this table using Type = Cat Item Request, then just pick the date range you need.

If you have many portals define which ones you want to report on to reduce the size of the list.

 

If you just want the info then type sp_log.list in your navigator and filter by type = cat item request then group by the Text field then do a count Descending or Ascending to show the high use items and the low use ones.

 

Regards