Chat now with support
Chat with Support

Change Auditor 7.1.1 - User Guide

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 Disable 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

Change Auditor Coordinator Status dialog

The Change Auditor Coordinator Status dialog helps you determine if the coordinator is running and what version is installed on the server. The other status information on the dialog is broken down into the following sections:

•
Coordinator Information - displays the status, version number, SCP port and installation name for the coordinator
•
Database Information - displays the coordinator database server, name and size
•
Agent Connections to this Coordinator - displays the total number of agents that are connected to the coordinator
•
Events and Alerts on this Coordinator - displays status information regarding events, alerts, and search activities for this particular coordinator
•
Agent Ports on this Coordinator - displays all ports used for communication.

The Change Auditor Coordinator Status dialog contains the following information:

 
Table 3. Change Auditor Coordinator Status dialog: Status information
Field
Description
Coordinator Information

Coordinator Status

Displays the current status of the coordinator:

•
Running
•
Initializing
•
Stopped
•
Failed

This value will normally be ‘Running’. If the credentials supplied for the database access during the coordinator installation are incorrect or have expired, this field will display ‘Not Running’ indicating that the coordinator did not successfully start. If this happens, use the Database Configuration Utility to change the permissions trying to access the database.

Installation Name

Displays the installation name assigned to the coordinator during installation.

Version

Displays the current version of the coordinator installed on the server.

Database Information

SQL Server

Displays the name of the server where the coordinator resides.

Database Catalog

Displays the name assigned to the coordinator database during the coordinator installation.

Database Size

Displays the size of the coordinator database, in megabytes.

Database Free Space

Displays the available free space in the coordinator database.

Agent Connections to This Coordinator

Agents Connected (Total)

Displays the total number of agents connected to this coordinator.

Events and Alerts on This Coordinator

Total Events

Displays the number of events this coordinator has received since it was last started.

Events in Receive Buffer

Displays the number of events that have not yet been processed by this coordinator and forwarded to the client.

Average Events Per Second

Displays the average number of events processed by this coordinator per second.

Agent Ports on This Coordinator

Client SCP Port

Displays the port number assigned to the coordinator Service Connection Point (SCP).

Public SDK Port

Displays the port number assigned for external applications to access the coordinator.

Agent Port

Displays the port number assigned to the agents to communicate with the coordinator.

Coordinator Configuration tool

You can use the Coordinator Configuration tool to modify the credentials used by the coordinator when accessing the database. Right-clicking the coordinator system tray icon and selecting Coordinator Configuration, displays the Coordinator Configuration tool. From here, you can:

•
modify the credentials to be used to access the Change Auditor database
•
change the database instance
•
specify static SCP listening ports to be used to communicate with the coordinator
•
specify where the Active Directory and GPO protection templates are to be stored: SQL (default) or Active Directory

This tool consists of the following tabbed pages:

•
Security page
•
Ports page
•
Protection page
Security page

From the Security page, you can change the database instance and service accounts used to access the database.

* 
NOTE: If User Account Control (UAC) is enabled, a confirmation dialog appears where you can authorize the Coordinator Configuration tool to use the required elevated rights.

Use the fields/options to enter the credentials to be used to access the designated SQL Server/instance as described below:

SQL server and instance
Enter the name or IP address of the SQL instance to be used. (i.e., <Server Name>\<Instance Name>). You can also click Browse to locate and select the SQL server and instance.
* 
NOTE: If your database is in a SQL AlwayOn Availability Group, specify the name of the availability group listener for the SQL Server name.
Name of database Catalog
This displays the name assigned to the Change Auditor database.
Connect using
Specify whether Windows authentication, Azure Active Directory authentication or SQL server authentication will be used when communicating with the SQL database instance. (The authentication method is set up when SQL is installed.)
* 
NOTE: Azure Active Directory authentication is only supported for SQL Managed Instances.
Depending on the authentication option selected, enter the appropriate user credentials.
•
Windows Authentication - this is selected by default and will use Windows authentication to access the database.
* 
NOTE: If you are using a group Managed Service Account, ensure that the account ends with '$' and the password is left blank.
•
SQL Server Authentication - select this to use SQL Server authentication to access the database.
•
Azure Active Directory Authentication - select this to use Azure Active Directory authentication to access the database located on an Azure SQL Managed Instance.
Azure SQL Managed Instance:
•
For a private endpoint, specify the managed instance host name in the following format: MyHostName.dns_zone.database.windows.net
For private endpoint with default port, port specification is not explicitly required. For example: MyHostName.b1b2a3d4e5f7.database.windows.net
or
MyHostName.b1b2a3d4e5f7.database.windows.net,1433
•
For a public endpoint, specify the managed instance host name and port in the following format: MyHostName.public.dns_zone.database.windows.net,3342
For public endpoint, port specification is required. For example: MyHostName.public.b1b2a3d4e5f7.database.windows.net,3342
* 
NOTE:  
•
Azure SQL Managed Instance (PaaS) is supported using SQL authentication or Azure Active Directory Authentication with an encrypted connection. Windows authentication is not supported.
•
For an Azure SQL Managed Instance (PaaS), SQL authentication or Azure Active Directory authentication with an encrypted connection must be used.
•
Single User Mode is not supported during installation or upgrade when using Azure SQL Managed Instance. Ensure that all SQL connections to the Change Auditor database are closed before and during the upgrade.
•
Azure SQL Managed Instance (HA) high availability is supported using the read-write listener endpoint.
•
Performance may vary depending on network configuration, topology, and Azure SQL Managed Instance configuration.
Login ID
Enter the user name for the account to be used to access the SQL server instance.
Password
Enter the password associated with the user account entered above.
Domain
Enter the domain name for the Windows account used to access the designated SQL server instance. (Only valid for Windows Authentication.)
Encrypt connection
Select to use SSL encryption for all data sent between the coordinator and the SQL server. To use this option, the SQL server must have a certificate installed and the format of the SQL server name specified must be an exact match to the name format used in the certificate (for example FQDN or NetBios).
Ports page

