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

phr
Tera Contributor

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

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@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

AnkurBawiskar_1-1743601023356.png

 

AnkurBawiskar_0-1743600996437.png

 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@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

AnkurBawiskar_1-1743601023356.png

 

AnkurBawiskar_0-1743600996437.png

 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

 

This helped.

Community Alums
Not applicable

HI @phr ,

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

 

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 !!