지금 지원 담당자와 채팅
지원 담당자와 채팅

Change Auditor 7.5 - User Guide

Welcome to Change Auditor Help Change Auditor Core Functionality
Change Auditor Core Functionality Change Auditor Overview Agent Deployment Change Auditor Client Overview Overview Page Searches Search Results and Event Details Custom Searches and Search Properties Enable Alert Notifications Administration Tasks Agent Configurations Coordinator Configuration Purging and Archiving your Change Auditor Database Working with Private Alerts and Reports Generate and Schedule Reports SQL Reporting Services Configuration Change Auditor User Interface Authorization Client Authentication Certificate authentication for client coordinator communication Integrating with On Demand Audit Enable/Disable Event Auditing Account Exclusion Registry Auditing Service Auditing Agent Statistics and Logs Coordinator Statistics and Logs Change Auditor Commands Change Auditor Email Tags
Microsoft 365 and Microsoft Entra ID Auditing Change Auditor for Active Directory
Change Auditor for Active Directory Overview Custom Active Directory Searches and Reports Custom Active Directory Object Auditing Custom Active Directory Attribute Auditing Member of Group Auditing Active Directory Federation Services Auditing ADAM (AD LDS) Auditing Active Directory Database Auditing Active Roles Integration Quest GPOADmin Integration Active Directory Protection Event Details Pane About us
Change Auditor for Authentication Services Change Auditor for Defender Change Auditor for EMC Change Auditor for Exchange Change Auditor for Windows File Servers Change Auditor for Active Directory Queries Change Auditor for Logon Activity Change Auditor for NetApp Change Auditor for SharePoint Change Auditor for SQL Server Change Auditor SIEM Integration Guide
Webhooks in Change Auditor Integrating Change Auditor and SIEM Tools Subscription Management
Adding the PowerShell module Viewing available commands and help Connecting to Change Auditor Managing subscriptions Working with event subscriptions in the client Managing a Splunk integration Splunk event subscription wizard Managing an IBM QRadar integration QRadar event subscription wizard Managing a Micro Focus Security ArcSight Logger and Enterprise Security Manager (ESM) integration ArcSight event subscription wizard Managing a Quest IT Security Search integration (Preview) Managing a Syslog integration Syslog event subscription wizard Managing a Microsoft Sentinel integration Microsoft Sentinel event subscription wizard
Webhook technical insights
Change Auditor Threat Detection Deployment Change Auditor Threat Detection Dashboard Change Auditor PowerShell Command Guide Change Auditor Dialogs
Change Auditor dialogs
Quest Change Auditor dialog Add Administrator Add Agents, Domains, Sites dialog Add Container dialog Add Active Directory Container dialog (AD Query) Add Facilities or Event Classes dialog Add Facilities or Event Classes dialog (Add With Events) Add File System Path dialog Add Foreign Forest Credential Add Group Policy Container dialog Add Local Account dialog Add Logons dialog Add Logons dialog (Add With Events) Add Object Classes dialog Add Object Classes dialog (Add With Events) Add Origin dialog Add Origin dialog (Add With Events) Add Registry Key dialog Add Results dialog Add Service dialog Add Service dialog (Add With Events) Add Severities dialog Add Severities dialog (Add With Events) Add SharePoint Path dialog Add SQL Instance dialog Add SQL Data Level Object Add Users, Computers or Groups dialog Add Where dialog Add Who dialog Advanced Deployment Options dialog Agent Assignment dialog Alert Body Configuration dialog Alert Custom Email dialog Auditing and Protection Templates dialog Authorizations: Application Group dialog Authorizations: Operations | Role Definitions | Task Definitions | Application Group Authorizations: Role dialog Authorizations: Task dialog Auto Deploy to New Servers in Forest dialog Browse for Folder dialog Browse SharePoint dialog Comments dialog Configuration Setup dialog Configure cepp.conf Auditing dialog Connection screen Coordinator Configuration tool Coordinator Credentials Required dialog Credentials Required dialog Custom Filter dialog Database Credentials Required dialog Directory object picker Domain Credentials dialog Eligible Change Auditor Agents dialog Event Logging dialog Export/Import dialog Install or Upgrade/Uninstall/Update Foreign Agent Credentials IP Address dialog Log page Logon Credentials dialog (Deployment page) Logon Credentials dialog (EMC Auditing wizard) Manage Connection Profiles dialog New Report Layout dialog Microsoft 365 dialog Rename dialog Save As dialog Select a SQL Instance and Database dialog Select Destination Folder dialog Select Exchange Users dialog Select Registry Key dialog Select SQL Reporting Services Template dialog Shared Mailboxes dialog SharePoint Credentials Required dialog When dialog
About Us

