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 

[Murthy Ch]

Hi @Mani Polisetty2 

Check the below thread which is answered by @Saurav11 

https://www.servicenow.com/community/it-service-management-forum/create-report-catalog-items-that-ha... 

(not tested)

[Mani Polisetty2]

Hi Murthy,

Great thanks for your response, I have tried this but it's not working. In related list conditions I have given Requested Item --> Item and then 'created relative after 19 months ago'. The list of catalog items got listed in report but they are created recently also.

The query is taking the catalog items created recently.

Thanks

[ersureshbe]

Hi, create the filter sc_req_item table and find last 19 months record. 

Create a DB view and map with sc_cat_item and write the join based on cat_item field. Find the what are the catalog item is not part last 19 months.

[Mani Polisetty2]

Hi Tera Guru,

Great thanks for your quick response, I haven't created database view's yet. Can you please help me more to create it.

Thanks

Mani Polisetty