Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1829)

Brocade Network Advisor SAN User Manual 1777
53-1003154-01
Views
H
coalesce(VS1.MONITORED, VS2.MONITORED) as MONITORED,
FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_WWN,
FABRIC.ID as FABRIC_ID
from
DEVICE_PORT
left outer join USER_DEFINED_DEVICE_DETAIL
on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN
left outer join FICON_DEVICE_PORT
on DEVICE_PORT.ID = FICON_DEVICE_PORT.DEVICE_PORT_ID
left outer join DEVICE_NODE
on DEVICE_PORT.NODE_ID = DEVICE_NODE.ID
left outer join SWITCH_PORT
on DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN
left outer join VIRTUAL_FCOE_PORT
on DEVICE_PORT.SWITCH_PORT_WWN = VIRTUAL_FCOE_PORT.PORT_WWN
left outer join VIRTUAL_SWITCH VS1
on SWITCH_PORT.VIRTUAL_SWITCH_ID = VS1.ID
left outer join VIRTUAL_SWITCH VS2
on VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VS2.ID
left outer join FABRIC
on DEVICE_NODE.FABRIC_ID = FABRIC.ID;
DEVICE_REPORT_INFO
create or replace view DEVICE_REPORT_INFO as
select VS.NAME as VIRTUAL_SWITCH_NAME, VS.WWN as VIRTUAL_SWITCH_WWN,
VS.MANAGEMENT_STATE, VS.MONITORED, VS.SWITCH_MODE,
coalesce(F.NAME, F.FABRIC_NAME) as FABRIC_NAME, F.MANAGED as FABRIC_MANAGED,
F.TYPE as FABRIC_TYPE, F.SEED_SWITCH_WWN,
F.PRINCIPAL_SWITCH_WWN as PRINCIPAL_WWN, DN.ID as DEVICE_NODE_ID,
DN.FABRIC_ID, DN.SYMBOLIC_NAME as DEVICE_NODE_SYMBOLIC_NAME,
DN.TYPE as DEVICE_NODE_TYPE, DN.FDMI_HOST_NAME, DN.VENDOR, DN.CAPABILITY_,
DN.TRUSTED as DEVICE_NODE_TRUSTED,
DN.CREATION_TIME as DEVICE_NODE_CREATION_TIME,
DN.MISSING as DEVICE_NODE_MISSING,
DN.MISSING_TIME as DEVICE_NODE_MISSING_TIME, DN.PROXY_DEVICE, DN.AG,
DN.PREVIOUS_MISSING_STATE, DN.SIMULATED, DN.WWN as DEVICE_NODE_WWN,
DP.WWN as DEVICE_PORT_WWN, DP.PORT_ID as DEVICE_PORT_FC_ADDRESS,
DP.NUMBER as DEVICE_PORT_NUMBER, DP.ID as DEVICE_PORT_ID, DP.DOMAIN_ID,
DP.TYPE as DEVICE_PORT_TYPE, DP.SYMBOLIC_NAME as DEVICE_PORT_SYMBOLIC_NAME,
DP.FC4_TYPE, DP.COS, DP.IP_PORT, DP.NPV_PHYSICAL, DP.HARDWARE_ADDRESS,
DP.TRUSTED as DEVICE_PORT_TRUSTED, DP.EDGE_SWITCH_PORT_WWN,
DP.CREATION_TIME as DEVICE_PORT_CREATION_TIME,
DP.MISSING as DEVICE_PORT_MISSING,
DP.MISSING_TIME as DEVICE_PORT_MISSING_TIME, DP.LOGGED_TO_AG,
DP.AG_NODE_WWN, DP.AG_N_PORT_WWN, DP.MISSING_REASON,
case
when DP.NPV_PHYSICAL = 0 then 'PHYSICAL'::text
when DP.NPV_PHYSICAL = 1 then 'VIRTUAL'::text
when DP.NPV_PHYSICAL = 2 then 'NPIV'::text
when DP.NPV_PHYSICAL = 3 then 'ISCSI'::text
when DP.NPV_PHYSICAL = 4 then 'PHY+VIR'::text
else ''::text
end as DEVICE_TYPE,
DP.SWITCH_PORT_WWN, SP.ID as SWITCH_PORT_ID,
SP.STATUS as SWITCH_PORT_STATUS, SP.SLOT_NUMBER as SWITCH_PORT_SLOT_NUMBER,
SP.PORT_NUMBER as SWITCH_PORT_PORT_NUMBER,
SP.PORT_ID as SWITCH_PORT_FC_ADDRESS, SP.PORT_INDEX,
SP.SPEED as SWITCH_PORT_SPEED, SP.TYPE as SWITCH_PORT_TYPE, SP.LICENSED,