beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2557

background image

Brocade Network Advisor SAN + IP User Manual

2485

53-1003155-01

Database tables and fields

I

VM_STANDARD_VIRTUA
L__SWITCH_ID

Foreign Key to the vm_standard_virtual_switch
table. The standard virtual swtich on which this
port group exists.

int

MOR_ID

The managed object reference number
assigned by the hypervisor.

int

TABLE 495

VM_STORAGE

Field

Definition

Format

Size

ID

Uniquely identifies this LUN.

serial

HOST_ID

Identifies the server that accesses this LUN.

int

NAME

The VM-assigned device name for this LUN,
such as vmhba1:0:0. For VMware, this is the
canonical name.

varchar

512

TARGET_NODE

The Node WWN or iSCSI target name for the
storage device (target) that contains this LUN.

char

256

VENDOR

Vendor name, such as Seagate.

varchar

64

MODEL

Target model name, such as ST581.

varchar

64

SERIAL_NUMBER

The device''s serial number.

varchar

64

TYPE

0 = disk, 1 = tape.

smallint

CAPACITY

For disks, the disk capacity in GB.

double precision

STATUS

The status reported by the host. 0 = offline, 1 =
online.

smallint

PATH_POLICY

Determines how multiple paths to this LUN are
used. 0 = fixed, 1 = Most Recently Used, 2 =
Round Robin.

smallint

UUID

Universal unique ID

varchar

DATASTORE_URL

The unique locator for the datastore.

varchar

256

DATASTORE_NAME

Name of the datastore in case this LUN/NAS
volume is exposed as an extent of a VMFS/NFS
datastore.

varchar

256

ISCSI_TARGET_ADDRESS

IP address or host name of the iSCSI target.

varchar

256

ISCSI_TARGET_PORT

The TCP port of the storage device. If not
specified, the standard default of 3260 is used.

varchar

10

NAS_REMOTE_HOST

The host that runs the NFS/CIFS server.

varchar

64

NAS_REMOTE_PATH

The remote path of NFS/CIFS mount point.

varchar

256

NAS_REMOTE_USER

In case of CIFS, the user name used while
connecting to the server.

varchar

256

TARGET_PORT

Target Port WWN that the storage is connected
to or the iSCSI target address.

varchar

256)

TABLE 494

VM_STD_VSWITCH_PORT_GROUP (Continued)

Field

Definition

Format

Size