How to retrieve a record field history in servicenow for few records in alm_hardwrae table

[phr]

Hi All,

We have a bulk of asset 80+ records , we are trying to retrieve the history of specific fields(Lifecycle status, state and substate) for  each of the bulk records.

We have Audit history for the records.

Is there any way to download these for all 80+ asset records?

Thank you

[Ankur Bawiskar · Accepted solution]

@phr 

Steps

1) go to sys_audit.LIST
2) get the sysIds of those 80 records and use this in filter condition

3) then export using the Right Click -> List Header -> Export -> Excel

If my response helped please mark it correct and close the thread so that it benefits future readers.

[phr]

Hi @Ankur Bawiskar ,

This helped.

[Community Alums]

HI @phr ,

I don't think that's possible , unfortunately.

[phr]

Hi @Community Alums ,

Tried to Query the record uusing sys_audit table filtering with Sys id, able to get the field valued of this .

Thanks for answering !!