OmniAudit 1.14 Build 495

OmniAudit installs complete data change auditing in your SQL Server database in just a few minutes. Audit every field in every table, or pick and choose the tables and fields you want to audit. Either way OmniAudit does the hard work of creating the necessary audit trail objects in your database with a click of a button.

Audit trails also are tremendously useful for internal quality assurance. Any organization which develops database software–whether strictly for in-house use or as commerical products–can greatly streamline debugging and testing with an audit trail showing the net effect of how a software function changes the database. Nothing beats an audit trail for highlighting unintended side-effects either.

Audit trails are an important–sometimes required–part of database administration. Many systems which maintain critical information benefit from audit trails. Often government regulations such as Sarbanes-Oxley, FDA Part 11, PCI-CISP, and HIPAA require audit trails on electronic records.

How Does OmniAudit Help You Build SQL Server Audit Trails?

-No SQL programming required. OmniAudit automatically builds all the necessary database objects.
-Auditing occurs regardless of application. Whether a commerical software package, an in-house application, even Microsoft tools such as SQL Management Studio, Query Analyzer, or Microsoft Access. Existing software is not required to be changed for auditing.
-You choose what to audit Audit every field in your database, just a few fields in a single table, or anything in between.
-Easy to use. Regardless of your database skill level, if you can connect to the database server (and have the appropriate permissions), you can add a complete, fully-functional audit trail solution to any SQL Server database.
-Fully accessible audit data. Collected audit data is stored in conventional SQL Server tables, which can be referenced by any SQL Server reporting tool (such as Reporting Services, Crystal Reports, etc.)
-Flexible. Change your auditing selections at any time and with one click of a button, OmniAudit automatically updates all affected tables without impacting your existing audit trail data.

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.

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.

Requirements:	No special requirements
Release Date:	January 12, 2013
Platforms:	WinXP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64
Keyword:	Audit,  Mysql,  Mysql Audit,  Sql,  Sql Audit,  Table Audit
Users rating:	0/10