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, 拡張マークアップ言語（Extensible Markup Language） and Excel.