I Views

USER_DEFINED_DEVICE_DETAIL.TYPE as USER_DEFINED_TYPE,

USER_DEFINED_DEVICE_DETAIL.IP_ADDRESS, USER_DEFINED_DEVICE_DETAIL.CONTACT, USER_DEFINED_DEVICE_DETAIL.LOCATION, USER_DEFINED_DEVICE_DETAIL.DESCRIPTION, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE1, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE2, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE3, FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_WWN,

DEVICE_FDMI_DETAILS.SERIAL_NUMBER AS FDMI_SERIAL_NUMBER, DEVICE_FDMI_DETAILS.FIRMWARE_VERSION AS FDMI_FIRMWARE_VERSION, DEVICE_FDMI_DETAILS.DRIVER_VERSION AS FDMI_DRIVER_VERSION, DEVICE_FDMI_DETAILS.MANUFACTURER AS FDMI_MANUFACTURER, DEVICE_FDMI_DETAILS.MODEL AS FDMI_MODEL, DEVICE_FDMI_DETAILS.HARDWARE_VERSION AS FDMI_HARDWARE_VERSION, DEVICE_FDMI_DETAILS.MODEL_DESCRIPTION AS FDMI_MODEL_DESCRIPTION, DEVICE_FDMI_DETAILS.NODE_NAME AS FDMI_NODE_NAME

from

DEVICE_NODE

left outer join USER_DEFINED_DEVICE_DETAIL

on DEVICE_NODE.WWN = USER_DEFINED_DEVICE_DETAIL.WWN left outer join FABRIC

on DEVICE_NODE.FABRIC_ID = FABRIC.ID left outer join DEVICE_FDMI_DETAILS

on DEVICE_NODE.ID = DEVICE_FDMI_DETAILS.DEVICE_NODE_ID;

DEVICE_PORT_INFO

CREATE VIEW device_port_info AS select

DEVICE_PORT.ID, DEVICE_PORT.NODE_ID,

DEVICE_PORT.DOMAIN_ID, DEVICE_PORT.WWN, DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.NUMBER, DEVICE_PORT.PORT_ID,

DEVICE_PORT.TYPE,

DEVICE_PORT.SYMBOLIC_NAME, DEVICE_PORT.FC4_TYPE,

DEVICE_PORT.COS, DEVICE_PORT.IP_PORT,

DEVICE_PORT.HARDWARE_ADDRESS, DEVICE_PORT.TRUSTED, DEVICE_PORT.CREATION_TIME, DEVICE_PORT.MISSING, DEVICE_PORT.MISSING_TIME, DEVICE_PORT.NPV_PHYSICAL, DEVICE_PORT.EDGE_SWITCH_PORT_WWN, DEVICE_PORT.LOGGED_TO_AG, DEVICE_PORT.AG_NODE_WWN, DEVICE_PORT.AG_N_PORT_WWN,

DEVICE_PORT.MISSING_REASON, FICON_DEVICE_PORT.TYPE_NUMBER, FICON_DEVICE_PORT.MODEL_NUMBER, FICON_DEVICE_PORT.MANUFACTURER, FICON_DEVICE_PORT.MANUFACTURER_PLANT, FICON_DEVICE_PORT.SEQUENCE_NUMBER, FICON_DEVICE_PORT.TAG,

1616

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1668
Image 1668
Brocade Communications Systems IP250 user manual Deviceportinfo, Devicenode