Chat now with support
Chat with Support

Change Auditor - For Advanced Users 7.0.1 - Technical Insight Guide

Change Auditor Services Change Auditor licensing processes Change Auditor network communications Coordinator internal tasks Coordinator Registry Settings Change Auditor built-in fault tolerance Change Auditor protection Database Considerations Account exclusions best practices

How scheduling and location works with denied access

You can select to have the protection to always run or have it run only during specific times and control when the protection is enabled based on the location.

This section explains how the scheduling and location options affect the user and group accounts that have been denied access to protected objects.

Scheduling option

If you have denied specific users or groups the ability to change the protected objects and you have enabled a protection schedule, those users or groups are denied access only during this time. Anytime outside of when the schedule is set to enabled, these denied accounts WILL be able to access the protected object.

When the schedule is disabled, all options are disabled with it, including any denied access to the specified users.

The scheduling options override all other protection settings.

Location option

If you have denied specific users or groups access to protected objects, but you have specified locations that can access the protected object, the denied user or group can access the protected objects from these locations.

The location options override all other protection settings.

 

 

Database Considerations

•
How to move the Change Auditor database and coordinator to another server
•
How to estimate the required SQL server disk space
•
How SQL Server Autogrow affects Change Auditor
•
How to query an archive database

How to move the Change Auditor database and coordinator to another server

* 
NOTE: These instructions are for Change Auditor 5.6 (or higher).
To move the database from SQL 2005 to a SQL 2008/2012 server:
1
Determine the current database path
•
Open SQL Server Management Studio.
•
Go to the properties of the Change Auditor database and determine where the database files are located. You need to know this path to copy the files later.
2
Disable the coordinator
•
Go to the Change Auditor server.
•
Right-click the coordinator system tray icon and select Disable Coordinator.
3
Detach the database
•
Open SQL Server Management Studio.
•
Locate and right-click the Change Auditor database.
•
Select Tasks | Detach.
•
On the General page of the Detach Database screen, selecKeep and click OK.
4
Copy the old database to the new SQL server
Copy the files (.mdf and .ldf) to your new SQL Server (most likely to the same location as the other database’s on the new server).
5
Attach the old database
•
Open or connect to the new SQL Server.
•
Using SQL Server Management Studio, right-click Databases and select Attach.
•
On the General page of the Attach Databases screen, click Add and select the database you copied over.
•
On the warning dialog, click OK.
6
Point your old Change Auditor coordinator/server to your new SQL Server
* 
IMPORTANT: Only perform this step on the old Change Auditor server if you do not plan to replace the old coordinator. If you plan to install a new Change Auditor server to replace your old Change Auditor server, proceed to the next step and do not do anything to your old Change Auditor server yet.
•
Go to the Change Auditor server.
•
Right-click the coordinator system tray icon and select Coordinator Configuration.
•
On the Security page of the Coordinator Configuration Tool, enter the following information:
•
SQL Server and instance of the new SQL Server
•
Database name of the original database
•
Credentials to access the new SQL Server
This completes the database move.
7
Start up the coordinator service.
•
Go to the Change Auditor server.
•
Right-click the coordinator system tray icon and select Enable Coordinator.
The agents should reconnect. Run the client to ensure that everything is back to normal.
To move the Change Auditor coordinator to another server after moving the SQL database:

If you plan to replace the old Change Auditor coordinator/server, install a newer version of Change Auditor and it connects your existing agents to the new Change Auditor server without a problem. Make sure that you join the existing installation.

1
Install the new version of the coordinator.
•
On the Customer Installation Information page, enter the same installation name as the original.
•
On the SQL Server Information page, select the (new) SQL server and (original) database name you attached earlier.
After you have completed the installation, start up the coordinator service. Agent communication is re-established.
2
Use Add or Remove Programs to uninstall the disabled coordinator from your old Change Auditor server.
This should remove the old Service Connection Point (SCP) and create a new SCP. If the new SCP is not present when you start the client (Profile field is blank on the Change Auditor Connection screen), restart the coordinator server on the new Change Auditor server.
Restarting the coordinator service on the new Change Auditor server recreates the SCP and you should be able to connect to the default profile when you start the client.
3
Open the Agent Statistics page to review the agents’ status. Agents automatically reconnect. Agent activity was not interrupted.
4
You can now upgrade your agents using the Deployment page.
To move the Change Auditor coordinator/server to another Windows Server:

Use the following steps if your SQL database is already on another server and you do not plan to move it. This scenario installs a second Change Auditor coordinator and then disables and uninstalls the first one. All agents transition over to the new Change Auditor server.

1
Install a second coordinator.
•
On the Product Licensing page, use the same license files used for the first coordinator.
•
On the Customer Installation Information page, be sure to enter the same installation name as the first coordinator.
•
On the SQL Server Information page, select the SQL Server and database name used in the first coordinator installation.
2
You now have your new Change Auditor coordinator attached to the database. Start up the coordinator service.
•
Go to the new Change Auditor server.
•
Right-click the coordinator system tray icon and select Enable Coordinator.
3
Disable the first coordinator
•
Go to the first Change Auditorserver.
•
Right-click the coordinator system tray icon and select Disable Coordinator.
4
To ensure the agents connect to the second coordinator, pen the Agent Statistics page.
5
Use Add or Remove Programs to uninstall the disabled coordinator from your first Change Auditor server.

How to estimate the required SQL server disk space

The Change Auditor 6.x database can grow indefinitely without a decrease in performance. This makes it unnecessary to create periodic archives.

Adequate disk space should be reserved to accommodate the volume of events dictated by your compliance and retention policies. Testing shows that events take approximately 8,000 bytes per event.

•
Example 1: 1,000 events = 8 MB estimated disk size required
•
Example 2: 30,000 events = 240 MB estimated disk size required

In addition to the volume of events, the type of events and the volume of alerting also affect disk consumption. To predict disk consumption for your intended retention period, configure Change Auditor as you intend to use it in your environment for a period sufficient to project long-term space requirements.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating