Chat now with support
Chat with Support

Change Auditor for SQL Server 7.3 - User Guide

Getting Started

Introduction

To capture event data for SQL, SQL Data Level, and SQL Extended 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:.

To capture SQL Extended Events data, you must create an SQL Extended Events auditing template. A remote agent may be specified, otherwise an agent must be installed on the SQL Server host to be audited.

For information on creating templates, see the Change Auditor PowerShell Command Guide.

 

Apply SQL Server auditing template

Change Auditor for SQL Server 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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating