# Action logging and audit **URL:** \ **Category:** Ignition\ **Created:** [October 14, 2011, 4:34pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437 "2011-10-14T16:34:35Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [October 14, 2011, 4:34pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/1 "2011-10-14T16:34:35Z")
I’m sure that this is a hot topic seeing that 21CFR was in the whitepaper poll. Is there any documentation on implementing security controls and logging for setpoints and alarms? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [October 17, 2011, 6:36pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/2 "2011-10-17T18:36:36Z")
Something beyond the built-in auditing feature? ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [October 18, 2011, 5:28pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/3 "2011-10-18T17:28:44Z")
Yup, for example, one of the things I’m looking to do is setup notifications to be mailed out if some setpoints are changed. Is this something best handled within Ignition, or adding some triggers to the audit table in SQL? ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [October 18, 2011, 6:09pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/4 "2011-10-18T18:09:06Z")
That is covered under [alerting](http://inductiveautomation.com/support/usermanuals/ignition/alerting_overview.htm). You may want to use this in addition to auditing. Just set up an alert on the desired setpoints. You can set up both an email alert as well as a log entry in the history. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [October 18, 2011, 6:40pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/5 "2011-10-18T18:40:51Z")
how about getting sql updates to show up here is an example of what I see in the audit log for someone updating some device properties that are stored in the db. ```auto UPDATE devices SET devicename = ?, displayname = ?, defaultmeterdesignation = ?, latitude = ?, longitude = ?, meterid = ?, towid = ?, poll = ?, fieldid = ?, unitid = ?, api = ?, cost_center = ?, ftg = ? WHERE id = ? ``` I can see that they did something, but not what changes were made. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [October 19, 2011, 11:44pm UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/6 "2011-10-19T23:44:02Z")
I’ve made a feature ticket to have better auditing for prepared statements (using prepared statements is what is causing the query to have “?” instead of the actual values. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [October 26, 2011, 12:09am UTC](https://forum.inductiveautomation.com/t/action-logging-and-audit/3437/7 "2011-10-26T00:09:17Z")
This has been done for Ignition 7.3.2