Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1913)

Brocade Network Advisor IP User Manual 1861
53-1003153-01
Views
I
INM_IP_INTERFACE.SUBNET_MASK
from INM_IP_INTERFACE) L3 on L2.INTERFACE_ID = L3.IP_ID;
CEE_PORT_INFO
create or replace view CEE_PORT_INFO as
CREATE VIEW cee_port_info AS
select
GIGE_PORT.ID,
GIGE_PORT.SWITCH_PORT_ID,
GIGE_PORT.PORT_NUMBER,
CEE_PORT.ID AS CEE_PORT_ID,
CEE_PORT.VIRTUAL_SWITCH_ID,
CEE_PORT.IF_INDEX,
CEE_PORT.IF_NAME,
CEE_PORT.IF_MODE,
CEE_PORT.L2_MODE,
CEE_PORT.VLAN_ID,
CEE_PORT.LAG_ID,
CEE_PORT.IP_ADDRESS,
CEE_PORT.MAC_ADDRESS,
CEE_PORT.PORT_SPEED,
CEE_PORT.ENABLED,
CEE_PORT.OCCUPIED,
CEE_PORT.LAST_UPDATE,
CEE_PORT.NET_MASK,
CEE_PORT.PROTOCOL_DOWN_REASON,
CEE_PORT.MAC_ACL_POLICY,
CEE_PORT.QOS_TYPE,
CEE_PORT.QOS_NAME,
CEE_PORT.DOT1X_ENABLED,
CEE_PORT.PORT_ROLE,
CEE_PORT.AMPP_PROFILE_MODE,
CORE_SWITCH.IP_ADDRESS as PHYSICAL_SWITCH_IP,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,
GIGE_PORT.OPERATIONAL_STATUS,
GIGE_PORT.MAX_SPEED,
GIGE_PORT.PORT_TYPE,
GIGE_PORT.REMOTE_MAC_ADDRESS,
GIGE_PORT.SLOT_NUMBER,
VIRTUAL_SWITCH.WWN,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MANAGED_ELEMENT_ID,
VIRTUAL_SWITCH.MONITORED,
SWITCH_PORT.USER_PORT_NUMBER,
SWITCH_PORT.STATE,
SWITCH_PORT.STATUS,
SWITCH_PORT.NAME,
SWITCH_PORT.LICENSED,
SWITCH_PORT.TRUNKED,
SWITCH_PORT.TRUNK_MASTER,
SWITCH_PORT.SPEED_TYPE
from
CEE_PORT, GIGE_PORT, SWITCH_PORT, VIRTUAL_SWITCH, CORE_SWITCH
where
CEE_PORT.GIGE_PORT_ID = GIGE_PORT.ID
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID
and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID;