Brocade Communications Systems IP250 user manual Iflinfo, Hostdiscoveryrequest

I Views

DEVICE_ENCLOSURE.MISSING, DEVICE_ENCLOSURE.MISSING_TIME, DEVICE_ENCLOSURE.HOST_NAME, DEVICE_ENCLOSURE.SYSLOG_REGISTERED, DEVICE_ENCLOSURE.VIRTUALIZATION, DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID, HOST_DISCOVERY_REQUEST.MANAGEMENT_STATE_DETAILS

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, ISL.SOURCE_DOMAIN_ID,

ISL.SOURCE_PORT_NUMBER, ISL.MISSING,

SOURCE_VIRTUAL_SWITCH.ID as SOURCE_SWITCH_ID, SOURCE_VIRTUAL_SWITCH.NAME as SOURCE_SWITCH_NAME, SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN, SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID as SOURCE_CORE_SWITCH_ID, SOURCE_VIRTUAL_SWITCH.BASE_SWITCH as SOURCE_BASE_SWITCH, SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE as

SOURCE_VIRTUAL_SWITCH_MANAGEMENT_STATE, SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_VIRTUAL_SWITCH_MONITORED, SOURCE_SWITCH_PORT.ID as SOURCE_SWITCH_PORT_ID,

1632	Brocade Network Advisor IP User Manual
	53-1003056-01