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

Mani Polisetty2
Tera Contributor

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 

1 ACCEPTED SOLUTION

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

Hi @Mani Polisetty2 
Did you got the answer?

Hi @ersureshbe 
I have created the Database view, can you please help me the condition?

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

As answered by @Murthy Ch , please do the below. I have already tested this it will work fine:-

 

Create a report on sc_cat_item table with the below condition:-

 

Saurav11_0-1669726532285.png

 

 

This report with give you all the items which has not been ordered in the last 18 months.

 

Please mark my answer as correct based on Impact.

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.

 

 

 

Hello,

This does not work.   I looked at the data directly it includes ritms that should not be in the query.

Thanks,

Chad