Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1443
53-1002948-01
Database tables and fields
H
STATS_COLLECTION 1 = statistics collection is enabled; otherwise, 0.
Default value is 0.
smallint
CREATION_TIME time at which this record was created.
Default value is ’now()’.
timestamp
LAST_UPDATE_TIME time when this was last updated.
Default value is ’now()’.
timestamp
TABLE 331 SAN_CONNECTION
Field Definition Format Size
ID Unique generated database identifier. serial
SOURCE_SWITCH_ID Foreign key to VIRTUAL_SWITCH table. This is the
virtual switch ID of AG
int
SOURCE_PORT_ID Foreign key to SWITCH_PORT table. This is the switch
port id of N-port
int
SOURCE_PORT_WWN WWN of the AG N port varchar 32
SOURCE_PORT_TYPE Type of source port varchar 16
SOURCE_USER_PORT_NUM
BER
User port number of AG N port smallint
DESTINATION_SWITCH_ID Foreign key to VIRTUAL_SWITCH table. This is the
virtual switch ID of edge switch
int
DESTINATION_PORT_ID Foreign key to SWITCH_PORT table. This is the switch
port id of F-port
int
DESTINATION_PORT_WWN WWN of the F port varchar 23
DESTINATION_PORT_TYPE Type of destination port varchar 16
DESTINATION_USER_PORT_
NUMBER
User port number of F-port smallint
FABRIC_ID Foreign key to FABRIC table int
TRUSTED Indicates if the connection is trusted smallint
MISSING Indicates if the connection is missing smallint
MISSING_TIME Timestamp when the connection went missing timestamp
LAST_UPDATE_TIME Last update time for this record timestamp
CREATION_TIME Creation timestamp timestamp
TABLE 332 SCOM_HOST
Field Definition Format Size
ID Unique generated database identifier. int
HOST The FQDN or the ip address of the host varchar 256
DOMAIN The domain of the SCOM server host varchar 256
USER_NAME The domain user to login into the SCOM Server varchar 64
TABLE 330 SAN (Continued)
Field Definition Format Size