Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1165
53-1002167-01
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,