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]

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.

[JP - Kyndryl]

Hi Dave,

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

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

[Dave43]

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