
Brocade Network Advisor SAN User Manual
1829
53-1003154-01
Views
H
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_STATE,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_STATUS,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_STATUS_REASON,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_ID,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_IP_ADDRESS,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_WWN,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_NAME,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_TYPE,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_MODEL,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_VENDOR,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_REACHABLE,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_OPERATIONAL_STATUS,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_MODEL_NUMBER,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_MODEL_DESCRIPTION,
USER_DEFINED_DEVICE_DETAIL.NAME as USER_DEFINED_DEVICE_NAME,
USER_DEFINED_DEVICE_DETAIL.IP_ADDRESS as USER_DEFINED_DEVICE_IP_ADDRESS,
USER_DEFINED_DEVICE_DETAIL.CONTACT as USER_DEFINED_DEVICE_CONTACT,
USER_DEFINED_DEVICE_DETAIL.LOCATION as USER_DEFINED_DEVICE_LOCATION,
USER_DEFINED_DEVICE_DETAIL.DESCRIPTION as USER_DEFINED_DEVICE_DESCRIPTION,
PORT_BOTTLENECK_STATUS.STATUS as BOTTLENECK_STATUS,
coalesce(USER_DEFINED_DEVICE_DETAIL.TYPE, DEVPORT_DEVNODE_VIEW.DEVICE_NODE_TYPE,
''::character varying) as USER_DEFINED_DEVICE_TYPE,
coalesce(DEVPORT_DEVNODE_VIEW.DEVICE_NODE_NAME,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_NAME, ''::character varying) as
DEVICE_NAME,
coalesce(DEVPORT_DEVNODE_VIEW.DEVICE_NODE_VENDOR,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_VENDOR, ''::character varying)
as DEVICE_VENDOR,
coalesce(DEVPORT_DEVNODE_VIEW.DEVICE_NODE_TYPE,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_MODEL_DESCRIPTION, ''::CHARACTER
VARYING) as DEVICE_TYPE,
coalesce(SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_CORE_SWITCH_MODEL_NUMBER,
''::character varying) as DEVICE_MODEL,
coalesce(DEVPORT_DEVNODE_VIEW.DEVICE_NODE_WWN,
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_VIRTUAL_SWITCH_WWN, ''::bpchar) as
CONNECTED_DEVICE_OR_SWITCH_WWN
from SWITCH_PORT
join VIRTUAL_SWITCH on SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
join CORE_SWITCH on VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
join FABRIC_MEMBER on VIRTUAL_SWITCH.ID = FABRIC_MEMBER.VIRTUAL_SWITCH_ID
join FABRIC on FABRIC_MEMBER.FABRIC_ID = FABRIC.ID
left join USER_DEFINED_DEVICE_DETAIL on SWITCH_PORT.REMOTE_NODE_WWN::bpchar =
USER_DEFINED_DEVICE_DETAIL.WWN
left join DEVPORT_DEVNODE_VIEW on SWITCH_PORT.WWN =
DEVPORT_DEVNODE_VIEW.DEVICE_PORT_SWITCH_PORT_WWN and
SWITCH_PORT.REMOTE_PORT_WWN::bpchar = DEVPORT_DEVNODE_VIEW.DEVICE_PORT_WWN and
FABRIC.ID = DEVPORT_DEVNODE_VIEW.DEVICE_NODE_FABRIC_ID
left join SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW on SWITCH_PORT.REMOTE_PORT_WWN is not
null and SWITCH_PORT.REMOTE_PORT_WWN::TEXT<> ''::TEXT and SWITCH_PORT.WWN is not
null and SWITCH_PORT.WWN <> ''::bpchar and SWITCH_PORT.REMOTE_PORT_WWN::bpchar =
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_SWITCH_PORT_WWN and SWITCH_PORT.WWN =
SWPRT_VSW_CSW_CSWDET_SWMDL_VIEW.REMOTE_REMOTE_PORT_WWN::bpchar
left join PORT_BOTTLENECK_STATUS on PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID =
SWITCH_PORT.ID
where SWITCH_PORT.LICENSED = 1 and SWITCH_PORT.PHYSICAL_PORT = 1 and
SWITCH_PORT.KIND::text<> 'ICL'::text and ((SWITCH_PORT.TYPE::text= any
(array['E-Port'::character varying, 'G-Port'::character varying,
'U-Port'::character varying, 'F-Port'::character varying, 'L-Port'::character
varying, 'EX-Port'::character varying, 'LB-Port'::character varying,
'FL-Port'::character varying, 'SIM-Port'::character varying, 'N-Port'::character
Содержание Network Advisor 12.3.0
Страница 1: ...53 1003154 01 11 July 2014 Brocade Network Advisor SAN User Manual Supporting Network Advisor 12 3 0...
Страница 4: ...iv Brocade Network Advisor SAN User Manual 53 1003154 01...
Страница 86: ...34 Brocade Network Advisor SAN User Manual 53 1003154 01 Uninstalling a patch 2...
Страница 190: ...138 Brocade Network Advisor SAN User Manual 53 1003154 01 Fabric tracking 4...
Страница 216: ...164 Brocade Network Advisor SAN User Manual 53 1003154 01 User profiles 5...
Страница 462: ...410 Brocade Network Advisor SAN User Manual 53 1003154 01 Searching for an assigned event filter 9...
Страница 478: ...426 Brocade Network Advisor SAN User Manual 53 1003154 01 Microsoft System Center Operations Manager SCOM plug in 10...
Страница 612: ...560 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting Host port mapping 13...
Страница 620: ...568 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting storage port mapping 14...
Страница 720: ...668 Brocade Network Advisor SAN User Manual 53 1003154 01 Security configuration deployment 17...
Страница 744: ...692 Brocade Network Advisor SAN User Manual 53 1003154 01 Configuring Virtual Fabrics 19...
Страница 1036: ...984 Brocade Network Advisor SAN User Manual 53 1003154 01 Troubleshooting FCIP Ethernet connections 22...
Страница 1068: ...1016 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing thresholds 24...
Страница 1098: ...1046 Brocade Network Advisor SAN User Manual 53 1003154 01 Swapping blades 25...
Страница 1104: ...1052 Brocade Network Advisor SAN User Manual 53 1003154 01 Searching the configuration snapshots 26...
Страница 1176: ...1124 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN connection utilization 28...
Страница 1282: ...1230 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing a frame monitor from a switch 30...
Страница 1306: ...1254 Brocade Network Advisor SAN User Manual 53 1003154 01 Viewing historical reports for a configuration policy manager 31...
Страница 1378: ...1326 Brocade Network Advisor SAN User Manual 53 1003154 01 Event logs 32...
Страница 1432: ...1380 Brocade Network Advisor SAN User Manual 53 1003154 01 MAPS integration with other features 33...
Страница 1448: ...1396 Brocade Network Advisor SAN User Manual 53 1003154 01 Upload failure data capture 34...
Страница 1490: ...1438 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN shortcut menus A...
Страница 1494: ...1442 Brocade Network Advisor SAN User Manual 53 1003154 01 Call Home Event Tables B...
Страница 1524: ...1472 Brocade Network Advisor SAN User Manual 53 1003154 01 About Roles and Access Levels D...
Страница 1552: ...1500 Brocade Network Advisor SAN User Manual 53 1003154 01 Regular Expressions F...
Страница 1920: ...1868 Brocade Network Advisor SAN User Manual 53 1003154 01 Views H...