If you have a database without the Audit Architecture installed, first time you will connect to it using ApexSQL Audit application, the Install Architecture dialog will be automatically shown.
Click 
to install the audit architecture for your database.
|
See Also:
For more information about this dialog, click here.
|
The Install Architecture form allows granular control over the installation, removal and analysis of auditing structures. There are several ways you may open this dialog. Either from the Audit Menu choose the Install Auditing command, or in the Auditing Toolbar click 
.
Also, you can click 
from the Auditing Outlook Bar.
Another way of installing of the Architecture is using the following dialog; it can be invoked using one of the following:
Click 
button in the Auditing Outlook Bar.
Click 
button in the Auditing Toolbar.
Choose Manage Audit Architecture command from the Audit Menu.
All you need is to install the scripts hitting the 
button.
For information about the buttons in the dialog above, click here.
Add Architecture Structures to this Database
This will allow the user to indicate the exact scripts to execute at the database level.
|
Object |
Description |
|
DDL |
Executes create statements for basic Audit Tables and Views. |
|
|
|
|
Aggregate Report |
Executes script to create the Procedure that generates the Aggregate Reporting Results. |
|
|
|
|
Audit View |
Executes script to create the main View that aggregates data from Audit Tables. |
|
|
|
|
Standard Report |
Executes script to create the Procedure that generates the Standard Reporting Results. |
|
|
|
|
Purge Audit Log |
Executes script to create the Procedure that manages purging/deletion of Audit Data. |
|
|
|
|
Transactions UnDo |
Executes script to create the SQL objects required to run Transaction UnDo. |
|
|
|
|
Delete Architecture |
Executes script to create the Procedure that deletes all auditing structures including Tables, Views and Procedures. |
|
|
|
|
Analyze Architecture |
Executes script to create the Procedure that will look for missing SQL objects required for proper functioning of Auditing Plan. |
|
|
|
Remove All Architecture Structures
Check this option to remove auditing structures at the database level only.
Analyze this database
This will run the analysis script which will check for the existence / completeness of all of the required auditing scripts.
Copyright © 2008 ApexSQL LLC. All Rights Reserved.
