Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1912)

1860 Brocade Network Advisor IP User Manual
53-1003153-01
Views
I
select
L2.DEVICE_ID,
L2.MANAGED_ELEMENT_ID,
L2.DEVICE_IP_ADDRESS,
L2.PHYSICAL_DEVICE_ID,
L2.UNIT_NUMBER,
L2.SLOT_ID,
L2.SLOT_NUM,
L2.MODULE_ID,
L2.PHYSICAL_PORT_ID,
L2.PORT_NUM,
L2.INTERFACE_ID,
L2.NAME,
L2.IF_NAME,
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,