I Views

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,

1686

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1738
Image 1738
Brocade Communications Systems IP250 user manual Ceeportinfo, L3.SUBNETMASK, Deviceipaddress, Ceeport.Amppprofilemode