User's Manual

1566 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
LAST_DISCOVERY_STATUS The discovery status of the VCEM server in the
previous discovery cycle.
smallint
CREATION_TIME timestamp
LAST_UPDATE_TIME timestamp
LAST_FAILURE_TIMESTAMP The time of the last failed collection. timestamp
LAST_SUCCESSFUL_TIMES
TAMP
The time of the last successful collection. timestamp
TABLE 441 VIP_SERVER
Field Definition Format Size
ID Primary Key field for the VIP_SERVER int
TYPE
Even Policy Type
• 0? Virtual Server
• 1 ? Real Server
smallint
DEVICE_ID This is the foreign key reference key to the Device
Table
int
IP_ADDRESS The IP Address for the Virtual Server or Real Server varchar 128
NAME The Name of Virtual Server or Real Server varchar 256
TABLE 442 VIP_SERVER_BINDING
Field Definition Format Size
ID Primary Key field for the VIP_SERVER_BINDING int
DEVICE_ID This is the foreign key reference key to the Device
Table
int
VIRTUAL_SERVER_IP_ADDR
ESS
The IP Address for the Virtual Server varchar 128
VIRUTAL_SERVER_PORT The Port number of the Virtual Server int
REAL_SERVER_IP_ADDRES
S
The IP Address for the Real Server varchar 128
REAL_SERVER_PORT The Port Number for the Real Server int
TABLE 443 VIRTUAL_CIRCUIT_INTERFACE
Field Definition Format Size
INTERFACE_ID int
TABLE 440 VCEM_PROFILE (Continued)
Field Definition Format Size