Report of catalog item which are not requested since months

[Community Alums]

Hi All,

We want a report of catalog items which are not being requested from last 6 months.. COuld some one help me, how to do this.

Regards,

Roopa

[David Ramirez]

I have seen companies that add a custom "last run" date/time field on the catalog item table and use it to run the report you mention, and a business rule to update it every time a new RITM is created. I personally don't like this solution as you get erroneous updates to your update sets and are customizing a system table.

My preferred solution is to create a custom table with very few fields with no special access control rules for any roles other than for reporting and without extending any tables, the fields would be a reference to an item and a date/time field, maybe an order count field, and use a business rule on the RITM to update the last run and run count in this custom table. then report on this table

My second preferred solution if the report is needed for admins only and not very frequently: to create a fixed script that queries the cat item table and iterates through the items, then for each item queries the RITM table, sort by creation date (descending) and limiting to only one record, and compare that RITM creation date with the date of 6 months ago and simply print to the console the name of the item if the date is older than 6 months ago or there were no results, this way you could run this simple script on demand and get the list of unused reports as often as needed.

[Harsh Vardhan]

is there any specific catalog item that you want to check or you want to check all the catalog item which has not been requested?

[Community Alums]

HI harsh,

I want all the catalog items which are not being requested.

[Harsh Vardhan]

adding one thread . hope it will help you.

https://community.servicenow.com/community?id=community_question&sys_id=e0d8cb61db5cdbc01dcaf3231f96...