Reporting - How to create a trend report of Catalog Item usage by month

[caraproctor]

I'm interested in creating a report where I can see the usage by month for our Catalog Items.   I can create a report of Request Items created by month, but that isn't the entire picture.   I'd like to understand both commonly used and least used Catalog Items.

We are new to ServiceNow and if anyone can point me in the right direction it would be very appreciated.

[mayurt]

Hi Cara ,

you can create a report on 'Requested item' table and use due date as group by field. hope this helps.

[caraproctor]

Thank you for the reply.

I have done something similar to that already.   But unfortunately when I report from the Requested Item table I'm only pulling data on what has been submitted.   Ideally I'd like to pull from the Catalog Item table with a join to the Requested Item table so that I would be able to report on all Catalog Items, not just those which have been used.

I'm familiar with other BI solutions where I can do this type of advanced reporting, but I haven't been able to figure out if that is possible here.   Do you know if this is possible?

[mayurt]

Hi Cara,

To join two tables in service-now you can use database view:

Database Views - ServiceNow Wiki

coming to your requirement :

1. We can create a database view say requestCI(ritm_ci) to add the table sc_cat_item and sc_req_item by using the clause as in below snapshot

then one can report on requestCI(ritm_ci)   table .

2. The count of catalog in the table generated in database view includes all the catalog(record producer, service catalog,technical catalog)

so you can add a filter condition as "class is catalog item".

3. To get the item usage you can use 'Number' field, this is the RITM number and the empty field denotes there is no ritm number .

hopefully this works

Mayur