MSSQL - Audit Trail Setup

Important: Using database-based audit trails is NOT necessary to log equipment-level changes from within the IndySoft software - this is a client feature. But if you still prefer to use database-based triggers (possibly for logging changes from outside IndySoft), note the instructions below.

If you wish for IndySoft to log equipment modifications in an audit trail, follow these instructions. (Be sure to have logged into IndySoft successfully and that all default data has been loaded before creating the audit trail triggers)
| 1) | To install the audit trail, you must use a table creation script called mssqlaudittrail.sql to create the necessary IndySoft table structures. Open this script in SQL Server Management Studio (SSMS). After loading it, ensure you are pointed toward the IndySoft database and run the script.

• Note: This script is not included in the default installation; don't hesitate to contact IndySoft Support for assistance with setup.

2) | All the necessary audit trail database structures should now be loaded.3) | Last, you will need to load the IndySoft Audit Trail event type. To do this, log in to IndySoft as a system administrator and open Workflow Configuration. Once the Work Flow Configuration Module has loaded, choose from the menu Options --> Import Event Configuration. Choose the file called AuditTrail.IXP. Close the module once the Audit Trail event type has been imported.

• Note: This event is not included in the default installation; don't hesitate to contact IndySoft Support for assistance with setup.

This completes the setup for an IndySoft Audit Trail. |