Reporting on catalog item non-use

[schmidt4081]

Hello. We have ~200 catalog items and record producers in our service catalog and we would like to generate a report showing the ones that have never been used. 

[jstoessel]

We had the same type problem,  I created a report against the Requested Items which I could dot-walk to Catalog Item.

Then I did a comparison of the active Catalog Items to find those that did not appear on both lists.

It wasn't some of my best work, but it got me through a quick analysis - it served the purpose without actually making a PA or other level or report.

Hope this helps

[Ravi Chandra_K]

Hello @schmidt4081 

You can try the approach by Rusheet below

https://www.servicenow.com/community/now-platform-forum/report-catalog-items-never-ordered/m-p/11103...

Please mark the answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra 

[jonsan09]

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".

[AndersBGS]

Hi @schmidt4081 ,

If you have performance analytics installed, you can create a some PA to capture the utilization of catalog items. This will not only show the once that have never been used but also those that might only have been utilized 1 or 2 times. example shown below where I look at utilization on monthly basis:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders