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

Brocade Network Advisor SAN + IP User Manual 2329
53-1002949-01
Views
I
L2.IDENTIFIER,
L2.TABLE_SUBTYPE,
case
when L2.TABLE_SUBTYPE like 'GBIT_ETHERNET_INTERFACE' then 'GIGABIT ETHERNET'
when L2.TABLE_SUBTYPE like 'POS_INTERFACE' then 'POS'
else L2.TABLE_SUBTYPE
end as TABLE_SUBTYPE_TXT,
L2.TAG_MODE,
case
when L2.TAG_MODE = 1 then 'TAGGED'
when L2.TAG_MODE = 2 then 'UNTAGGED'
when L2.TAG_MODE = 3 then 'DUAL'
else null
end as TAG_MODE_TXT,
L2.USER_DEFINED_VALUE_1,
L2.USER_DEFINED_VALUE_2,
L2.USER_DEFINED_VALUE_3,
L2.SPEED_IN_MB,
L2.PHYSICAL_ADDRESS,
L2.DUPLEX_MODE,
case
when L2.DUPLEX_MODE = 1 then 'HALF-DUPLEX'
when L2.DUPLEX_MODE = 2 then 'FULL-DUPLEX'
when L2.DUPLEX_MODE = 3 then 'AUTO-SENSE'
else null
end as DUPLEX_MODE_TXT,
L3.IP_ID,
L3.IP_INTERFACE_ID,
L3.IP_ADDRESS,
L3.SUBNET_MASK
from ( select distinct D.DEVICE_ID, D.MANAGED_ELEMENT_ID, D.IP_ADDRESS as
DEVICE_IP_ADDRESS,
PD.PHYSICAL_DEVICE_ID, PD.UNIT_NUMBER, S.SLOT_ID, S.SLOT_NUM,
MSP.MODULE_ID, PP.PHYSICAL_PORT_ID, PP.PORT_NUM, I.INTERFACE_ID,
I.NAME, I.IF_NAME, I.IDENTIFIER, I.TABLE_SUBTYPE, I.TAG_MODE,
I.USER_DEFINED_VALUE_1, I.USER_DEFINED_VALUE_2,
I.USER_DEFINED_VALUE_3,
PI.SPEED_IN_MB, PI.PHYSICAL_ADDRESS, PI.DUPLEX_MODE
from DEVICE D, PHYSICAL_DEVICE PD, SLOT S, MODULE_SLOT_PRESENT MSP,
PHYSICAL_PORT PP, PHYSICAL_INTERFACE PI, INTERFACE I
where D.DEVICE_ID = PD.DEVICE_ID and PD.PHYSICAL_DEVICE_ID =
S.PHYSICAL_DEVICE_ID and S.SLOT_ID = MSP.SLOT_ID and MSP.MODULE_ID = PP.MODULE_ID
and PP.PHYSICAL_PORT_ID = PI.PHYSICAL_PORT_ID and PI.INTERFACE_ID =
I.INTERFACE_ID and I.TABLE_SUBTYPE::TEXT <> 'RADIO_INTERFACE'::TEXT) L2
left join ( select INM_IP_INTERFACE.INTERFACE_ID as IP_ID,
INM_IP_INTERFACE.IP_INTERFACE_ID, INM_IP_INTERFACE.IP_ADDRESS,
INM_IP_INTERFACE.SUBNET_MASK
from INM_IP_INTERFACE) L3 on L2.INTERFACE_ID = L3.IP_ID;
CEE_PORT_INFO
create or replace view CEE_PORT_INFO as
select
GIGE_PORT.ID,
GIGE_PORT.SWITCH_PORT_ID,
GIGE_PORT.PORT_NUMBER,
CEE_PORT.ID AS CEE_PORT_ID,
CEE_PORT.VIRTUAL_SWITCH_ID,
CEE_PORT.IF_INDEX,