Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,702 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