Report catalog items never ordered

Chris W1
Tera Expert

Hi All,

I think i'm missing something super obvious, but I can't seem to find a way to pull a report of catalog items that have never been ordered.

I have figured out that the base system report "most commonly requested items" excludes items with a count of 0. But we have ~150 catalog items so reconciling that list with our full list of items is not something I want to do regularly.

Has anyone ever pulled this report? Surely this is info we all need to understand services/catalog items that should be considered for retirment.

Thanks!

4 REPLIES 4

Rushit Patel2
Tera Guru

Hi Chris,



you can create Report on sc_cat_item table. there put condtion like sys_id is one of javascript:new yourscript().yourfunction();



then create one script include. make it client callable. in that do gliderecord query on sc_cat_item and store all sys_id in one array. then do Gliderecord on Sc_req_item(RITM) and store sys_id of cat_item field in one array. take differerence of two arrays using new ArrayUtil().diff(a1,a2) function.



return the new array returned by arrayutil diff function.



i hope this helps.


Brad Tilton
ServiceNow Employee
ServiceNow Employee

ServiceNow's not really great at pulling negative or difference reports like this. You could run a script like Rushit suggests, but the easiest thing would probably just be to export the lists of active catalog items to excel, then run a report on Requested Item and group by catalog item and just compare them or export that list and use a quick excel function to get the items that aren't duplicates.


jonsan09
Giga Sage
Giga Sage

I found a way to report on Catalog Items (sc_cat_item) that have never been used. I excluded record producers and change templates, using the related list condition I was able to filter on Requested Items (sc_req_item).  You could theoretically set the threshold in the related list condition, for example "Requested less than 50 times".

msedge_oTcOxZHpaI.png

Hello,

This works for ones which have not been used before but does not work if you add a date.

Thanks,

Chad