Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2294)

Brocade Network Advisor SAN + IP User Manual 2257
53-1002949-01
Views
I
SWITCH_INFO.DOMAIN_ID as VIRTUAL_SWITCH_DOMAIN_ID,
SWITCH_INFO.VIRTUAL_FABRIC_ID,
SWITCH_INFO.BASE_SWITCH,
SWITCH_INFO.STATE as VIRTUAL_SWITCH_STATE,
SWITCH_INFO.STATUS as VIRTUAL_SWITCH_STATUS,
SWITCH_INFO.FABRIC_ID,
SWITCH_INFO.MONITORED,
SWITCH_INFO.CRYPTO_CAPABLE
from
DEVICE_NODE, DEVICE_PORT, SWITCH_PORT, SWITCH_INFO
where
DEVICE_PORT.NODE_ID = DEVICE_NODE.ID and
DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and
SWITCH_PORT.VIRTUAL_SWITCH_ID = SWITCH_INFO.ID and
DEVICE_NODE.FABRIC_ID = SWITCH_INFO.FABRIC_ID;
N2F_PORT_MAP_INFO
create or replace view N2F_PORT_MAP_INFO as
select
N2F_PORT_MAP.VIRTUAL_SWITCH_ID,
N2F_PORT_MAP.N_PORT,
N2F_PORT_MAP.F_PORT,
AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN,
AG_N_PORT.WWN as AG_N_PORT_WWN,
AG_F_PORT.WWN as AG_F_PORT_WWN,
AG_F_PORT.REMOTE_NODE_WWN,
AG_F_PORT.REMOTE_PORT_WWN as DEVICE_PORT_WWN
from
N2F_PORT_MAP,
SWITCH_PORT AG_N_PORT,
SWITCH_PORT AG_F_PORT,
VIRTUAL_SWITCH AG_SWITCH
where
N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_N_PORT.VIRTUAL_SWITCH_ID
and N2F_PORT_MAP.N_PORT = AG_N_PORT.USER_PORT_NUMBER
and N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_F_PORT.VIRTUAL_SWITCH_ID
and N2F_PORT_MAP.F_PORT = AG_F_PORT.USER_PORT_NUMBER
and AG_N_PORT.VIRTUAL_SWITCH_ID = AG_SWITCH.ID
and AG_SWITCH.MONITORED = 1;
DEVICE_NODE_INFO
create or replace view DEVICE_NODE_INFO as
select
DEVICE_NODE.ID,
DEVICE_NODE.FABRIC_ID,
DEVICE_NODE.WWN,
DEVICE_NODE.TYPE,
DEVICE_NODE.DEVICE_TYPE,
DEVICE_NODE.SYMBOLIC_NAME,
DEVICE_NODE.FDMI_HOST_NAME,
DEVICE_NODE.VENDOR,
DEVICE_NODE.CAPABILITY_,
DEVICE_NODE.TRUSTED,
DEVICE_NODE.CREATION_TIME,
DEVICE_NODE.MISSING,
DEVICE_NODE.MISSING_TIME,