URGENT : REPORT: how to pull a report of all catalog tasks assigned to a group

saahilkumar · ‎06-22-2017

Hi All,

Requirement: Need to pull a report of all the catalog task(sc_task) that were assigned to Service Desk at one or other point in this month.

The issue is since the Service Desk re-assigns the catalog task to other queues, so how to know how may catalog tasks were assigned to them this month.

For ex: Service Desk received 100 catalog task this month and they reassigned 90 to other queues. Presently, they have only 10 in their queue. But I would like to pull the report of all 100 catalog task that were assigned to Service Desk at one or other point this month.

Thanks in advance

Suseela Peddise · ‎06-26-2017

Hi Saahil,

Please find the 'Where Clause' conditions for catalog task data base view.

There is an OOB database view called "sc_task_metric" available.

But there is no OOB metric definitions available on sc_task table. You need create according to the requirement,

Hope this might be helpful.

View solution in original post

Shishir Srivast · ‎06-22-2017

Metric Definition Support will allow you to capture the metrics as data is update and stored in the metrics table. You can create a Metric Definition that creates a metric record a task is reassigned to another Assignment Group.

http://wiki.servicenow.com/index.php?title=Metric_Definition_Support#gsc.tab=0

Kalaiarasan Pus · ‎06-22-2017

Is there a metric Out of the box on catalog task assignment group field?

saahilkumar · ‎06-23-2017

Hi Kalai,

Thanks for the update.

there was no OOB metric, so I have now created a metric on catalog task for assignment group field, below is the screenshot, can you pleas assist how can I report on this to know the number of catalog task assigned to Service Desk this month

saahilkumar · ‎06-23-2017

Hi Shishir,

I have created a metric on catalog task for assignment group field. Can you let me know how can I report on this.

Thanks in advance