How to get a field on an excel from history

[Ap_1]

Requirement: I have to get an export from Computer table with all the records created on last 4years with few fields from the table
As well as the number of time 'Assigned to' field gets changed and the time spend between the first and last assigned to, which we can get from history

Can anyone please suggest me on this.

[Dr Atul G- LNG]

Hi @Ap_1 

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/sys_history_line_list.do%3Fsysparm_query%3DlabelLIKEassig%255Elabel%253DAssigned%2520to%26sysparm_first_row%3D1%26sysparm_view%3D

[Ap_1]

Hi Atul,

I have to work on the both Computer table and history of each computer.

The problem is until I check on the history of each record, record is not showing on sys_history_line, so unable to get the list.

[Dr Atul G- LNG]

Opps,  Then i think , raise HI ticket and get some inputs from SN only.

Did you try will all and group by audit Sys id.