Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1336 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
VCENTER_HOST The FQDN or the ip address of the vcenter. varchar 256
VNIC_MACS Comma separated vnic mac addresses. varchar 256
START_TIME Start time of the vmotion event. timestamp
END_TIME End time of the vmotion event, could be null
cause of a failed vmotion.
timestamp
STATUS VMotion event status. 0 = info, 1 = warning, 2 =
failed.
smallint
DRS_TRIGGERED Identifies whether the events was due to DRS. 0
= No, 1 = Yes.
smallint
USER_NAME Identifies that user who initiated the vmotion. varchar 80
DESCRIPTION Event message that is received. varchar 256
TABLE 398 VMOTION_PNIC_DETAILS
Field Definition Format Size
ID Identifies an entry for the source or destination
pnic and the connected switch details.
int
VMOTION_EVENT_ID Foreign key to the vmotion_event table. int
PNIC_TYPE Pnic type. 0 = source, 1 = destination,
identifies if the pNIC is from the source or the
destination host.
smallint
PNIC_MAC Physical Nic mac addresse of the connected
Pnic on the host.
varchar 256
PORT_PROFILES Comma separated PP Name-SwitchName for
all the port profiles associated with the vNics
that are being migrated as a result of the
vmotion.
varchar 256
SWITCH_NAME Switch names entry for connected switch to the
pNic.
varchar 256
SWITCH_IP_ADDRESS Switch ip addresses entries for connected
switch to the pNic.
varchar 256
TABLE 399 VM_DATA_CENTER
Field Definition Format Size
ID Unique generated database identifier.
NAME Data center name. varchar 256
VCENTER_ID Id of the vCenter server managing this Data
center.
int
MOR_ID The managed object reference number
assigned by the hypervisor.
int
TABLE 397 VMOTION_EVENT (Continued)
Field Definition Format Size