1672 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
left outer join
VR_CONN_DOMAIN_GROUP on
VR_CONN_DOMAIN_GROUP.ID = VR_CONN_DOMAIN.VR_CONN_DOMAIN_GROUP_ID
left outer join
VIRTUAL_SWITCH on
VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN
left outer join
CORE_SWITCH on
CORE_SWITCH.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID
inner join
FABRIC_MEMBER on
FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
inner join
FABRIC on
FABRIC_MEMBER.FABRIC_ID = FABRIC.ID
union
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,
DEVICE_NODE.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
left outer join
VR_CONN_DOMAIN_GROUP on
VR_CONN_DOMAIN_GROUP.ID = VR_CONN_DOMAIN.VR_CONN_DOMAIN_GROUP_ID
left outer join
VIRTUAL_SWITCH on
VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN
left outer join
CORE_SWITCH on
CORE_SWITCH.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID
left outer join