I Views

where

VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID

and FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID;

SWITCH_DISCOVERED_MAC_INFO

create or replace view SWITCH_DISCOVERED_MAC_INFO as select

L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_VALUE, L2_NEIGHBOR.INTERFACE_ID, INTERFACE.NAME as INTERFACE_NAME, DEVICE.SYS_NAME as DEVICE_NAME,

DEVICE.IP_ADDRESS, DEVICE.DEVICE_ID

from

L2_NEIGHBOR, INTERFACE, DEVICE

where L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_SUBTYPE = 4

and L2_NEIGHBOR.INTERFACE_ID = INTERFACE.INTERFACE_ID and INTERFACE.DEVICE_ID = DEVICE.DEVICE_ID;

SWITCH_PORT_INFO

CREATE VIEW switch_port_info AS select

SWITCH_PORT.ID,

SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.WWN, SWITCH_PORT.NAME, SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.PORT_ID,

SWITCH_PORT.PORT_INDEX, SWITCH_PORT.AREA_ID,

SWITCH_PORT.MAC_ADDRESS, SWITCH_PORT.PORT_MOD,

SWITCH_PORT.TYPE, SWITCH_PORT.FULL_TYPE, SWITCH_PORT.STATUS, SWITCH_PORT.HEALTH, SWITCH_PORT.STATUS_MESSAGE, SWITCH_PORT.PHYSICAL_PORT, SWITCH_PORT.LOCKED_PORT_TYPE, SWITCH_PORT.CATEGORY, SWITCH_PORT.PROTOCOL, SWITCH_PORT.SPEED, SWITCH_PORT.SPEEDS_SUPPORTED, SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.DESIRED_CREDITS, SWITCH_PORT.BUFFER_ALLOCATED, SWITCH_PORT.ESTIMATED_DISTANCE, SWITCH_PORT.ACTUAL_DISTANCE, SWITCH_PORT.LONG_DISTANCE_SETTING, SWITCH_PORT.DEGRADED_PORT, SWITCH_PORT.REMOTE_NODE_WWN,

1652

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1704
Image 1704
Brocade Communications Systems IP250 user manual Switchdiscoveredmacinfo, Switchportinfo, Device.Ipaddress, Device.Deviceid