Chapter 15 Managing System Operations and Configuration in the Monitoring & Report Viewer

Configuring Remote Database Settings

Step 1 From the Monitoring & Report Viewer, choose Monitoring Configuration > System Configuration > Remote Database Settings.

The Remote Database Settings Page appears as described in Table 15-12.

Table 15-12

Remote Database Settings Page

 

 

 

Option

 

Description

 

 

Publish to Remote Database

Check the check box for ACS to export data to the remote database periodically. By

 

 

default, ACS exports data to the remote database every 4 hours.

 

 

 

Server

 

Enter the DNS name or the IP address of the remote database.

 

 

 

Port

 

Enter the port number of the remote database.

 

 

 

Username

 

Enter the username for remote database access.

 

 

 

Password

 

Enter the password for remote database access.

 

 

Publish data every n hours

Choose a time interval from the drop-down list box for ACS to export data at the

 

 

specified interval. Valid options are 1, 2, 4, 6, 8, 12, and 24 hours. The default

 

 

interval is 4 hours.

 

 

 

Database Type

 

The type of remote database that you want to configure:

 

 

Click Microsoft Database radio button to configure a Microsoft database, and

 

 

 

enter the name of the remote database.

 

 

Click Oracle SID radio button to configure an Oracle database, and enter the

 

 

 

system identifier for the Oracle database.

 

 

Download Remote Database schema

Click this link to download the remote database schema files. The following two

files

 

schema files are downloaded:

 

 

acsview_microsoft_schema.sql

 

 

acsview_oracle_schema.sql

 

 

 

 

Step 2 Click Submit to configure the remote database.

Note You can view the status of your export job in the Scheduler. See Viewing Scheduled Jobs, page 15-11for more information.

Note If there are two log collector servers that have been configured to export data to a remote database, only one log collector server can export data to the remote database at a time. If a second log collector is pointed to the same remote database, it can cause issues such as over-writing of existing entries in the tables.

 

User Guide for Cisco Secure Access Control System 5.3

15-18

OL-24201-01

Page 476
Image 476
Cisco Systems OL-24201-01 manual 15-18