How to extract export all the audit (field history) updates made to the all items in cmdb_ci_computer table? (for all Workstations devices)

Dave43
Tera Contributor

‎09-11-2022 05:37 PM

Hi all,

Does anyone have a method to export of all the audit (field history) updates made to the all items in cmdb_ci_computer table? (for all Workstations devices)?

I have tried to access to the list of sys_audit table, but this appears to only be accessible in our development instance and only shows the sys_id for each device.

0 Helpfuls
  • 792 Views
2 REPLIES 2

JP - Kyndryl
Kilo Sage

‎09-12-2022 06:58 AM

Hi Dave,

You may get a list of Computers that have been recently touched by a change with the following report:

find_real_file.png

 

But, if you need the data of those changes in the same report,  you will need to create a database view combining the cmdb_ci_computer and the change_request tables.

Regards.

JP

Regards,
JP
Preview file
137 KB
Preview file
125 KB
0 Helpfuls

Dave43
Tera Contributor
In response to JP - Kyndryl

‎09-12-2022 11:15 PM

Hi JP

Thanks for your reply!

Sorry I have phrased my question poorly. What I need is a list of all the audit (field history) updates made to the CI items in cmdb_ci_computer.

Kind regards, Dave 

0 Helpfuls