Catalog Task Metrics Report is coming as Blank

SNOW46
Tera Contributor

‎10-15-2018 04:25 AM

Hi All,

 When I am trying to pull report from the Catalog Task Metrics(sc_task_metric) table it is  showing all blank records as no records found.

I want to pull the reports for the same table for Catalog task with definition as Assignment Group.

But its working fine for "incident_metric" table. 

Can anyone let me know how to fix this issue so that I can able to fetch the report. Please find the below screenshot for reference.find_real_file.png

 

 

Kindly suggest on this.

 

Thanks,

SNOW@Das

Preview file
60 KB
0 Helpfuls
  • 1,569 Views
1 REPLY 1

Omkar Mone
Mega Sage

‎10-15-2018 04:28 AM

Hi 

You can create a Metric Definition to capture this as well. If you select the sc_task table, for ex :-  assigned_to field and keep the type as "Field Value Duration", evertime the task is assigned, a new entry will be added to the metrics table. You can then report against sc_task_metric to get the desired data.

0 Helpfuls