Audit Tools (Beta)
AuditDatabase Trigger Generator Wizard (FREE WEB version)
The AuditDatabase Trigger Generator Wizard is a web application that automates the generation of audit triggers for the target DBMS. This Wizard guides through a very simple 3
steps procedure:
- The user gives the table creation script
- The tool parses the script and shows the table structure. Here the user chooses the operations to be audited (insert, update or delete) and the columns to be audited or just registered.
- The tool generates and displays a database script with the audit triggers.
Try the Beta of the "AuditDatabase Trigger Generator Wizard" here
Prior to create the triggers generated by the tool, the audit tables must exists in the database.
You can download the SQL Server audit table's creation script in the Download Area
AuditDatabase Query (FREE WEB version)
Once the generated triggers have been installed, audit information (user, application, time, old/new row values, etc.) over data changes is saved into audit tables. Then these tables can be queried to view specific audit information.
To simplify the tedious task of writing complex SQL querys to retreive information from this tables, we have developed the "AuditDatabase Query" web application: a tool that generates specific SELECT sentences based on user's criteria.
Try the Beta of the "AuditDatabase Query" here
AuditDatabase Query (FREE Desktop version)
The AuditDatabase.com Query Generator’s output is a SQL script that returns the information you selected in the wizard.
Though this is certainly useful, because you do not need to know the audit tables structure to retrieve information, we thought it would also be nice to be able to run the generated SQL sentence without even seeing the query.
That is why we developed the desktop version of the AuditDatabase.com Query, which provides the same functionality, but also connects to the database and executes the generated query.
At the moment, it only connects to SQL Server databases, but we intend to provide support for other DBMS as soon as they are available for the Trigger Generator Wizard.
You can download the installer in the Download Area
|