Where is audit history for alm_hardware table stored? sys_audit? sys_history_line?

[Sanya2]

When I click on top left hamburger and select history->calendar, I can see some audit information. But I am not able to find the same in sys_audit / sys_history_line tables. So where exactly is this information stored?

[Hitoshi Ozawa]

Just checked and it's in Sys Audits.

hardware record history

Sys Audit

BTW, I found the following thread useful in adding audits.

https://community.servicenow.com/community?id=community_question&sys_id=26eb8fe1db9cdbc01dcaf3231f96...

[Sanya2]

Thanks hozawa for reply. As I said, I am not finding the details in sys_audit and sys_history_line. But I do see the information in each individual record by going to audit history -> calendar view. That's why I was wondering where else it could be stored. 

In our environment we find some assets have their assigned date value blanked out. And we need to run chargeback report based on the assigned date. So, looking for ways to extract this information by approximating assigned_to audit time as assigned date. However, I am not able to find this information in sys_audit / sys_history_line tables. So, not finding a way to query those values. 

Thx,
Sanya

[Hitoshi Ozawa]

Have you tried adding audits to fields on alm_hardware table? At the end of my reply, I added a link to a thread to add audit on serial_number.

[Sanya2]

I am looking for past information. If I enable audit now, it wouldn't help retrieve past information. Right? So, that link is of no use to me. 

Thanks anyways,

Sanya