want a report unused catalog items

[harsha vv]

I want a report on  unused catalog items and also need  the date when that was lastly used 

[Slava Savitsky]

What have you already tried? What is the exact problem you are struggling with? Do you know what type of record is created from a catalog item in ServiceNow? Do you know which field stores the creation date of a record in ServiceNow?

[AndersBGS]

Hi @harsha vv ,

If you have PA you can created a scripted automated indicator to capture the utilization from the catalog. 

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

Best regards

Anders

[Brian Lancaster]

You can create a database view with a left join. You will need the following tables in the view. You can add left join to the list. Make sure you follow the order in the screenshot below.

Then to run a report you just need the item field (this will be from the sc_req_item table) along with name field which is from the sc_cat_item table. Use the following conditions to get what should just be catalog items. Anything where sc_cat_item is empty the corresponding item has never been ordered.

[harsha vv]

Hi brian,

thanks for responding, I want only last 6 months data of unused catalog items. Can you help me on this please?