Hello everyone, I need help to know how i can update the Ignition Audit Trail database for the Changes pushed directly from an Ignition Perspective client to a SQL database table.
I am on Ignition version 8.1.41 and working on Ignition Perspectie module.
How are you updating the SQL table from the perspective client, via a script? If so, use system.util.audit, which allows you to insert a record into the audit db manually. Its up to you to provide the data you want to track.
Thanks for the prompt response ryan. I am looking for some default option to get a row whenever any changes occurs from client to database. I am getting a resource modified row inserted whenever any changes happening from designer but the same behaviour is missing from client side. I am implementing this for one of my pharma client and i am afraid if the validation person doesn’t accept this manual insertion of row on every update. I got that there is a way with the script but is there any default option available which doesn’t involve scripting, just system generated. Thanks for hearing me out.
Double check that auditing is enabled for the project:
Based on the manual, perspective seems to have a smaller amount of automatically logged actions, though that may just be a documentation issue.
system.util.audit exists to cover areas that may need to be logged to an audit trail/db that Ignition doesn't log automatically. I would expect the inspector to accept it as long as you can prove that the audit record is always inserted when the action occurs.
Got that, many thanks for the response.
1 Like