332 SQL reference
Using MySQL tables
Using MySQL tables
This section describes the structure of the incident and event tables that
Symantec Network Security uses to export data to a MySQL database.
To configure software or appliance nodes to export tables to MySQL, see also
“Exporting to SQL”
on page 257.
Note:
MySQL supports
varchar
, but the maximum size of that field is limited to
255. Therefore,
varchar
fields that are larger than 255 in the MySQL statements
become
text
fields, but if smaller than 255, they remain
varchar
.
■
MySQL incident table
■
MySQL event table
MySQL incident table
The following table describes the structure of the table that Symantec Network
Security uses to export incident data to a MySQL database:
Table B-3
MySQL Incident Table
Field Name
Type
Description
Notes
class
varchar(33)
Indicates the class of the best event.
clusterID
integer
Indicates the Network Security cluster ID where
the incident originated
crtTime
integer
Indicates the time that this incident was created. Standard UNIX time format
custID
varchar(41)
Indicates the Customer ID of the best event.
devid
varchar(33)
Indicates the ID of the device (
deviceID
from
topology table) where the best event was
detected.
Used internally
devName
varchar(41)
Indicates the device name of the best event.
eventNum
integer
Indicates the
eventNum
of the best event. This
is the event that best represents this incident
(usually the one with the highest severity).
family
varchar(33)
Indicates the family of the best event.
flowcookie
text
Indicates the flowcookie of the best event.
Содержание 10521146 - Network Security 7120
Страница 1: ...Symantec Network Security Administration Guide...
Страница 12: ...12 Contents Index...
Страница 14: ...14...
Страница 70: ...70...
Страница 110: ...110 Populating the topology database Adding nodes and objects...
Страница 158: ...158 Responding Managing flow alert rules...
Страница 188: ...188...
Страница 242: ...242 Reporting Playing recorded traffic...
Страница 268: ...268 Managing log files Exporting data...
Страница 316: ...316 Advanced configuration Configuring advanced parameters...
Страница 317: ...Part IV Appendices The following appendices provide additional reference information User groups reference SQL reference...
Страница 318: ...318...
Страница 338: ...338 SQL reference Using MySQL tables...
Страница 366: ...366 Glossary...
Страница 392: ...392 Index...