Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

Brocade Network Advisor Documentation Updates 189
53-1002363-02
Views
E
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
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,
HBA_REMOTE_PORT.SUPPORTED_COS,
HBA_REMOTE_PORT.DEVICE_TYPE,
HBA_REMOTE_PORT.BIND_TYPE,
HBA_REMOTE_PORT.TARGET_ID,
HBA_REMOTE_PORT.ROLE,
HBA_REMOTE_PORT.VENDOR,
HBA_REMOTE_PORT.PRODUCT_ID,
HBA_REMOTE_PORT.PRODUCT_VERSION,
HBA_REMOTE_PORT.QOS_PRIORITY,
HBA_REMOTE_PORT.QOS_FLOW_ID,
HBA_REMOTE_PORT.CURRENT_SPEED,
HBA_REMOTE_PORT.TRL_ENFORCED,
HBA_REMOTE_PORT.BUS_NO,
HBA_REMOTE_PORT_LUN.FCP_LUN,
HBA_REMOTE_PORT_LUN.CAPACITY,
HBA_REMOTE_PORT_LUN.BLOCK_SIZE,
HBA_REMOTE_PORT_LUN.VENDOR as LUN_VENDOR,
HBA_REMOTE_PORT_LUN.PRODUCT_ID as LUN_PRODUCT_ID,
HBA_REMOTE_PORT_LUN.PRODUCT_VERSION as LUN_PRODUCT_VERSION,
HBA_REMOTE_PORT_LUN.PRODUCT_SERIAL_NO,