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

1812 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
END_DEVICE_PORT.HARDWARE_ADDRESS,
END_DEVICE_PORT.TRUSTED as DEVICE_PORT_TRUSTED,
END_DEVICE_PORT.CREATION_TIME as DEVICE_PORT_CREATION_TIME,
END_DEVICE_PORT.MISSING as DEVICE_PORT_MISSING,
END_DEVICE_PORT.MISSING_TIME as DEVICE_PORT_MISSING_TIME,
END_DEVICE_PORT.LOGGED_TO_AG,
END_DEVICE_PORT.AG_NODE_WWN,
END_DEVICE_PORT.AG_N_PORT_WWN As AG_SWITCH_N_PORT_WWN,
END_DEVICE_PORT.MISSING_REASON
from N2F_PORT_MAP
left join SWITCH_PORT AG_F_PORT on AG_F_PORT.USER_PORT_NUMBER =
N2F_PORT_MAP.F_PORT AND N2F_PORT_MAP.VIRTUAL_SWITCH_ID =
AG_F_PORT.VIRTUAL_SWITCH_ID
left join VIRTUAL_SWITCH AG_SWITCH on AG_F_PORT.VIRTUAL_SWITCH_ID = AG_SWITCH.ID
AND AG_SWITCH.MONITORED = 1
left join CORE_SWITCH AG_PHYSICAL_SWITCH on AG_SWITCH.CORE_SWITCH_ID =
AG_PHYSICAL_SWITCH.ID
left join CORE_SWITCH_DETAILS AG_PHYSICAL_SWITCH_DETAILS on
AG_SWITCH.CORE_SWITCH_ID = AG_PHYSICAL_SWITCH_DETAILS.CORE_SWITCH_ID
left join DEVICE_PORT END_DEVICE_PORT on AG_F_PORT.REMOTE_PORT_WWN =
END_DEVICE_PORT.WWN and AG_F_PORT.WWN = END_DEVICE_PORT.SWITCH_PORT_WWN
left join DEVICE_NODE END_DEVICE_NODE on END_DEVICE_PORT.NODE_ID =
END_DEVICE_NODE.ID
left join USER_DEFINED_DEVICE_DETAIL on END_DEVICE_NODE.WWN =
USER_DEFINED_DEVICE_DETAIL.WWN
left join SWITCH_PORT AG_N_PORT on AG_N_PORT.USER_PORT_NUMBER =
N2F_PORT_MAP.N_PORT AND N2F_PORT_MAP.VIRTUAL_SWITCH_ID =
AG_N_PORT.VIRTUAL_SWITCH_ID
left join SWITCH_PORT EDGE_SWITCH_PORT on AG_N_PORT.REMOTE_PORT_WWN =
EDGE_SWITCH_PORT.WWN
left join VIRTUAL_SWITCH EDGE_SWITCH on EDGE_SWITCH_PORT.VIRTUAL_SWITCH_ID =
EDGE_SWITCH.ID
left join CORE_SWITCH EDGE_PHYSICAL_SWITCH on EDGE_SWITCH.CORE_SWITCH_ID =
EDGE_PHYSICAL_SWITCH.ID
left join CORE_SWITCH_DETAILS EDGE_PHYSICAL_SWITCH_DETAILS on
EDGE_SWITCH.CORE_SWITCH_ID = EDGE_PHYSICAL_SWITCH_DETAILS.CORE_SWITCH_ID
left join FABRIC_MEMBER EDGE_FABRIC_MEMBER ON EDGE_SWITCH.ID =
EDGE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID
left join FABRIC EDGE_FABRIC on EDGE_FABRIC_MEMBER.FABRIC_ID = EDGE_FABRIC.ID AND
EDGE_FABRIC.MANAGED = 1;
MODULE_INFO
CREATE VIEW module_info AS
select distinct
TEMP_MODULE.MODULE_ID,
TEMP_MODULE.NUM_PORTS,
TEMP_MODULE.IS_PRESENT,
case
when TEMP_MODULE.IS_PRESENT = 1 then 'YES'
else 'NO'
end as IS_PRESENT_TXT,
TEMP_MODULE.IS_MANAGEMENT_MODULE,
case
when TEMP_MODULE.IS_MANAGEMENT_MODULE = 1 then 'YES'
else 'NO'
end as IS_MANAGEMENT_MODULE_TXT,