Report of catalog item which are not requested since months

Community Alums
Not applicable

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

7 REPLIES 7

Hello Harshvardhan,

 

Can you please share this link again.

Adam Stout
ServiceNow Employee
ServiceNow Employee

Try using a Related List Condition (you need to use the Report Designer, it is not available in the legacy Report Builder.  You can find a few  examples of this in this article:  https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

Josh Cooper
ServiceNow Employee
ServiceNow Employee

To elaborate on Adam's answer, try something like this:

 

Report on Catalog Items table

Related List Condition:  Related to 0 records on Requested Item (Item) WHERE created after 6 months ago

 

find_real_file.png