HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 197
Hba_target_info, On Hba_port.device_port_id = Hba_port_fcoe_details.device_port_id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 197 highlights
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, Brocade Network Advisor Documentation Updates 189 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/197.png)