How can I report on all Assignment Group a catalog task has been assigned to?

[Bill_Ymr_61]

I have been asked to create a report showing all Assignment Groups that a task has been assigned to.  For example:

SCTASK0010001 is initially assigned to "Group A", then is assigned to "Group B", then assigned back to "Group A".

I need to show all the groups that this task is assigned to.  I have tried using sc_task_metric table, but it is only showing the current assignment group.  Using my example above, it will have 3 entries in a list report, but the assignment group for all 3 entries is "Group A", it never shows "Group B".

This is in London Patch 6b.

[Allen Andreas]

That really would only be capture in the audit log or sys_audit table I'd imagine...otherwise...it's not possible to get that (unless you've logged this somewhere along the way).

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Bill_Ymr_61]

I found that if I create a metric on the sc_task table for the field Assignment group, then I can use the Value in sc_task_metric to show the historical assignment groups.

[Allen Andreas]

Hmm, neat. Can you share a sample to show the audit that it's been assigned to ...say...3 different groups?

[Bill_Ymr_61]

Here is a task that was started with "Hardware" group, sent to "Software", then to "Dead Presidents", then back to "Hardware".