Service Catalog Item Usage Report

[Rick Love1]

I need to know how to run a comprehensive report that will tell me how many times the Catalog Items in our Service Catalog have been used. The goal is to identify the ones that are not being used so we can evaluate and improve them.

[Community Alums]

try the report below. its a Pivot table. top is Report condition and bottom one is report output

[DJL2]

Hi Rick,

Samir's approach will show you the RITM volumes attached to each Catalog Item.

In addition to this, it'd be worth running a separate query against the Catalog Item [sc_cat_item] table, but using a Related List to determine which have no RITMs against them.

To do this, set the following within Related List Conditions:

1. Requested Item->Item
2. Less than 0

To verify, change (2) to 'Greater than 0' which will return the inverse, ie: Items with RITMs.

Thanks,

DJL

[Eeson]

Hey Rick,

This is how I identify catalog items that have not been used in the last 12 months.

• Get a list of active catalog items,
• Where there has been zero requested items created for them in the last 12 months.

(This uses the related list condition.)

This is very similar to the goal you have on your question - 'The goal is to identify the ones that are not being used so we can evaluate and improve them.'

Hope this is useful for you together with the previous posts.

Cheers!

[Jeremyramirez12]

Hi,

How would you go about generating a report that will show all catalog items with ZERO usage in the last x number of months/years?