OmniAudit creates triggers that monitor and record changes to data in any column of any table in Microsoft SQL Server databases. The software generates audit trail data to track the changes selected by the user, ensuring transparency and accuracy in data management.
OmniAudit is capable of capturing changes made through any application, including commercial software, in-house applications, and even native SQL Server tools like Query Analyzer. No matter how the data is changed, OmniAudit captures it all and records what data was changed and who made the change. The software also captures both the before and after values for each changed column and identifies the user, date and time, workstation used, and the application used to make the change.
OmniAudit generates triggers automatically to maintain an audit trail of all inserts, updates, and deletes made to the selected data. It is a completely server-side solution, so there is no need for any modifications to any client software.
Data auditing can provide many benefits to IT organizations. Database administrators can more easily troubleshoot and track down the origin of data corruption. Organizations with internal or regulatory requirements for following the history of data can easily do so, even if their software does not already handle this requirement. Software developers can more easily develop and debug applications by tracing how data gets changed by any particular function of the software. This can help them discover unintentional side-effects faster and easier. Quality assurance functions can validate data altering features more quickly and with greater accuracy.
Using OmniAudit Log Viewer, users can sift through the compiled audit log history quickly and easily since the software allows filtering of audit log data based on date / time, table / column, user, workstation and other variables. Audit log data can be exported to standard file formats, including text, Excel, and XML.
Overall, OmniAudit is an excellent software for tracking changes to data in a SQL Server database. Its automatic triggers and comprehensive audit trail make auditing data changes a breeze. The ability to export audit log data to various file formats also adds value to the software.
Version 1.12: N/A
Version 1.11: N/A
Version 1.8: N/A
Version 1.6.8: N/A
Version 1.6.5: N/A
Version 1.6.3: N/A