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

Table Of Contents
Brocade Network Advisor SAN User Manual 1497
53-1002948-01
Database tables and fields
H
FABRIC_ID
Identifies the fabric that contains this path. Not a for-
eign key reference. Copied here for convenience.
Determined by locating the HBA port WWN or target
port WWN in the DEVICE_PORT table. Zero if the fab-
ric is not managed. The default value is 0.
int
HBA_PORT The HBAs physical port WWN for this path char 23
VM_PORT_WWN
The initiator port WWN used by the VM. If NPIV is
used, this is a virtual port WWN assigned by the VM
to this HBA port. If NPIV is not used, this WWN is the
same as the HBA Port WWN
char 23
TARGET_PORT The port WWN of the destination target. char 23
ENABLED '0 = path disabled, 1 = path enabled.
The default value is 0.
smallint
ACTIVE 0 = path inactive, 1 = path active.
The default value is 0.
smallint
PREFERRED
0 = not preferred, 1 = preferred path. The preferred
path is used whenever available when the path pol-
icy is Fixed.The default value is 0.
smallint
USAGE
Identifies how a VMware VM uses this LUN. 0 = NA
(used for Hyper-V), 1 = VMFS (datastores), 2 = RDM
(Raw Device Mapping). The default value is 0.
smallint
HBA_NODE The HBA physical node WWN for this path char 23
VM_NODE_WWN
The initiator node WWN used by the VM. If NPIV is
used, this is a virtual node WWN assigned to the VM.
If NPIV is not used, this WWN is the same as the node
WWN of one of the HBAs in the host.
char 23
TARGET_NODE The node WWN of the destination target char 23
HBA_NAME The hypervisor device name of the HBA used in this
path, such as vmhba1
varchar 64
FS_TYPE This field will identify the filesystem type to be either:
VMFS, NFS or RDM.
varchar 32
TABLE 435 VM_PHYSICAL_NIC
Field Definition Format Size
ID Unique generated database identifier. serial
DEVICE_NAME The device name of the physical network
adapter.
varchar 256
DRIVER The name of the driver varchar 256
LINK_SPEED_MBPS The bit rate on the link int
TABLE 434 VM_PATH (Continued)
Field Definition Format Size