 features
Point-And-Click Setup; Be Auditing in Minutes
Check off the tables and fields you want to audit, select a few options, click a button and OmniAudit creates the audit trail tables and triggers for you.
Analyze Audit Trail Data Without Knowing SQL
The included OmniAudit Log Viewer tool lets you easily zero in on audit data by table, field, user, date, workstation, or application. Save the results to an Excel worksheet, HTML or XML document, or plain text.
Accessible Audit Trail Data
Audit trail data is stored in SQL Server tables and can be accessed using normal SQL Server query tools (provided you have given the user security access).
Nonintrusive
Auditing is performed on the server and requires no modifications to client software.
Capture Reference Data, Not Just Changed Data
When an audited value changes, you can have additional values from that row added to the audit trail...whether they changed or not. For example, you can have EmployeeNum written in the audit trail whenever ANY data in the Employee row changes. [more info]
Automatically Purge Audit Trail Data
Depending on your auditing requirements, you may only be interested in retaining recent audit history. You can configure OmniAudit to automatically purge audit trail history after a given number of days, weeks, or months have passed.
(click image for larger version)
|