I Views

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

1672

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1724
Image 1724
Brocade Communications Systems IP250 user manual Union Select distinct VRCONNMODULE.ID