How to connect asset to history line table

singhr14
Tera Contributor

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 

 

singhr14_1-1751537519702.png

 

1 REPLY 1

GlideFather
Tera Patron

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

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */