Service catalog item request frequency

[Tim Grindlay]

Hi,

I have a fairly straight forward request to produce a report of all service catalog items and how many times each of those catalog items has been requested. I was expecting to find something OOTB but it doesn't appear to exist, there are very similar reports like top n requested items but not exactly what I'm after. In excel, SQL, crystal reports or even MS access this is a fairly trivial task, but I can't seem to replicate that in ServiceNow. Possibly there is some way with performance analytics, but I don't know enough about pa yet to know how to accomplish this.

The solution I have come up with is creating a left join database view with sc_cat_item and sc_req_item. Now this gives me the record set I require, all catalog items and the requested items related to them, even if there are none. I can group total the list on the item field, which gives me the total I want, except for those items that have no related requested items. The total for these rows will show as 1 instead of 0, because the total is counting the number of rows. I want the total to count the number of requested items.

I want to avoid using scripting and dynamic content where possible so that users can still adjust the filters, or drill down and export as necessary.

Regards,

Tim

[Shane J]

Why not just report off the Requested Item table, by 'Item'?

[Tim Grindlay]

Because that won't give me a complete list of the catalog items that are 'available to be' requested. Only those that 'have been' requested.

[Shane J]

They're '0'.  

[Tim Grindlay]

Not sure if I'm missing something here or not...