Brocade Communications Systems IP250 user manual Wiredinterface

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,

Brocade Network Advisor IP User Manual	1685
53-1003056-01