Views I

SWITCH_INFO.STATUS as VIRTUAL_SWITCH_STATUS, SWITCH_INFO.FABRIC_ID, SWITCH_INFO.MONITORED, SWITCH_INFO.CRYPTO_CAPABLE

from

DEVICE_NODE, DEVICE_PORT, SWITCH_PORT, SWITCH_INFO where

DEVICE_PORT.NODE_ID = DEVICE_NODE.ID and

DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and SWITCH_PORT.VIRTUAL_SWITCH_ID = SWITCH_INFO.ID and

DEVICE_NODE.FABRIC_ID = SWITCH_INFO.FABRIC_ID;

N2F_PORT_MAP_INFO

create or replace view N2F_PORT_MAP_INFO as select

N2F_PORT_MAP.VIRTUAL_SWITCH_ID, N2F_PORT_MAP.N_PORT, N2F_PORT_MAP.F_PORT,

AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN, AG_N_PORT.WWN as AG_N_PORT_WWN,

AG_F_PORT.WWN as AG_F_PORT_WWN, AG_F_PORT.REMOTE_NODE_WWN, AG_F_PORT.REMOTE_PORT_WWN as DEVICE_PORT_WWN

from

N2F_PORT_MAP,

SWITCH_PORT AG_N_PORT,

SWITCH_PORT AG_F_PORT,

VIRTUAL_SWITCH AG_SWITCH where

N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_N_PORT.VIRTUAL_SWITCH_ID and N2F_PORT_MAP.N_PORT = AG_N_PORT.USER_PORT_NUMBER

and N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_F_PORT.VIRTUAL_SWITCH_ID and N2F_PORT_MAP.F_PORT = AG_F_PORT.USER_PORT_NUMBER

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

DEVICE_NODE_INFO

create or replace view DEVICE_NODE_INFO as select

DEVICE_NODE.ID,

DEVICE_NODE.FABRIC_ID, DEVICE_NODE.WWN, DEVICE_NODE.TYPE, DEVICE_NODE.DEVICE_TYPE, DEVICE_NODE.SYMBOLIC_NAME, DEVICE_NODE.FDMI_HOST_NAME, DEVICE_NODE.VENDOR, DEVICE_NODE.CAPABILITY_, DEVICE_NODE.TRUSTED, DEVICE_NODE.CREATION_TIME, DEVICE_NODE.MISSING, DEVICE_NODE.MISSING_TIME, DEVICE_NODE.PROXY_DEVICE, DEVICE_NODE.AG,

DEVICE_NODE.PREVIOUS_MISSING_STATE, USER_DEFINED_DEVICE_DETAIL.NAME,

Brocade Network Advisor IP User Manual

1615

53-1003056-01

 

Page 1667
Image 1667
Brocade Communications Systems IP250 user manual N2FPORTMAPINFO, Devicenodeinfo, Devicenode.Fabricid = Switchinfo.Fabricid