Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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