Reporting on Unused and Used Catalogue Items in one Report

[Mussie]

Hi Guys,

I want to generate a report on catalogue items that have been not been used in the last one month but used in the last 6 months. I know I can generate two reports for this but I want to do that in just one report and I am not using PA for this so using the OTB reporting tool.

Any ideas?

Mussie

[Adam Stout · Accepted solution]

Sounds like you want to use a Related List Condition: https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/use/using-lists-v3/task/cre...

If that won't work, try some of the things discussed on this blog: https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

[purdue]

Hello,

These links are broken.

Thanks,

Chad

[Mussie]

Thanks Adam, it looks like the related list filter doesn't work with Dates properly. For the below report, I am getting catalogue items which have requested items created after last month which shouldn't be the case if this was working:

Mussie

[Adam Stout]

You want Has None (not has 1 or more) and the conditions are created on last 30 days.

You are looking for things that do not have it, not for things that had it before (your current query).