User's Manual

Brocade Network Advisor IP User Manual 1685
53-1003056-01
Views
I
AND ((i.table_subtype)::text = 'RADIO_INTERFACE'::text)))
l2 LEFT JOIN
(SELECT radio_interface.interface_id
AS radioif_id, radio_interface.radio_type, radio_interface.is_enabled,
radio_interface.is_auto_channel, radio_interface.tx_power,
radio_interface.channel_number, radio_interface.max_data_rate,
radio_interface.beacon_rate, radio_interface.dtim, radio_interface.rts_threshold,
radio_interface.is_turbo_mode, radio_interface.radio_g_mode,
radio_interface.max_associated_clients
FROM radio_interface)
wireless ON ((l2.interface_id = wireless.radioif_id)));
WIRED_INTERFACE
CREATE VIEW wired_interface AS
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,