Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1545
53-1002948-01
Views
H
ISL_TRUNK_INFO
CREATE VIEW isl_trunk_info AS
select
ISL_TRUNK_GROUP.ID,
ISL_TRUNK_GROUP.TRUSTED,
ISL_TRUNK_GROUP.MISSING,
ISL_TRUNK_GROUP.MISSING_TIME,
ISL_TRUNK_GROUP.MEMBER_TRACKING_STATUS,
ISL_INFO.COST,
ISL_INFO.TYPE,
ISL_INFO.SOURCE_PORT_NUMBER,
ISL_INFO.SOURCE_SWITCH_ID,
ISL_INFO.MISSING_REASON,
SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS,
SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE as SOURCE_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_SWITCH_MONITORED,
ISL_INFO.SOURCE_DOMAIN_ID as MASTER_PORT,
ISL_INFO.SOURCE_SWITCH_NAME,
ISL_INFO.SOURCE_SWITCH_PORT_ID,
ISL_INFO.DEST_PORT_NUMBER,
ISL_INFO.DEST_SWITCH_ID,
DEST_CORE_SWITCH.IP_ADDRESS as DEST_SWITCH_IP_ADDRESS,
DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN,
DEST_VIRTUAL_SWITCH.MANAGEMENT_STATE as DEST_SWITCH_MANAGEMENT_STATE,
DEST_VIRTUAL_SWITCH.MONITORED as DEST_SWITCH_MONITORED,
ISL_INFO.SOURCE_SWITCH_PORT_WWN,
ISL_INFO.DEST_DOMAIN_ID as REMOTE_MASTER_PORT,
ISL_INFO.DEST_SWITCH_NAME,
ISL_INFO.DEST_SWITCH_PORT_ID
from
ISL_TRUNK_GROUP,
ISL_INFO,
CORE_SWITCH SOURCE_CORE_SWITCH,
CORE_SWITCH DEST_CORE_SWITCH,
VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH
where
ISL_INFO.SOURCE_SWITCH_ID = ISL_TRUNK_GROUP.VIRTUAL_SWITCH_ID
and ISL_INFO.SOURCE_PORT_NUMBER = ISL_TRUNK_GROUP.MASTER_USER_PORT
and ISL_INFO.SOURCE_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID
and SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID = SOURCE_CORE_SWITCH.ID
and ISL_INFO.DEST_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID
and DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID = DEST_CORE_SWITCH.ID;
L2_NEIGHBOR_INFO
create or replace view L2_NEIGHBOR_INFO as
select
L2_NEIGHBOR.INTERFACE_ID,
L2_NEIGHBOR.RMT_IP_ADDRESS,
L2_NEIGHBOR.RMT_IF_NAME,
LLDP_DATA.DEVICE_ID as RMT_DEVICE_ID,
LLDP_DATA.INTERFACE_ID as RMT_INTERFACE_ID,
PHY_INTF.PHYSICAL_ADDRESS as RMT_INTERFACE_MAC,
RMT_DEVICE.IS_ROUTER