Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1830 / 1940

1778 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
SP.NAME as SWITCH_PORT_NAME, SP.LOGICAL_PORT_WWN, SP.VIRTUAL_SWITCH_ID,
CS.IP_ADDRESS as SWITCH_IP_ADDRESS,
coalesce(USER_DEFINED_DEVICE_DETAIL.TYPE, DN.TYPE, ''::character varying) as
USER_DEFINED_DEVICE_TYPE,
USER_DEFINED_DEVICE_DETAIL.NAME as USER_DEFINED_NAME,
USER_DEFINED_DEVICE_DETAIL.IP_ADDRESS as USER_DEFINED_IP_ADDRESS,
USER_DEFINED_DEVICE_DETAIL.CONTACT,
USER_DEFINED_DEVICE_DETAIL.LOCATION,
USER_DEFINED_DEVICE_DETAIL.DESCRIPTION
from DEVICE_PORT DP
join DEVICE_NODE DN on DP.NODE_ID = DN.ID
left join USER_DEFINED_DEVICE_DETAIL on DN.WWN = USER_DEFINED_DEVICE_DETAIL.WWN
left join SWITCH_PORT SP on DP.SWITCH_PORT_WWN = SP.WWN
left join VIRTUAL_SWITCH VS on SP.VIRTUAL_SWITCH_ID = VS.ID
left join CORE_SWITCH CS on VS.CORE_SWITCH_ID = CS.ID
left join FABRIC F on DN.FABRIC_ID = F.ID
where DN.AG <> 1 and F.MANAGED = 1 and (F.TYPE <> all (array[65, 66, 4])) and
(SP.LICENSED is null or SP.LICENSED = 1) and (VS.MONITORED is null or
VS.MONITORED = 1) and (VS.SWITCH_MODE is null or (VS.SWITCH_MODE = any (array[0,
2])));
DEV_PORT_GIGE_PORT_LINK_INFO
create or replace view DEV_PORT_GIGE_PORT_LINK_INFO as
select
DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID,
DEVICE_PORT_GIGE_PORT_LINK.GIGE_PORT_ID,
DEVICE_PORT_GIGE_PORT_LINK.DIRECT_ATTACH,
DEVICE_PORT_GIGE_PORT_LINK.VIRTUAL_FCOE_PORT_ID,
DEVICE_PORT.TRUSTED,
DEVICE_PORT.CREATION_TIME,
DEVICE_PORT.MISSING,
DEVICE_PORT.MISSING_TIME,
DEVICE_PORT_GIGE_PORT_LINK.LAG_ID
from
DEVICE_PORT_GIGE_PORT_LINK,
DEVICE_PORT
where
DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID = DEVICE_PORT.ID;
DEV_PORT_MAC_ADDR_MAP_INFO
create or replace view DEV_PORT_MAC_ADDR_MAP_INFO as
select
DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID,
DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS,
DEVICE_NODE.ID as DEVICE_NODE_ID,
DEVICE_NODE.FABRIC_ID,
DEVICE_PORT.TRUSTED,
DEVICE_PORT.CREATION_TIME,
DEVICE_PORT.MISSING,
DEVICE_PORT.MISSING_TIME
from
DEVICE_PORT_MAC_ADDRESS_MAP,
DEVICE_PORT,
DEVICE_NODE
where
DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID = DEVICE_PORT.ID