Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1542 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
IFL.EDGE_FABRIC_ID,
(select distinct FCR_PORT.VIRTUAL_SWITCH_ID
from SWITCH_PORT FCR_PORT
where FCR_PORT.WWN = IFL.BB_PORT_WWN)
as FCR_SWITCH_ID,
IFL.EDGE_PORT_WWN,
IFL.BB_FABRIC_ID,
IFL.BB_PORT_WWN ,
IFL.BB_RA_TOV,
IFL.BB_ED_TOV,
IFL.BB_PID_FORMAT,
SWITCH_PORT.VIRTUAL_SWITCH_ID as EDGE_SWITCH_ID,
SWITCH_PORT.ID as EDGE_PORT_ID,
SWITCH_PORT.USER_PORT_NUMBER as EDGE_PORT_NUMBER,
SWITCH_PORT.TYPE as EDGE_PORT_TYPE
from IFL
left outer join SWITCH_PORT
on IFL.EDGE_PORT_WWN = SWITCH_PORT.WWN;
ISL_INFO
create or replace view ISL_INFO as
select distinct
ISL.ID,
ISL.FABRIC_ID,
ISL.COST,
ISL.TYPE,
ISL.SOURCE_DOMAIN_ID,
ISL.SOURCE_PORT_NUMBER,
ISL.MISSING,
SOURCE_VIRTUAL_SWITCH.ID as SOURCE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.NAME as SOURCE_SWITCH_NAME,
SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID as SOURCE_CORE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.BASE_SWITCH as SOURCE_BASE_SWITCH,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE as
SOURCE_VIRTUAL_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_VIRTUAL_SWITCH_MONITORED,
SOURCE_SWITCH_PORT.ID as SOURCE_SWITCH_PORT_ID,
SOURCE_SWITCH_PORT.WWN as SOURCE_SWITCH_PORT_WWN,
SOURCE_SWITCH_PORT.NAME as SOURCE_SWITCH_PORT_NAME,
SOURCE_SWITCH_PORT.TYPE as PORT_TYPE,
SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND,
SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT,
SOURCE_SWITCH_PORT.TRUNKED as SOURCE_SWITCH_PORT_TRUNKED,
ISL.DEST_DOMAIN_ID,
ISL.DEST_PORT_NUMBER,
DEST_VIRTUAL_SWITCH.ID as DEST_SWITCH_ID,
DEST_VIRTUAL_SWITCH.NAME as DEST_SWITCH_NAME,
DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN,
DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID as DEST_CORE_SWITCH_ID,
DEST_VIRTUAL_SWITCH.BASE_SWITCH as DEST_BASE_SWITCH,
DEST_VIRTUAL_SWITCH.MANAGEMENT_STATE as DEST_VIRTUAL_SWITCH_MANAGEMENT_STATE,
DEST_VIRTUAL_SWITCH.MONITORED as DEST_VIRTUAL_SWITCH_MONITORED,
DEST_SWITCH_PORT.ID as DEST_SWITCH_PORT_ID,
DEST_SWITCH_PORT.WWN as DEST_SWITCH_PORT_WWN,
DEST_SWITCH_PORT.NAME as DEST_SWITCH_PORT_NAME,
DEST_SWITCH_PORT.KIND as DEST_SWITCH_PORT_KIND,
DEST_SWITCH_PORT.PHYSICAL_PORT as DEST_PHYSICAL_PORT,