Make changes to the default SQL instance and run a report

Previous Next

Make changes to the default SQL instance and run a report

1
To test SQL Server auditing, make some changes to the default SQL instance.

For example:

▪
add a database user
▪
add a database role
▪
grant or revoke database access to a database user
▪
delete the database user added above
▪
delete the database role added above
2
Select Start | All Programs | Quest | Change Auditor | Change Auditor Client to review the events generated.
3
Open the Searches tab.
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.

A new Search Results tab is added to the client displaying the SQL events that were captured.

6
Double-click an event from the Search Results grid to display the event details for the selected event.

 

SQL Server Auditing

Previous Next

SQL Server Auditing

•
Introduction
•
SQL Auditing page
•
SQL Auditing templates
•
SQL Auditing wizard
•
SQL Server event logging

Introduction

Previous Next

Introduction

The SQL Auditing page on the Administration Tasks tab displays details about each SQL Auditing template created and allows you to add new auditing templates or modify and delete templates. It will initially contain an entry for the Best Practice SQL Auditing Template that ships with Change Auditor.

* 
NOTE: Due to a Microsoft hotfix, Change Auditor agents will not capture SQL-related events until the following action is taken on each SQL Server to be monitored:
1
Select Start | All Programs | Microsoft SQL Server | Configuration Tools | SQL Server Configuration Manager.
2
Select the SQL Server Services node.
3
Right-click SQL Server (MSSQLSERVER) and select Properties.
4
Select the Startup Parameters tab.
5
Enter -T1906 and click Add.
6
Restart the SQL Server (MSSQLSERVER) service.

Repeat steps 3 through 6 for each instance on the server (SQL Server (instance name)).

NOTE: Launching SQL Server Configuration Manager with UAC enabled can cause issues with SQL server properly writing to C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\etwcnf.xml after the trace flag is enabled.
Once you add the - T1906 flag, ensure the etwcnf.xml exists and is not empty.
NOTE: The folder path changes based on the version of SQL.

SQL Auditing page

Previous Next

SQL Auditing page

The SQL Auditing page is displayed when SQL Server is selected from the Auditing task list in the navigation pane of the Administration Tasks tab. From this page you can start the SQL Auditing wizard to specify the SQL instances and the operations to audit. You can also edit existing templates and remove templates that are no longer being used.

 
* 
NOTE: Authorization to use the administration tasks on the Administrations Tasks tab is defined using the Application User Interface page under the Configuration task list. If you are denied access to the tasks on this page, refer to the Change Auditor User Guide for more information on how to gain access.

The SQL Auditing page contains an expandable view of all the SQL Auditing templates that have been defined. Initially, only the Best Practice SQL Auditing template will be listed on this page. To add a new template to this list, click the Add tool bar button. Once added, the following information is provided for each template:

Template

Displays the name assigned to the template when it was created.

Status

Indicates whether the auditing template is enabled or disabled.

Instance

This field is used for filtering data.

Operations

Displays the events selected for auditing on the Events tab of the wizard. Hover your mouse over this cell to view all of the events included in the template.

Filters

Displays the column filters applied to a template.

 

Click the expansion box to the left of the Template name to expand this view and display the following details for each template:

Instance

Displays the name of the SQL instance selected on the first page of the wizard.

Status

Indicates whether auditing for the selected instance is enabled or disabled.

 
* 
NOTE: The cells directly under the main heading rows are used for filtering data. That is, as you enter characters into these cells, the client will redisplay the templates that meet the search criteria (i.e., comparison operator and characters entered). For more details about using the data filtering function provided throughout Change Auditor, see the Change Auditor User Guide.
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택