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
  • 233 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