Enterasys Security Information and Event Manager, Configuration Manual

Page: 334 / 426

Configuring DSMs
318 S
OPHOS
Confirm
Password Confirm the password required to access the database. The
confirmation password must be identical to the password entered
in the Password parameter.
Authentication
Domain If you select MSDE as the Database Type and the database is
configured for Windows, you must define a Window Authentication
Domain. Otherwise, leave this field blank.
Database
Instance Optional. Type the database instance, if you have multiple SQL
server instances on your database server.
Note: If you define a port number other than the default in the Port
parameter, or have blocked access to port 1434 for SQL database
resolution, you must leave the Database Instance parameter
blank.
Table Name Type
siem_view
as the name of the table or view that includes
the event records.
Select List Type
*
for all fields from the table or view.
You may use a comma-separated list to define specific fields from
tables or views, if required for your configuration. The list must
contain the field defined in the Compare Field parameter. The
comma-separated list can be up to 255 alphanumeric characters in
length. Also, the list may include the following special characters:
dollar sign ($), number sign (#), underscore (_), en dash (-), and
period(.).
Compare Field Type
ID
. The Compare Field parameter is used to identify new
events added between queries to the table.
Use Prepared
Statements Select the check box to use prepared statements.
Prepared statements allows the JDBC protocol source to set up
the SQL statement once, and then execute the SQL statement
many times with different parameters. For security and
performance reasons, we recommend that you use prepared
statements.
Clearing this check box requires you to use an alternative method
of querying that does not use pre-compiled statements.
Start Date and
Time Optional. Type the start date and time for database polling.
The Start Date and Time parameter must be formatted as
yyyy-MM-dd HH:mm with HH specified using a 24-hour clock. If
the Start Date and Time parameter is clear, polling begins
immediately and repeats at the specified polling interval.
Polling Interval Type the polling interval, which is the amount of time between
queries to the event table. The default polling interval is 10
seconds.
You can define a longer polling interval by appending H for hours
or M for minutes to the numeric value. The maximum polling
interval is 1 week in any time format. Numeric values entered
without an H or M poll in seconds.
Table 61-1 Sophos PureMessage JDBC Parameters (continued)
Parameter Description