want old value for assigned to field in computer table using sys_audit

divyadivya
Giga Contributor

Can someone help me ? Regarding below issue

 

What will be the where clause in order  join the computer table (cmdb_ci_computer)and audit table (sys_audit) ? I need to get the old value

 

Before giving audit table in the database view  the output of the report is like the one I attached and after giving audit table in the database view am not getting any data in reports

 

Can some one help me regarding this issue , I need old value and new value for the computer table ?

 

 

divyadivya_1-1725445088345.png

 

divyadivya_0-1725445071224.png

 

below two are the pictures after adding audit table

divyadivya_2-1725445114947.pngdivyadivya_3-1725445124865.png

 

0 REPLIES 0