How to get Previous value of record assignment

[Supriya25]

Hi,

Please help me on below issue

SCTASK was Assignments changing as per situation, sometimes to groups, sometimes to Users.

Scenario 1 : Initially it was assigned to a user "David" , From David to it was assigned to Group : "Software", finally From Software group to it was assigned to "Hardware" group ( currently it was assigned to Hardware group).

Now I want to know that , to whom it was assigned Previously either group/user and it's value. (expected result: Software group ).

David-->Software group--->Hardware group .

Scenario 2: Initially  it was assigned to :Hardware group---> David user---> software group ( currently it was assigned to Software group)..
Now I want to know that , to whom it was assigned Previously either group/user and it's value. (expected result: David User).

Kindly let me know how to get this solved.

[Dr Atul G- LNG]

Hi @Supriya25 

Give a try to metric table on sctask .

[Supriya25]

Hi,

I tried to get data from sys_history_line.LIST

I tried below code

var gr = new GlideRecord('sys_history_line');
gr.addEncodedQuery('set=89c1652047937110e2192c44846d4368^field=assignment_group^ORfield=assigned_to');
gr.orderByDesc('sys_created_on');
gr.setLimit(1);
gr.query();
if(gr.next()){
gs.info("Field :"+gr.field);
}

getting Result like below :

here I'm getting current field value, bit how about we can get one step back

[Dr Atul G- LNG]

Going in Audit is complicated so SN provide the metrics.

It will make your life easy and No code required. 

[Supriya25]

I understand , here we are looking at Metric table and telling that previously it was assigned to User Or group, clearly system showing , Perfect !. 

BUT  my concerns is 
how can we get that previous assignment value in-form of RESULT value from code  with Querying Metric table.

Please suggest !