How to connect asset to history line table

[singhr14]

Ho can i connect the al_hardware table to the "sys_history_line" table to report the field value changes showing old value and new value.

I have created an database view but i am getting only hardware table field not from the history line table 

[glideFather]

Hi @singhr14,

navigate to the sys_dictionary, locate the alm_hardware table, collection: type, and check the value in audit, it must be true, otherwise you will not get the new / old values in the sys_audit table.

Please refer to that and let me know in case of issue or how it goes