OmniAudit automatically and transparently tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases.

Simply select the tables and columns you want to audit, and OmniAudit does everything for you. OmniAudit captures changes regardless of the application used to change the data: a commercial software package, an in-house application, or even the native tools provided with SQL Server such as Query Analyzer…OmniAudit catches it all and records what data was changed and who changed it.

OmniAudit is a software that allows you to track changes.

OmniAudit not only captures before and after values for each changed column, but also identifies: the user, date and time, the workstation used, and the application used to make the change.

You decide which tables and columns to audit; OmniAudit automatically generates triggers to maintain an audit trail of all inserts, updates, and deletes made to that data. OmniAudit is a completely server-side solution which requires no modifications to any client software.

Here are some key features of "OmniAudit":

· 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.

· 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.


Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

· Added support for SQL Server 2008 data types: DATE, TIME, DATETIME2, DATETIMEOFFSET, HIERARCHYID, GEOMETRY, and GEOGRAPHY.