Report catalog items never ordered
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 03:57 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 08:54 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-05-2016 06:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2024 09:51 AM
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".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2025 05:20 PM
Hello,
This works for ones which have not been used before but does not work if you add a date.
Thanks,
Chad