Generating a report on unused catalog items

[quincystaley]

How can I generate a report that will show me which catalog items have NOT been used in the past year? I'm trying to deactivate catalog items that customers don't have a use for anymore, so I need to be able to see the specific catalog item name. Any insights/ideas are appreciated. Thank you!

[nishailame]

This will help you.

https://youtu.be/ySnHF5y3ubE

http://wiki.servicenow.com/index.php?title=Generating_Reports#gsc.tab=0

You can set the condition as per your requirement.

Thanks.

PS: Hit like, Helpful, Correct and Endorse, if it answers your question.

[sachin_namjoshi]

Hi,

You can report on sc_req_item to find requested items which will have reference of catalog items.

Then, you can report on sc_cat_item.to find all catalog items.

You can export both reports and use pivot to find catalog items which are not used in last 1 year.

Regards,

Sachin

[Fathima6]

@sachin.namjoshi 

Can you please explain breif about your information? I don't get the way to export both reports you meant. Please kindly help in this.

[Jochen Geist]

This is actually quite easy to achieve via the Related List conditions on a Report:

Please see below for an example report using the Relationship to the Requested Item to report on Items that have not been requested in the last 12 months.