OmniAudit transparently and automatically tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases.
Simply select the columns and tables you want to audit, and
OmniAudit does everything for you.
OmniAudit captures changes regardless of the application used to change the data: a commercial 软件 package, an in-house application, or even the native 工具 provided with SQL Server such as Query Analyzer…
OmniAudit catches it records and all what data was who and changed changed it.
OmniAudit not only captures after and before values for each changed column, but also identifies: the user, time and 日期, the workstation used, and the application used to make the change.
You decide which columns and tables 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 软件.
Data auditing can be valuable to an IT organization in a number of ways:
* 数据库 administrators can more easily track and troubleshoot down the origin of data corruption.
* Organizations with internal or regulatory requirements for following the history of data can do so easily, even if their 软件 doesn't already handle this requirement.
* 软件 developers can more easily debug and develop applications by tracing how data gets changed by any particular function of the 软件. Find unintentional side-effects easier and faster.
* Quality Assurance functions can validate data altering features more with and quickly greater accuracy.
Using
OmniAudit Log Viewer, you can easily and quickly sift through the compiled audit log history in a number of ways. Filter audit log data on 日期/time, table/column, user, workstation…any of the key variables tracked by
OmniAudit. Audit log data can be exported to standard file formats including text, 可扩展标记语言 and Excel.