How to create a report on catalog items which are not used from last 19 months

[Mani Polisetty2]

Hi ServiceNow Folks,

I have a requirement to create a report on catalog items (sc_cat_item) which are not used from last 19 months. How can I achieve this?

Thanks

Mani Polisetty 

[Bhimashankar H]

Hey @purdue ,

Then what is correct query ? 

Is it including the those catalog item which having the data as well? or not including even if no data for more than 18 months ?

Thanks,
Bhimashankar H

[purdue]

Dates don’t work. If you leave it blank it will find catalog item which never have never been submitted.

thanks,

chad

[matthewzahrt]

Matt from ReadyCloud here,

if any of those old workflows involve hardware returns, we’ve built a ServiceNow Marketplace app solution that uses QR codes to make returns easy. No boxes or labels needed. Let me know if you have any questions!