Skip to main content

Oracle - Audit Trail Setup

Arrow_r 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 oracleaudittrail.sql to create the necessary IndySoft table structures. Run this script in SQL Server Management Studio (SSMS).

(Make sure you are logged in to SSMS with the same credentials you used when you originally installed the IndySoft table structure)

  • 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; please contact IndySoft Support for assistance with setup.

This completes the setup for an IndySoft Audit Trail. |