
Brocade Network Advisor SAN User Manual
1803
53-1003154-01
Views
H
FABRIC_MEMBER DEST_FABRIC_MEMBER,
VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH,
SWITCH_PORT DEST_SWITCH_PORT,
FABRIC
where
SOURCE_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID
and
SOURCE_VIRTUAL_SWITCH.DOMAIN_ID = ISL.SOURCE_DOMAIN_ID and
SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and
SOURCE_SWITCH_PORT.CATEGORY = 1 and
SOURCE_SWITCH_PORT.USER_PORT_NUMBER = ISL.SOURCE_PORT_NUMBER and
DEST_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and
DEST_VIRTUAL_SWITCH.ID = DEST_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and
DEST_VIRTUAL_SWITCH.DOMAIN_ID = ISL.DEST_DOMAIN_ID and
DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID = DEST_VIRTUAL_SWITCH.ID and
DEST_SWITCH_PORT.CATEGORY = 1 and
DEST_SWITCH_PORT.USER_PORT_NUMBER = ISL.DEST_PORT_NUMBER and
FABRIC.ID = ISL.FABRIC_ID;
ISL_REPORT_INFO
CREATE OR REPLACE VIEW ISL_REPORT_INFO AS
SELECT ISL.ID, ISL.FABRIC_ID, ISL.COST, ISL.TYPE, ISL.TRUSTED,
ISL.CREATION_TIME, ISL.MISSING, ISL.MISSING_TIME, ISL.TRUNKED,
ISL.MISSING_REASON,
ISL.SOURCE_DOMAIN_ID, ISL.SOURCE_PORT_NUMBER,
SOURCE_VIRTUAL_SWITCH.ID AS SOURCE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.NAME AS SOURCE_SWITCH_NAME,
SOURCE_VIRTUAL_SWITCH.WWN AS SOURCE_SWITCH_WWN,
SOURCE_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID AS SOURCE_SWITCH_VIRTUAL_FABRIC_ID,
SOURCE_VIRTUAL_SWITCH.OPERATIONAL_STATUS AS SOURCE_SWITCH_OPERATIONAL_STATUS,
SOURCE_VIRTUAL_SWITCH.STATE AS SOURCE_SWITCH_STATE,
SOURCE_VIRTUAL_SWITCH.STATUS AS SOURCE_SWITCH_STATUS,
SOURCE_VIRTUAL_SWITCH.STATUS_REASON AS SOURCE_SWITCH_STATUS_REASON,
SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID AS SOURCE_CORE_SWITCH_ID,
SOURCE_VIRTUAL_SWITCH.BASE_SWITCH AS SOURCE_BASE_SWITCH,
SOURCE_VIRTUAL_SWITCH.MANAGEMENT_STATE AS
SOURCE_VIRTUAL_SWITCH_MANAGEMENT_STATE,
SOURCE_VIRTUAL_SWITCH.MONITORED AS SOURCE_VIRTUAL_SWITCH_MONITORED,
SOURCE_CORE_SWITCH.IP_ADDRESS AS SOURCE_CORE_SWITCH_IP_ADDRESS,
SOURCE_CORE_SWITCH.WWN AS SOURCE_CORE_SWITCH_WWN,
SOURCE_CORE_SWITCH.NAME AS SOURCE_CORE_SWITCH_NAME,
SOURCE_CORE_SWITCH.TYPE AS SOURCE_CORE_SWITCH_TYPE,
SOURCE_CORE_SWITCH.OPERATIONAL_STATUS AS
SOURCE_CORE_SWITCH_OPERATIONAL_STATUS,
SOURCE_CORE_SWITCH.MODEL AS SOURCE_CORE_SWITCH_MODEL,
SOURCE_CORE_SWITCH.VENDOR AS SOURCE_CORE_SWITCH_VENDOR,
SOURCE_CORE_SWITCH.REACHABLE AS SOURCE_CORE_SWITCH_REACHABLE,
SOURCE_SWITCH_PORT.ID AS SOURCE_SWITCH_PORT_ID,
SOURCE_SWITCH_PORT.WWN AS SOURCE_SWITCH_PORT_WWN,
SOURCE_SWITCH_PORT.NAME AS SOURCE_SWITCH_PORT_NAME,
SOURCE_SWITCH_PORT.SLOT_NUMBER AS SOURCE_SWITCH_PORT_SLOT_NUMBER,
SOURCE_SWITCH_PORT.PORT_NUMBER AS SOURCE_SWITCH_PORT_PORT_NUMBER,
SOURCE_SWITCH_PORT.PORT_ID AS SOURCE_SWITCH_PORT_PORT_ID,
SOURCE_SWITCH_PORT.PORT_INDEX AS SOURCE_SWITCH_PORT_PORT_INDEX,
SOURCE_SWITCH_PORT.AREA_ID AS SOURCE_SWITCH_PORT_AREA_ID,
SOURCE_SWITCH_PORT.MAC_ADDRESS AS SOURCE_SWITCH_PORT_MAC_ADDRESS,
SOURCE_SWITCH_PORT.STATUS AS SOURCE_SWITCH_PORT_STATUS,
Содержание 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...