Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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