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.
For information on creating templates, see To create a new SQL Data Level auditing template:.
For information on creating templates, see the Change Auditor PowerShell Command Guide.
2 |
Click Configuration. |
3 |
Select Agent (in the Configuration task list) to open the Agent Configuration page. |
4 |
Click Configurations. |
• |
• |
Select a configuration, then select the Best Practices SQL Auditing template, click in the corresponding Assigned cell and click Yes. |
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. |
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center