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.

[Prateek kumar]

I dont think Metric will work for the historic data. It will only work for the records that are created after the metric creation.

[Bill_Ymr_61]

Correct, it will be from that point forward.  But since the values were not stored anywhere else, that will have to do.

[Prateek kumar]

The closest you can do is on History line

https://YourInstanceName.service-now.com/sys_history_line_list.do?sysparm_query=set.tableSTARTSWITHs...