By default, Change Auditor dynamically assigns communication ports for each installed coordinator. However, using the Ports page of the Coordinator Configuration dialog, you can specify static SCP listening ports to be used to communicate with the coordinator.

* 
NOTE: If you upgraded from a 5.x installation where static ports were defined, these static ports are retained as part of the upgrade process. However, the Agent Port setting, which is used by 6.0 agents, is set to use a dynamic port. Check with your system administrator to determine whether this new connection should also be using a static port.

Enter the ports to use to communicate with the coordinator:

* 
NOTE: A zero (0) indicates that a dynamic port is being used. If you have set a static port and wish to use a dynamic port, change the port number back to 0.
Client Port
Enter the static port number to be used by the client to communicate with the coordinator.
Public SDK Port
Enter the static port number to be used by external applications to access the coordinator.
Agent Port
Enter the static port number to be used for communication between a agent and a coordinator.
Protection page

By default, Change Auditor stores the Active Directory and GPO protection templates in SQL. However, you can use the Protection page of the Coordinator Configuration dialog to store the Active Directory and GPO protection templates in Active Directory instead of SQL.

* 
NOTE: When you select to store your Active Directory and Group Policy protection templates in Active Directory, you can use the Security feature on the Active Directory Protection page or Group Policy Protection page to provide an additional layer of security. The additional setting is intended when you require tighter security ACLs on your Active Directory and GPO objects and templates (for example, the Change Auditor SQL database may not be fully secured by ChangeAuditor Administrators). For more information about setting this additional security on protected objects, see the Change Auditor for Active Directory User Guide.

Specify the appropriate option for storing Active Directory/GPO protection and ADAM (AD LDS) protection:

Store Active Directory/GPO protection in:
Select one of the following options:
•
SQL (default)
•
AD
Store ADAM (AD LDS) protection in:
Select one of the following options:
•
SQL (default)
•
AD
 

View coordinator status and statistics

To view coordinator status and statistics (Overview page):
1
Open the Overview page and if the Coordinator Status overview pane is not being displayed, click the arrow button on an overview pane and select one of the following commands:
•
Coordinator Status | Enterprise View
•
Coordinator Status | <domain>
This displays a pie chart depicting the current status of all the coordinators installed in either the entire enterprise or in a selected domain.
2
By default, this pane only includes installed coordinators in the pie chart. You can however, select the Show Uninstalled Coordinators check box to include uninstalled coordinators in the pie chart.
3
Double-clicking the pie chart displays the Coordinator Statistics page.
To view coordinator status/statistics (Coordinator Statistics page):
1
Open the Coordinator Statistics page.
2
Click Show Uninstalled Coordinators to include coordinators set as ‘uninstalled’. Click Hide Uninstalled Coordinators to exclude these coordinators from the display.
The values in the different event columns are links, which when selected will open up a new Search Results tab to display the related details for these events.
To view coordinator status/statistics on current coordinator only (coordinator system tray icon):
1
From the server where the coordinator is installed, right-click the coordinator system tray icon and select Coordinator Status.
2
This displays the Change Auditor Coordinator Status dialog with the status and statistics regarding the coordinator, database, agent connections and events and alerts.
3
Click OK to close this dialog.

Manage Change Auditor coordinators

To stop a coordinator:
* 
NOTE: You can use Action | Agent Notifications to hide (or display) the desktop notifications that are displayed when these processes are performed.
1
From the server where the coordinator is installed, right-click the coordinator system tray icon and select Disable Coordinator.
2
On the confirmation dialog, click Yes to stop the coordinator service.
A message displays explaining that the coordinator is being stopped.
In addition, a desktop notification displays in the lower right-hand corner of your screen explaining that the selected coordinator is being disabled.
Once disabled, the coordinator system tray icon contains a red light indicating that the coordinator is disabled.
3
If you so choose, click Set Coordinator Uninstalled to flag the selected coordinator as ‘Uninstalled’.
4
Click Show Uninstalled Coordinators to include uninstalled coordinators in the Coordinator Statistics list. Click Hide Uninstalled Coordinators to exclude uninstalled coordinators from the display.
To start a coordinator:
•
From the server where the coordinator is installed, right-click the coordinator system tray icon and select Enable Coordinator.
A message displays explaining that the coordinator is being started.
In addition, a desktop notification is displayed in the lower right-hand corner of your screen explaining that the selected coordinator is being started.
Once restarted, the coordinator system tray icon no longer contains a red or yellow button indicating that the coordinator is now active.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating