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 

[Shivani_singh]

Hi @Mani Polisetty2 
Did you got the answer?

[Shivani_singh]

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

[Saurav11]

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:-

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.

[Saurav11 · Accepted solution]

Hello @Mani Polisetty2 

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

Please mark my answer as correct based on Impact.

[purdue]

Hello,

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

Thanks,

Chad