Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1412 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID,
VIRTUAL_SWITCH.DOMAIN_ID as DOMAIN_ID,
VIRTUAL_SWITCH.INTEROP_MODE as INTEROP_MODE,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MONITORED,
CORE_SWITCH.TYPE as SWITCH_TYPE,
CORE_SWITCH.FIRMWARE_VERSION as FIRMWARE_VERSION,
CORE_SWITCH.IP_ADDRESS as IP_ADDRESS,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,
CORE_SWITCH.MODEL as SWITCH_MODEL,
CORE_SWITCH_DETAILS.MODEL_NUMBER as SWITCH_MODEL_NUMBER
from
VIRTUAL_FCOE_PORT, CORE_SWITCH, VIRTUAL_SWITCH, CORE_SWITCH_DETAILS
where
VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and
CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID;
VIRTUAL_PORT_WWN_DETAILS_INFO
create or replace view VIRTUAL_PORT_WWN_DETAILS_INFO as
select distinct
VIRTUAL_PORT_WWN_DETAILS.SWITCH_ID,
VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER,
VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER,
coalesce(CS1.IP_ADDRESS, CS2.IP_ADDRESS, UDDD.IP_ADDRESS) as IP_ADDRESS,
coalesce(VS1.NAME, VS2.NAME, UDDD.NAME) as SWITCH_NAME,
coalesce(VS1.WWN, VS2.WWN) as SWITCH_WWN,
VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN,
VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER,
VIRTUAL_PORT_WWN_DETAILS.STATUS,
VIRTUAL_PORT_WWN_DETAILS.TYPE,
VIRTUAL_PORT_WWN_DETAILS.USER_VPWWN,
VIRTUAL_PORT_WWN_DETAILS.AUTO_VPWWN,
VIRTUAL_PORT_WWN_DETAILS.DEVICE_PORT_WWN,
coalesce(SP1.ID, SP2.ID) as SWITCH_PORT_ID,
coalesce(SP1.WWN, SP2.WWN) as PORT_WWN,
coalesce(SP1.TYPE, SP2.TYPE) AS PORT_TYPE,
coalesce(SP1.NAME, SP2.NAME) as PORT_NAME
from
VIRTUAL_PORT_WWN_DETAILS
left outer join VIRTUAL_SWITCH VS1
on (VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = -1
and VIRTUAL_PORT_WWN_DETAILS.SWITCH_ID = VS1.ID)
left outer join VIRTUAL_SWITCH VS2
on VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN = VS2.WWN
left outer join CORE_SWITCH CS1
on VS1.CORE_SWITCH_ID = CS1.ID
left outer join CORE_SWITCH CS2
on VS2.CORE_SWITCH_ID = CS2.ID
left outer join SWITCH_PORT SP1
on (SP1.VIRTUAL_SWITCH_ID=VS1.ID
and VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER = SP1.SLOT_NUMBER
and VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER = SP1.PORT_NUMBER
and SP1.TYPE NOT IN ('GigE-Port','TE-Port'))
left outer join SWITCH_PORT SP2
on (SP2.VIRTUAL_SWITCH_ID=VS2.ID
and VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = SP2.PORT_NUMBER
and SP2.TYPE NOT IN ('GigE-Port','TE-Port'))