Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1404 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
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 or replace 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,
SWITCH_PORT.REMOTE_PORT_WWN,
SWITCH_PORT.LICENSED,
SWITCH_PORT.SWAPPED,
SWITCH_PORT.TRUNKED,
SWITCH_PORT.TRUNK_MASTER,
SWITCH_PORT.PERSISTENT_DISABLE,
SWITCH_PORT.FICON_SUPPORTED,
SWITCH_PORT.BLOCKED,
SWITCH_PORT.PROHIBIT_PORT_NUMBERS,
SWITCH_PORT.PROHIBIT_PORT_COUNT,
SWITCH_PORT.NPIV,
SWITCH_PORT.NPIV_CAPABLE,
SWITCH_PORT.NPIV_ENABLED,
SWITCH_PORT.FC_FAST_WRITE_ENABLED,
SWITCH_PORT.ISL_RRDY_ENABLED,
SWITCH_PORT.RATE_LIMIT_CAPABLE,
SWITCH_PORT.RATE_LIMITED,
SWITCH_PORT.QOS_CAPABLE,
SWITCH_PORT.QOS_ENABLED,