Brocade Communications Systems IP250 user manual Wirelessinterface, Select

I Views

MEMBER_DEVICE.MANAGED_ELEMENT_ID = TRILL_TRUNK_GROUP.ME_ID left outer join INTERFACE MASTER_INTERFACE on

MASTER_INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and

MASTER_INTERFACE.IDENTIFIER = TRILL_TRUNK_GROUP.MASTER_PORT_NUMBER left outer join INTERFACE MEMBER_INTERFACE on

MEMBER_INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and

MEMBER_INTERFACE.IDENTIFIER = TRILL_TRUNK_MEMBER.PORT_NUMBER left outer join VCS_CLUSTER_MEMBER on

VCS_CLUSTER_MEMBER.MEMBER_ME_ID = TRILL_TRUNK_GROUP.ME_ID left outer join DEVICE CLUSTER_DEVICE on

CLUSTER_DEVICE.MANAGED_ELEMENT_ID = VCS_CLUSTER_MEMBER.CLUSTER_ME_ID;

WIRELESS_INTERFACE

create or replace view wireless_interface as

SELECT

l2.device_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.speed_in_mb, l2.physical_address, l2.interface_id AS radioif_id, wireless.radio_type, wireless.is_enabled, wireless.is_auto_channel, wireless.tx_power, wireless.channel_number, wireless.max_data_rate, wireless.beacon_rate, wireless.dtim, wireless.rts_threshold, wireless.is_turbo_mode, wireless.radio_g_mode, wireless.max_associated_clients

FROM

((SELECT DISTINCT d.device_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, pi.speed_in_mb, pi.physical_address

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))

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