Brocade Communications Systems IP250 user manual Phantomportinfo, Productinfo

Views I

AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN, AG_N_PORT.WWN as AG_N_PORT_WWN, AG_F_PORT.USER_PORT_NUMBER as F_PORT, AG_F_PORT.WWN as AG_F_PORT_WWN, AG_F_PORT.REMOTE_NODE_WWN

from

NPORT_WWN_MAP,

SWITCH_PORT AG_N_PORT,

SWITCH_PORT AG_F_PORT,

VIRTUAL_SWITCH AG_SWITCH where

NPORT_WWN_MAP.VIRTUAL_SWITCH_ID = AG_N_PORT.VIRTUAL_SWITCH_ID and NPORT_WWN_MAP.N_PORT = AG_N_PORT.USER_PORT_NUMBER

and NPORT_WWN_MAP.VIRTUAL_SWITCH_ID = AG_F_PORT.VIRTUAL_SWITCH_ID and NPORT_WWN_MAP.DEVICE_PORT_WWN = AG_F_PORT.REMOTE_PORT_WWN

AND AG_N_PORT.VIRTUAL_SWITCH_ID = AG_SWITCH.ID and AG_SWITCH.MONITORED = 1;

PHANTOM_PORT_INFO

create or replace view PHANTOM_PORT_INFO as select

PHANTOM_PORT.ID,

PHANTOM_PORT.WWN,

PHANTOM_PORT.VIRTUAL_SWITCH_ID, PHANTOM_PORT.PORT_NUMBER, PHANTOM_PORT.PORT_ID,

PHANTOM_PORT.SPEED, PHANTOM_PORT.MAX_SPEED, PHANTOM_PORT.TYPE, PHANTOM_PORT.REMOTE_NODE_WWN, PHANTOM_PORT.REMOTE_PORT_WWN, PHANTOM_PORT.PHANTOM_TYPE, PHANTOM_PORT.BB_FABRIC_ID, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN,

VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED

from

PHANTOM_PORT,

VIRTUAL_SWITCH where

PHANTOM_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID;

PRODUCT_INFO

CREATE VIEW product_info AS select distinct

TEMP_DEVICE.DEVICE_ID,

TEMP_DEVICE.MANAGED_ELEMENT_ID, TEMP_DEVICE.ALIAS_NAME, TEMP_DEVICE.HOST_NAME, TEMP_DEVICE.OPER_STATUS,

case

when TEMP_DEVICE.OPER_STATUS = 1 then (case

when TEMP_DEVICE.FABRIC_WATCH_STATUS = 2 then 'DEGRADED' when TEMP_DEVICE.FABRIC_WATCH_STATUS = 3 then 'DOWN' else 'REACHABLE'

Brocade Network Advisor IP User Manual	1639
53-1003056-01