Change Auditor for SQL Server 7.0.2 - User Guide

Getting Started

Introduction

To capture SQL and SQL Data Level events, ensure that your system meets the minimum requirements. For details, see Deployment requirements.

 

To capture SQL events in Change Auditor, you must define the SQL instances to be audited and the events to be captured:

To capture SQL Data Level events, you must assign SQL Data Level auditing templates to an agent when you create the template. Each audited database requires one template assigned to a single agent.

For information on creating templates, see To create a new SQL Data Level auditing template:.

Apply SQL Server auditing template

Change Auditor for SQL includes a configured auditing template, named Best Practice SQL Auditing Template that you can apply to an agent configuration to audit the default SQL instance to capture key SQL events or used as a starting point for creating a new template.

The following steps walk you through the process of applying the pre-defined SQL Auditing template to get you started.

2
Click Configuration.
3
Select Agent (in the Configuration task list) to open the Agent Configuration page.
4
Click Configurations.
6
Click OK to close the Configuration Setup dialog and return to the Agent Configuration page.
7
Select an agent from the list, click Assign and then select the agent configuration to assign to the agent from the displayed dialog. Click OK to save your selection and close the Agent Assignment dialog.
8
On the Agents Configuration page, select the agents assigned to use the modified agent configuration (Auditing appears in the SQL column) and click Refresh Configuration to ensure the agents are using the latest configuration.

Make changes to the default SQL instance and run a report

2
Select Start | All Programs | Quest | Change Auditor | Change Auditor Client to review the events generated.
4
Expand the Shared | Built-in | Recommended Best Practice | SQL Server folder in the left pane.
5
Locate and double-click All SQL Events in the right pane.

 

相关文档