Brocade Network Advisor IP User Manual 1629
53-1003056-01
Views I
HBA_PORT_FCOE_DETAILS.BANDWIDTH as FCOE_BANDWIDTH,
HBA_PORT_FCOE_DETAILS.FIP_STATE,
HBA_PORT_FCOE_DETAILS.DISCOVERY_PRIORITY,
HBA_PORT_FCOE_DETAILS.FCF_FCMAP,
HBA_PORT_FCOE_DETAILS.FCF_FPMA_MAC,
HBA_PORT_FCOE_DETAILS.FCF_MAC,
HBA_PORT_FCOE_DETAILS.FCF_MODE,
HBA_PORT_FCOE_DETAILS.FCF_NAMEID,
HBA_PORT_FCOE_DETAILS.FCPIM_MPIO_MODE,
HBA_PORT_FCOE_DETAILS.PORT_LOG_ENABLED,
HBA_PORT_FCOE_DETAILS.MAX_FRAME_SIZE as FCOE_MAX_FRAME_SIZE,
HBA_PORT_FCOE_DETAILS.MTU as FCOE_MTU,
HBA_PORT_FCOE_DETAILS.PATH_TOV as FCOE_PATH_TOV,
HBA_PORT_FCOE_DETAILS.SCSI_QUEUE_DEPTH as FCOE_SCSI_QUEUE_DEPTH,
HBA_PORT_FCOE_DETAILS.STATE as FCOE_STATE,
HBA_PORT_FCOE_DETAILS.SUPPORTED_CLASS as FCOE_SUPPORTED_CLASS,
HBA_PORT_FCOE_DETAILS.TRL_SPEED as FCOE_TRL_SPEED,
HBA_PORT_FCOE_DETAILS.TRL_STATE as FCOE_TRL_STATE,
HBA_PORT_FCOE_DETAILS.PG_ID as FCOE_PG_ID,
HBA_PORT_FCOE_DETAILS.PRIORITIES as FCOE_PRIORITIES,
HBA_PORT_FCOE_DETAILS.FCOE_MAC,
HBA_PORT.SYNTHETIC_FC,
HBA_PORT_DETAIL.ALARM_WARNING,
HBA_PORT_DETAIL.IO_EXEC_THROTTLE_MAX,
HBA_PORT_DETAIL.IO_EXEC_THROTTLE_OPERATIONAL,
HBA_PORT_DETAIL.IO_EXEC_THROTTLE_CONFIGURED,
HBA_PORT_DETAIL.BOOTUP_DELAY,
HBA_PORT_DETAIL.FEC_STATE,
HBA_PORT_DETAIL.BB_CREDIT_RECOVERY_STATUS,
HBA_PORT_DETAIL.CONFIGURED_BB_SCN_COUNT,
HBA_PORT_DETAIL.NEGOTIATED_BB_SCN_COUNT
from
HBA_PORT
left outer join HBA_PORT_DETAIL
on HBA_PORT.DEVICE_PORT_ID = HBA_PORT_DETAIL.DEVICE_PORT_ID
left outer join HBA_PORT_FCOE_DETAILS
on HBA_PORT.DEVICE_PORT_ID = HBA_PORT_FCOE_DETAILS.DEVICE_PORT_ID;
HBA_TARGET_INFO
create or replace view HBA_TARGET_INFO as
select
HBA_TARGET.DEVICE_PORT_ID,
HBA_TARGET.HBA_REMOTE_PORT_LUN_ID,
HBA_TARGET.BOOT_LUN,
HBA_TARGET.TRUSTED,
HBA_TARGET.CREATION_TIME,
HBA_TARGET.MISSING,
HBA_TARGET.MISSING_TIME,
HBA_TARGET.TARGET_ID as HBA_PORT_TARGET_ID,
HBA_REMOTE_PORT.ID as HBA_REMOTE_PORT_ID,
HBA_REMOTE_PORT.SYMBOLIC_NAME,
HBA_REMOTE_PORT.PORT_WWN,
HBA_REMOTE_PORT.NODE_WWN,
HBA_REMOTE_PORT.NAME,
HBA_REMOTE_PORT.FC_ADDRESS,
HBA_REMOTE_PORT.FRAME_DATA_SIZE,
HBA_REMOTE_PORT.SPEED,
HBA_REMOTE_PORT.STATE,