HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 199
Ifl_info, Host_discovery_request.host_discovery_option_id = Host_discovery_option.id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 199 highlights
Views E DEVICE_ENCLOSURE.SERIAL_NUMBER, DEVICE_ENCLOSURE.FIRMWARE, DEVICE_ENCLOSURE.USER_DEFINED_VALUE1, DEVICE_ENCLOSURE.USER_DEFINED_VALUE2, DEVICE_ENCLOSURE.USER_DEFINED_VALUE3, DEVICE_ENCLOSURE.HCM_AGENT_VERSION, DEVICE_ENCLOSURE.OS_VERSION, DEVICE_ENCLOSURE.CREATED_BY, DEVICE_ENCLOSURE.TRACK_CHANGES, DEVICE_ENCLOSURE.LAST_UPDATE_TIME, DEVICE_ENCLOSURE.LAST_UPDATE_MODULE, DEVICE_ENCLOSURE.TRUSTED, DEVICE_ENCLOSURE.CREATION_TIME, DEVICE_ENCLOSURE.MISSING, DEVICE_ENCLOSURE.MISSING_TIME, DEVICE_ENCLOSURE.HOST_NAME, DEVICE_ENCLOSURE.SYSLOG_REGISTERED, DEVICE_ENCLOSURE.VIRTUALIZATION, DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID from HOST_DISCOVERY_REQUEST join HOST_DISCOVERY_OPTION on HOST_DISCOVERY_REQUEST.HOST_DISCOVERY_OPTION_ID = HOST_DISCOVERY_OPTION.ID left outer join DEVICE_ENCLOSURE on HOST_DISCOVERY_REQUEST.DEVICE_ENCLOSURE_ID = DEVICE_ENCLOSURE.ID; IFL_INFO create or replace view IFL_INFO as select IFL.ID as IFL_ID, IFL.EDGE_FABRIC_ID, (select distinct FCR_PORT.VIRTUAL_SWITCH_ID from SWITCH_PORT FCR_PORT where FCR_PORT.WWN = IFL.BB_PORT_WWN) as FCR_SWITCH_ID, IFL.EDGE_PORT_WWN, IFL.BB_FABRIC_ID, IFL.BB_PORT_WWN , IFL.BB_RA_TOV, IFL.BB_ED_TOV, IFL.BB_PID_FORMAT, SWITCH_PORT.VIRTUAL_SWITCH_ID as EDGE_SWITCH_ID, SWITCH_PORT.ID as EDGE_PORT_ID, SWITCH_PORT.USER_PORT_NUMBER as EDGE_PORT_NUMBER, SWITCH_PORT.TYPE as EDGE_PORT_TYPE from IFL left outer join SWITCH_PORT on IFL.EDGE_PORT_WWN = SWITCH_PORT.WWN; ISL_INFO create or replace view ISL_INFO as select distinct ISL.ID, ISL.FABRIC_ID, ISL.COST, ISL.TYPE, Brocade Network Advisor Documentation Updates 191 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/199.png)