Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1468 / 1505

1420 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
SWITCH_PORT,
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