Dashboard/Report on Unused Catalog

purdue · ‎07-23-2025

Hello,

I need to build a Dashboard/Report on unused Catalog Items. I need the reports by create date

1. From today to a year ago 7/23/25-7/23/24

2. From a year ago to 2 years ago. 7/23/24-7/23/23

I tried with this report but looking at RITMS I am getting catalog items outside of this date range. Any assistance is appreciated.

Also for the report I selected none for the related list condition. Is this correct?

Thanks,

Chad

Brian Lancaster · ‎07-28-2025

I would create a database view with a left join. You will have add left join to the list in the view tables section. It would look like this.

You can get the reports this way. I would do an additional one here you add number to the columns and do a filter were number is empty this will give you items that have never been ordered if you have any. Otherwise you can Created to do that date ranges. Just make sure you choose the one with (ritm_sys_created_on) next to it so you run the report on the date range against the request item table.

View solution in original post

wojasso · ‎07-23-2025

Hi @purdue

Catalog Items themselves don’t store “last requested” dates, so reports on the Catalog Item [sc_cat_item] table will not tell you which items are unused over a period. The usage is recorded on the Request Item [sc_req_item] table as each RITM references the catalog item.

To find items with no requests in the last year, create a report on Catalog Item and add an advanced filter using the Not in operator: sys_id not in Request Item.cat_item where opened_at is on or after Relative → Last 1 year. This will return every item whose ID is not present in any RITM created in that period.
You can build a second report for the 1–2 year period by changing the subquery to opened_at on or after Relative → 2 years ago and on or before Relative → 1 year ago. The “not in” condition will then find catalog items that haven’t been requested in that window.
If you need counts, run a report on Request Item, add a condition opened_at within your date range and group by the Catalog Item column. Items with zero results won’t appear, so you can compare the list of all items against this report to identify unused ones.
Alternatively, create a database view or Performance Analytics indicator that calculates the last request date per catalog item; then you can easily filter items where the last request is older than 12 months.

💥 Was this answer useful? 👏 If so, click 👍 Helpful 👍 or Accept as Solution ✅ 💡🔬🔗👍

purdue · ‎07-23-2025

Hello,

How do I setup the advanced filter?

Thanks,

Chad

Brian Lancaster · ‎07-24-2025

This appears to be AI output. I got something similar with Microsoft Copilot.

purdue · ‎07-23-2025

Sorry I don't see the advanced filter in reports.