Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1697)

Brocade Network Advisor IP User Manual 1643
53-1002947-01
Views
I
HBA_PORT_DETAIL.QOS_LOW_BW_ALLOCATION,
HBA_PORT_DETAIL.MEDIA as MEDIA,
HBA_PORT_DETAIL.IOC_ID as IOC_ID,
HBA_PORT_DETAIL.PREBOOT_DISABLED,
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,