Chat now with support
Chat with Support

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

Client components/features

Previous Next

Client components/features

The following table lists the client components and features that require a valid Change Auditor for SQL Server license.

* 
NOTE: To hide unlicensed Change Auditor features from the Administration Tasks tab (including unavailable audit events throughout the client), select Action | Hide Unlicensed Components. Note that this command is only available when the Administration Tasks tab is the active page.
 

Table 1. Change Auditor for SQL Server client components/features

Client page

Feature

Administration Tasks tab

Agent Configuration page

•
Event Logging - enable/disable SQL Server event logging

Audit Task list:

•
SQL Server
NOTE: See SQL Server Auditing, and SQL Data Level Auditing for information about creating templates.

Events

Facilities:

•
Admin Extended Events
•
Analytic Extended Events
•
Operational Extended Events
•
SQL Broker Event
•
SQL CLR Event
•
SQL Cursors Event
•
SQL Database Event
•
SQL Data Level
•
SQL Deprecation Event
•
SQL Errors and Warnings Event
•
SQL Full Text Event
•
SQL Locks Event
•
SQL Objects Event
•
SQL OLEDB Event
•
SQL Performance Event
•
SQL Progress Report Event
•
SQL Query Notifications Event
•
SQL Scan Event
•
SQL Security Audit Event
•
SQL Server Event
•
SQL Session Event
•
SQL Stored Procedures Event
•
SQL Transactions Event
•
SQL TSQL Event
•
SQL User-Configurable Event

Search Properties

What tab

•
Subsystem | SQL
NOTE: See SQL Searches/Reports for information about using the What tab to create custom SQL search queries.

Searches page

Built-in reports:

•
All reports that include the events in the facilities listed above.

Advanced tab/Search Results page

NOTE: The data gathered will be dependent on whether you are auditing SQL, SQL Data Level Auditing, or SQL Extended Events.

Columns:

•
SQL Application Name
•
SQL Category
•
SQL Changed Columns
•
SQL Client Process ID
•
SQL Database ID
•
SQL Database Name
•
SQL Event Class
•
SQL Event Name
•
SQL Event SubClass
•
SQL Host Name
•
SQL Instance Name
•
SQL IsSystem
•
SQL Linked Server Name
•
SQL Object ID
•
SQL Object ID2
•
SQL Object Name
•
SQL Object Type
•
SQL Owner ID
•
SQL Owner Name
•
SQL Package Name
•
SQL Parent Name
•
SQL Provider Name
•
SQL Row Counts
•
SQL Session Login Name
•
SQL SPID
•
SQL Success
•
SQL Table Name
•
SQL Text Data
•
SQL Transaction ID

Alert Body Configuration dialog - Event Details tab

Variables (email tags):

•
SQL_APPLICATIONNAME
•
SQL_CLIENTPROCESSID
•
SQL_DATABASEID
•
SQL_DATABASENAME
•
SQL_EVENTCLASS
•
SQL_EVENTSUBCLASS
•
SQL_HOSTNAME
•
SQL_INSTANCENAME
•
SQL_ISSYSTEM
•
SQL_LINKEDSERVERNAME
•
SQL_OBJECTID
•
SQL_OBJECTID2
•
SQL_OBJECTNAME
•
SQL_OBJECTTYPE
•
SQL_OWNERID
•
SQL_OWNERNAME
•
SQL_PARENTNAME
•
SQL_PROVIDERNAME
•
SQL_ROWCOUNTS
•
SQL_SESSIONLOGINNAME
•
SQL_SPID
•
SQL_SUCCESS
•
TEXTDATA
NOTE: See the Change Auditor User Guide for a description of these email tags and how to configure alert email notifications.

Getting Started

Previous Next

Getting Started

•
Introduction
•
Apply SQL Server auditing template
•
Make changes to the default SQL instance and run a report

Introduction

Previous Next

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.

 

* 
NOTE: SQL auditing is only available if you have licensed Change Auditor for SQL Server Server. If you do not have a valid license you can use the features, however, associated events are not captured. To verify that it is licensed, right-click the coordinator icon in the system tray and select Licensing.

Auditing SQL Server events

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

1
Assign the pre-defined ‘Best Practice SQL Auditing Template’, that audits key SQL events that occur on the default SQL instance, to an agent configuration.

Or create a new SQL Auditing template which specifies the SQL instances and events to audited and assign this template to an agent configuration.

2
Assign the agent configuration to agents.

Auditing SQL Data Level events

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:.

Auditing SQL Extended Events

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

Previous Next

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.

To assign the Best Practices SQL Auditing template to an agent configuration:
1
Open the Administration Tasks tab.
2
Click Configuration.
3
Select Agent (in the Configuration task list) to open the Agent Configuration page.
4
Click Configurations.

This displays the Configuration Setup dialog, which contains a list of configuration definitions available.

* 
NOTE: The Default Configuration is the only configuration listed if you have not defined any other agent configurations. For more information about defining agent configurations, see the Change Auditor User Guide.
5
On the Configuration Setup dialog, use one of the following methods to assign this template to an agent configuration:
▪
Select the Best Practices SQL Auditing template and drag it onto a configuration in the Configuration list.
▪
Select a configuration from the Configuration list and drag it onto the Best Practices SQL Auditing template.
▪
Select a configuration, then select the Best Practices SQL Auditing template, right-click and select Assign.
▪
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.
 
* 
NOTE: If you do not refresh the agent’s configuration, the agent will automatically check for a new agent configuration based on the polling interval setting (located on the System Settings tab of the Configuration Setup dialog). The default is every 15 minutes.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating