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

Go to solution
Mani Polisetty2
Tera Contributor

‎11-29-2022 04:31 AM

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 

0 Helpfuls
  • 1,744 Views
1 ACCEPTED SOLUTION

Go to solution
Saurav11
Kilo Patron
Kilo Patron
In response to Saurav11

‎11-30-2022 03:16 AM

Hello @Mani Polisetty2 

 

Please make sure that you have selected no in the place of arrow in the below screenshot:-

 

Saurav11_0-1669806943616.png

 

Please mark my answer as correct based on Impact.

 

 

 

View solution in original post

12 REPLIES 12

Go to solution
Bhimashankar H
Mega Sage
In response to purdue

‎07-23-2025 05:34 PM

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

 

0 Helpfuls

Go to solution
purdue
Kilo Sage
In response to Bhimashankar H

‎07-24-2025 04:33 AM

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

thanks,

chad

0 Helpfuls

Go to solution
matthewzahrt
Giga Contributor

‎07-24-2025 10:14 AM

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!

0 Helpfuls