Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual
Page 2554
2482
Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Database tables and fields
I
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 490
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 489
VM_PATH
(Continued)
Field
Definition
Format
Size