HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 200

192

Brocade Network Advisor Documentation Updates

53-1002363-02

Views

E

ISL.SOURCE_DOMAIN_ID,

ISL.SOURCE_PORT_NUMBER,

ISL.MISSING,

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.CORE_SWITCH_ID as SOURCE_CORE_SWITCH_ID,

SOURCE_VIRTUAL_SWITCH.BASE_SWITCH as SOURCE_BASE_SWITCH,

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.TYPE as PORT_TYPE,

SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND,

SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT,

SOURCE_SWITCH_PORT.TRUNKED as SOURCE_SWITCH_PORT_TRUNKED,

ISL.DEST_DOMAIN_ID,

ISL.DEST_PORT_NUMBER,

DEST_VIRTUAL_SWITCH.ID as DEST_SWITCH_ID,

DEST_VIRTUAL_SWITCH.NAME as DEST_SWITCH_NAME,

DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN,

DEST_VIRTUAL_SWITCH.CORE_SWITCH_ID as DEST_CORE_SWITCH_ID,

DEST_VIRTUAL_SWITCH.BASE_SWITCH as DEST_BASE_SWITCH,

DEST_SWITCH_PORT.ID as DEST_SWITCH_PORT_ID,

DEST_SWITCH_PORT.WWN as DEST_SWITCH_PORT_WWN,

DEST_SWITCH_PORT.NAME as DEST_SWITCH_PORT_NAME,

DEST_SWITCH_PORT.KIND as DEST_SWITCH_PORT_KIND,

DEST_SWITCH_PORT.PHYSICAL_PORT as DEST_PHYSICAL_PORT,

DEST_SWITCH_PORT.TRUNKED as DEST_SWITCH_PORT_TRUNKED,

FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_SWITCH_WWN

from

ISL,

FABRIC_MEMBER SOURCE_FABRIC_MEMBER,

VIRTUAL_SWITCH

SOURCE_VIRTUAL_SWITCH,

SWITCH_PORT

SOURCE_SWITCH_PORT,

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_TRUNK_INFO

create or replace view ISL_TRUNK_INFO as

select

ISL_TRUNK_GROUP.ID,

ISL_INFO.COST,

Section	Page
Contents	3
About This Document	7
In this chapter	7
How this document is organized	7
Document feedback	7
Brocade Network Advisor Installation Guide	9
In this chapter	9
Operating system requirements	9
Brocade Network Advisor Migration Guide	11
In this chapter	11
Operating system requirements	11
Network Advisor migration	11
Brocade Network Advisor SAN User Manual	13
In this chapter	13
Chapter 1, Getting Started	14
Chapter 4, Application Configuration	14
Chapter 8, Third-party tools	15
Chapter 10, SAN Device Configuration	15
Chapter 13, Host Management	17
Deleting a driver file from the repository	17
Chapter 18, SAN Encryption configuration	17
Chapter 19, Zoning	18
Chapter 26, Troubleshooting	18
Chapter 27, Performance Data	18
Chapter 31, Technical Support	19
Appendix E, Database Fields	19
Virtual Connect Enterprise Manager Guide	21
In this chapter	21
VCEM integration support	21
VCEM integration support in SMI-A	21
Database Fields	23
In this appendix	23
Database tables and fields	25
Advanced Call Home	25
Capability	26
Client_view	28
Collector	31
Config	34
Connected end devices	36
Device	37
EE- Monitor	41
Event/FM	43
Fabric	49
FC Port Stats	52
FCIP	56
FCIP Tunnel Stats	57
GigE Port Stats	61
License	66
Encryption Device	69
Encryption Container	75
Meta SAN	79
Network	81
Others	81
Port Fencing	82
Quartz	83
Reports	86
Role Based Access Control	86
SNMP	90
Stats	93
Switch	96
Switch details	99
Switch port	103
Switch SNMP info	108
Threshold	108
User Interface	111
Zoning 2	114
Views	178
BOOT_IMAGE_FILE_DETAILS_INFO	178
CEE_PORT_INFO	178
CNA_PORT_DETAILS_INFO	179
CNA_PORT_INFO	179
CORE_SWITCH_DETAILS_INFO	180
CRYPTO_HOST_LUN_INFO	181
CRYPTO_TARGET_ENGINE_INFO	182
SWITCH_INFO	182
DEVICE_INFO	184
N2F_PORT_MAP_INFO	185
DEVICE_NODE_INFO	186
DEVICE_PORT_INFO	186
DEV_PORT_GIGE_PORT_LINK_INFO	188
DEV_PORT_MAC_ADDR_MAP_INFO	188
ETHERNET_ISL_INFO	188
EVENT_DETAILS_INFO	189
EVENT_INFO	190
FABRIC_INFO	190
FCIP_TUNNEL_CIRCUIT_INFO	191
FCIP_TUNNEL_INFO	192
FCOE_DEVICE_INFO	193
FRU_INFO	194
GIGE_PORT_ECLOUD_LINK_INFO	194
GIGE_PORT_INFO	195
HBA_PORT_DETAILS_INFO	195
HBA_TARGET_INFO	197
HOST_DISCOVERY_REQUEST_INFO	198
IFL_INFO	199
ISL_INFO	199
ISL_TRUNK_INFO	200
NPORT_WWN_MAP_INFO	201
PHANTOM_PORT_INFO	202
PORT_BOTTLENECK_CONF_INFO	202
PORT_BOTTLENECK_STAT_INFO	202
PORT_GROUP_INFO	203
ROLE_PRIVILEGE_INFO	203
SCOM_EE_MONITOR_INFO	204
SENSOR_INFO	204
SMART_CARD_USAGE_INFO	205
SWITCH_DETAILS_INFO	206
SWITCH_PORT_INFO	208
SWITCH_SNMP_INFO	210
USER_ROLE_RESOURCE_INFO	211
VIRTUAL_FCOE_PORT_INFO	211
VM_CONNECTIVITY_INFO	212
VM_EE_MONITOR_INFO	214
VM_HOST_INFO	214
VM_LUN_INFO	215
VM_STATISTICS_INFO	216
ZONE_DB_INFO	217
MANAGED_ELEMENT_INFO	269
SNMP_DATA_INFO	269
SNMP_EXPR_DATA_INFO	270

HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 200

Isl_trunk_info, Source_virtual_switch.core_switch_id As Source_core_switch_id

Page 200 highlights