Brocade Communications Systems IP250 user manual Vrconnmoduleinfo, Vrconndomain.Firmwareversion

Views I

CORE_SWITCH,

SWITCH_TE_PORT_STATS, VIRTUAL_SWITCH, DEVICE_PORT_MAC_ADDRESS_MAP, DEVICE_PORT_GIGE_PORT_LINK, GIGE_PORT

where

VM_PATH.HBA_PORT::BPCHAR = DEVICE_PORT.WWN

and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and VM_PATH.STORAGE_ID = VM_STORAGE.ID

and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID

and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID

and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID

and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID

and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS = GIGE_PORT.REMOTE_MAC_ADDRESS and GIGE_PORT.SWITCH_PORT_ID = SWITCH_TE_PORT_STATS.PORT_ID

and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID

and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID

and SWITCH_TE_PORT_STATS.CREATION_TIME in (select max(CREATION_TIME) from SWITCH_TE_PORT_STATS group by PORT_ID);

VR_CONN_MODULE_INFO

create or replace view VR_CONN_MODULE_INFO as select distinct

VR_CONN_MODULE.ID,

VR_CONN_MODULE.VR_CONN_DOMAIN_ID,

VR_CONN_MODULE.VCEM_ASSIGNED_ID, VR_CONN_MODULE.WWN, VR_CONN_MODULE.PRODUCT_NAME, VR_CONN_MODULE.SERIAL_NUMBER, VR_CONN_MODULE.STATUS, VR_CONN_MODULE.IO_BAY,

VR_CONN_MODULE.VENDOR,

VR_CONN_MODULE.CREATION_TIME,

VR_CONN_MODULE.LAST_UPDATE_TIME,

VR_CONN_DOMAIN.NAME as DOMAIN_NAME,

VR_CONN_DOMAIN.GUID as DOMAIN_GUID,

VR_CONN_DOMAIN.FIRMWARE_VERSION,

VR_CONN_DOMAIN_GROUP.NAME as DOMAIN_GROUP_NAME, VCEM_PROFILE.ID as VCEM_PROFILE_ID,

VCEM_PROFILE.DISCOVERY_STATUS,

VCEM_PROFILE.LAST_FAILURE_TIMESTAMP as VCEM_LAST_FAILED_TIME,

VCEM_PROFILE.LAST_SUCCESSFUL_TIMESTAMP as VCEM_LAST_SUCCESSFUL_TIME, VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID, VIRTUAL_SWITCH.MANAGED_ELEMENT_ID as VIRTUAL_SWITCH_ME_ID,

VIRTUAL_SWITCH.NAME, CORE_SWITCH.IP_ADDRESS, FABRIC_MEMBER.FABRIC_ID, FABRIC.MANAGED as FABRIC_MANAGED

from

VR_CONN_MODULE inner join

VR_CONN_DOMAIN on

VR_CONN_DOMAIN.ID = VR_CONN_MODULE.VR_CONN_DOMAIN_ID inner join

VCEM_PROFILE on

VCEM_PROFILE.ID = VR_CONN_DOMAIN.VCEM_PROFILE_ID

Brocade Network Advisor IP User Manual	1671
53-1003056-01