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

[saahilkumar]

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

[saahilkumar]

Thanks a ton suseela, just one more question

what was the purpose of metric instance as initally i tried building the database view only with metric definition and catalog task. How did made a difference after metric_instance was included

Thanks in advance

[Suseela Peddise]

Hi Saahil,

A metric instance is a record in the metric_instance table. A record holds one instance of a metric.

Please refer the below wiki link for more details:

Metric Definition Support - ServiceNow Wiki

Hope this might be helpful.

[johnram]

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: Metrics

Visit http://docs.servicenow.com for the latest product documentation

[Bill_Ymr_61]

Thanks.  This actually helped me with a similar reporting issue.

[yed]

Hi 

I have created a metric definition today and Is there a way to pull the old CTASK metrics created before today ?

Thanks