Audit Log
Expandable’s AUDIT LOG module creates an audit trail of changes made to the database by automatically recording all additions, modifications, or deletions to any selected table and column in Expandable.
The Audit Log module helps assure database integrity and security, and is an important component for maintaining compliance with regulatory agencies requiring audit trails.
The Audit Log module identifies what data was changed, which individual made the change, and when they did it, regardless of the application used to change the data.
Changes are captured in a History Table that logs the exact data that was modified, including before and after images of the data. The history table can be queried, printed, exported, or extracted and archived.
MODULE FEATURES
Audit Log Manager
Define the events you want to capture using the Audit Log Manager that creates and saves SQL Server triggers that track your audit events in the Expandable database.
Information from each captured event is stored in a history table, including before and after images of updated data:
- Operator ID and Name
- Time and date of the audit event
- Program name and table name, with the key field(s) referenced
- Workstation from which the user triggered the audit event
- Change Type (Insert, Update, or Delete)
Audit Log Viewer
With the Audit Report function, the history table can be queried, with the results printed and/or exported to HTML or XML.
Data Parameters
- Table Name
- Machine Name
- Program Name
- Date Last Updated
- Operator ID
- Time Last Updated
- First Name
- Last Name
- Middle Initial
- Change Type
- Insert
- Update
- Delete
Define specific events to capture using the Audit Log Manager