Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Least ordered catalog items report

RforNewbie
Tera Guru

‎12-11-2023 08:55 AM

How can I make a report of the least requested catalog items of a certain category in the Service Catalog?

I tried using the sc_cat_item table, where I put as filters Sys id is one of the "javascript:new ReportFilter().getItemsInCategory('insertSysID') and I also put a related list "Requested -> item" and "Created at or after last months" . equal to 0
However, the results seem to be incorrect, any idea how I can make this report?

0 Helpfuls
  • 344 Views
1 REPLY 1

Kristen Ankeny
Kilo Sage

‎12-11-2023 09:05 AM

I would use a database view to do this, join together requested item and catalog item - this would allow you to see the catalog items that have no requested items submitted. Then you can report on that database view to get your analysis.

0 Helpfuls