beautypg.com

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

Page 2544

background image

2472

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Database tables and fields

I

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 473

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 474

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 475

VM_DATASTORE_DETAILS

Field

Definition

Format

Size

ID Primary

key.

int

DATACENTER_ID Foreign

to

vm_data_center.

int

TABLE 472

VMOTION_EVENT (Continued)

Field

Definition

Format

Size