Measuring Requests by Catalog

[SJEaton]

Hi

I'm trying to create some measures in the advanced analytics and want to count the number of service requests received each month by a particular catalog item.  I've looked at the Main Request Table on the wiki but can't seem to see a column name I can use to determine I only want to measure a particular catalog item.  Am I missing it?

Thanks Sam

[Guest Mohamed]

Hi @SJEaton

If you would like to query against a particular catalog item, the column name is: 'h_catalog'
e.g. h_catalog = 'My Catalog Item' 

Hope that helps

Mohamed

[SJEaton]

Thanks

[Steven Boardman]

@SJEaton

Another useful resource is the Entity / Database Schema viewer which you can access via the Admin Tool:

Home > Service Manager > Entity Viewer

Steve