Historical Data in sc_task_metric Table

RajaputanaN
Tera Contributor

an hour ago

Hi Everyone,

I created a Metric Definition for Assignment Group on sc_task, and it is populating data correctly for new changes.

How can I populate historical data in the sc_task_metric table for existing catalog tasks created before the Metric Definition was implemented? Is there a recommended approach to backfill the historical metric data?

Any suggestions would be appreciated.

Thanks!

0 Helpfuls
  • 77 Views
3 REPLIES 3

Mark Manders
Giga Patron

an hour ago

You can't. Metrics, like performance analytics, will gather data after they have been created. There is no good way to populate the previous data. It's simply not registered in a way you can easily get it with data like assignment groups.

 

But what's your use case? Assignment groups on sc_tasks shouldn't be changing that much, right? If several groups are needed to resolve a RITM, most often they all get their own tasks.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

RajaputanaN
Tera Contributor
In response to Mark Manders

46m ago

Hi  @Mark Manders ,

Thank you for your response.

The user is creating reports based on the SC Task Metric table and requires historical metric data to be available. Since the metric definition was created after some assignment group changes were updated, is there any recommended way to populate or reconstruct that historical data for reporting purposes?

0 Helpfuls