User's Manual

1686 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
L3.SUBNET_MASK
from ( select distinct D.DEVICE_ID, D.MANAGED_ELEMENT_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, I.TABLE_SUBTYPE, I.TAG_MODE,
I.USER_DEFINED_VALUE_1, I.USER_DEFINED_VALUE_2,
I.USER_DEFINED_VALUE_3,
PI.SPEED_IN_MB, PI.PHYSICAL_ADDRESS, PI.DUPLEX_MODE
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 and I.TABLE_SUBTYPE::TEXT <> 'RADIO_INTERFACE'::TEXT) L2
left join ( select INM_IP_INTERFACE.INTERFACE_ID as IP_ID,
INM_IP_INTERFACE.IP_INTERFACE_ID, INM_IP_INTERFACE.IP_ADDRESS,
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,