
Brocade Network Advisor SAN User Manual
1853
53-1003154-01
Views
H
FABRIC.MANAGED as FABRIC_MANAGED
from
VR_CONN_MODULE
inner join
VR_CONN_DOMAIN on
VR_CONN_DOMAIN.ID = VR_CONN_MODULE.VR_CONN_DOMAIN_ID
inner join
VCEM_PROFILE on
VCEM_PROFILE.ID = VR_CONN_DOMAIN.VCEM_PROFILE_ID
left outer join
VR_CONN_DOMAIN_GROUP on
VR_CONN_DOMAIN_GROUP.ID = VR_CONN_DOMAIN.VR_CONN_DOMAIN_GROUP_ID
left outer join
VIRTUAL_SWITCH on
VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN
left outer join
CORE_SWITCH on
CORE_SWITCH.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID
left outer join
DEVICE_NODE on
DEVICE_NODE.WWN = VR_CONN_MODULE.WWN
left outer join
FABRIC on
DEVICE_NODE.FABRIC_ID = FABRIC.ID;
VR_CONN_MODULE_PORT_INFO
create or replace view VR_CONN_MODULE_PORT_INFO as
select
VR_CONN_MODULE_PORT.ID,
VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID,
VR_CONN_MODULE_PORT.WWN,
VR_CONN_MODULE_PORT.POSITION_,
VR_CONN_MODULE_PORT.FABRIC_NAME,
VR_CONN_MODULE_PORT.SPEED,
VR_CONN_MODULE_PORT.STATUS,
VR_CONN_MODULE_PORT.LAST_STATUS,
VR_CONN_MODULE_PORT.REMOTE_NODE_WWN,
VR_CONN_MODULE_PORT.CREATION_TIME,
VR_CONN_MODULE_PORT.LAST_UPDATE_TIME,
VR_CONN_MODULE.IO_BAY,
VR_CONN_DOMAIN.ID as VR_CONN_DOMAIN_ID,
VCEM_PROFILE.ID as VCEM_PROFILE_ID,
SWITCH_PORT.ID as SWITCH_PORT_ID,
VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID
from
VR_CONN_MODULE_PORT
inner join
VR_CONN_MODULE on
VR_CONN_MODULE.ID = VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID
inner join
VR_CONN_DOMAIN on
VR_CONN_DOMAIN.ID = VR_CONN_MODULE.VR_CONN_DOMAIN_ID
inner join
VCEM_PROFILE on
VCEM_PROFILE.ID = VR_CONN_DOMAIN.VCEM_PROFILE_ID
left outer join
SWITCH_PORT on
SWITCH_PORT.WWN = VR_CONN_MODULE_PORT.WWN
Summary of Contents for Network Advisor 12.3.0
Page 4: ...iv Brocade Network Advisor SAN User Manual 53 1003154 01...
Page 86: ...34 Brocade Network Advisor SAN User Manual 53 1003154 01 Uninstalling a patch 2...
Page 190: ...138 Brocade Network Advisor SAN User Manual 53 1003154 01 Fabric tracking 4...
Page 216: ...164 Brocade Network Advisor SAN User Manual 53 1003154 01 User profiles 5...
Page 612: ...560 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting Host port mapping 13...
Page 620: ...568 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting storage port mapping 14...
Page 720: ...668 Brocade Network Advisor SAN User Manual 53 1003154 01 Security configuration deployment 17...
Page 744: ...692 Brocade Network Advisor SAN User Manual 53 1003154 01 Configuring Virtual Fabrics 19...
Page 1068: ...1016 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing thresholds 24...
Page 1098: ...1046 Brocade Network Advisor SAN User Manual 53 1003154 01 Swapping blades 25...
Page 1176: ...1124 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN connection utilization 28...
Page 1378: ...1326 Brocade Network Advisor SAN User Manual 53 1003154 01 Event logs 32...
Page 1448: ...1396 Brocade Network Advisor SAN User Manual 53 1003154 01 Upload failure data capture 34...
Page 1490: ...1438 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN shortcut menus A...
Page 1494: ...1442 Brocade Network Advisor SAN User Manual 53 1003154 01 Call Home Event Tables B...
Page 1524: ...1472 Brocade Network Advisor SAN User Manual 53 1003154 01 About Roles and Access Levels D...
Page 1552: ...1500 Brocade Network Advisor SAN User Manual 53 1003154 01 Regular Expressions F...
Page 1920: ...1868 Brocade Network Advisor SAN User Manual 53 1003154 01 Views H...