Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2610)

2538 Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Views
I
DEVICE_ENCLOSURE.COMMENT_,
DEVICE_ENCLOSURE.IP_ADDRESS,
DEVICE_ENCLOSURE.VENDOR,
DEVICE_ENCLOSURE.MODEL,
DEVICE_ENCLOSURE.SERIAL_NUMBER,
DEVICE_ENCLOSURE.FIRMWARE,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE1,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE2,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE3,
DEVICE_ENCLOSURE.HCM_AGENT_VERSION,
DEVICE_ENCLOSURE.OS_VERSION,
DEVICE_ENCLOSURE.CREATED_BY,
DEVICE_ENCLOSURE.TRACK_CHANGES,
DEVICE_ENCLOSURE.LAST_UPDATE_TIME,
DEVICE_ENCLOSURE.LAST_UPDATE_MODULE,
DEVICE_ENCLOSURE.TRUSTED,
DEVICE_ENCLOSURE.CREATION_TIME,
DEVICE_ENCLOSURE.MISSING,
DEVICE_ENCLOSURE.MISSING_TIME,
DEVICE_ENCLOSURE.HOST_NAME,
DEVICE_ENCLOSURE.SYSLOG_REGISTERED,
DEVICE_ENCLOSURE.VIRTUALIZATION,
DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID
from HOST_DISCOVERY_REQUESTS
join HOST_DISCOVERY_OPTIONS on
HOST_DISCOVERY_REQUESTS.HOST_DISCOVERY_OPTIONS_ID = HOST_DISCOVERY_OPTIONS.ID
left join DEVICE_ENCLOSURE on HOST_DISCOVERY_REQUESTS.DEVICE_ENCLOSURE_ID =
DEVICE_ENCLOSURE.ID;
create or replace view FCIP_TUNNEL_CIRCUIT_INFO as
select FCIP_TUNNEL_CIRCUIT.ID, FCIP_TUNNEL_CIRCUIT.TUNNEL_ID,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER, FCIP_TUNNEL_CIRCUIT.COMPRESSION_ENABLED,
FCIP_TUNNEL_CIRCUIT.TURBO_WRITE_ENABLED,
FCIP_TUNNEL_CIRCUIT.TAPE_ACCELERATION_ENABLED,
FCIP_TUNNEL_CIRCUIT.IKE_POLICY_NUM, FCIP_TUNNEL_CIRCUIT.IPSEC_POLICY_NUM,
FCIP_TUNNEL_CIRCUIT.PRESHARED_KEY, FCIP_TUNNEL_CIRCUIT.SOURCE_IP,
FCIP_TUNNEL_CIRCUIT.DEST_IP, FCIP_TUNNEL_CIRCUIT.VLAN_TAG,
FCIP_TUNNEL_CIRCUIT.DP1_SOURCE_IP,FCIP_TUNNEL_CIRCUIT.DP1_DEST_IP,FCIP_TUNNEL_CIR
CUIT.DP1_VLAN_TAG,
FCIP_TUNNEL_CIRCUIT.SELECTIVE_ACK, FCIP_TUNNEL_CIRCUIT.QOS_MAPPING,
FCIP_TUNNEL_CIRCUIT.PATH_MTU_DISCOVERY, FCIP_TUNNEL_CIRCUIT.MIN_COMM_RATE,
FCIP_TUNNEL_CIRCUIT.MAX_COMM_RATE, FCIP_TUNNEL_CIRCUIT.MIN_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMIT_TIME,
FCIP_TUNNEL_CIRCUIT.KEEP_ALIVE_TIMEOUT, FCIP_TUNNEL_CIRCUIT.ADMIN_STATUS,
FCIP_TUNNEL_CIRCUIT.METRIC, FCIP_TUNNEL_CIRCUIT.DATA_L2_COS,
FCIP_TUNNEL_CIRCUIT.DSCP_DATA, FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMISSIONS,
FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER, FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER,
FCIP_TUNNEL_CIRCUIT.SECURITY_FLAG, FCIP_TUNNEL_CIRCUIT.DSCP_CONTROL,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS, FCIP_TUNNEL_CIRCUIT.ENABLED,
FCIP_TUNNEL_CIRCUIT.MISMATCHED_CONFIGURATIONS,
FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS_STRING,
FCIP_TUNNEL_CIRCUIT.L2COS_F_CLASS, FCIP_TUNNEL_CIRCUIT.L2_COS_HIGH,
FCIP_TUNNEL_CIRCUIT.L2_COS_MEDIUM, FCIP_TUNNEL_CIRCUIT.L2_COS_LOW,
FCIP_TUNNEL_CIRCUIT.DSCP_F_CLASS, FCIP_TUNNEL_CIRCUIT.DSCP_HIGH,
FCIP_TUNNEL_CIRCUIT.DSCP_MEDIUM, FCIP_TUNNEL_CIRCUIT.DSCP_LOW,
FCIP_TUNNEL_CIRCUIT.FAILOVER_CIRCUIT, FCIP_TUNNEL_CIRCUIT.FAILOVER_GROUP_ID,
DP0_GIGE_PORT.PORT_NUMBER as GIGE_PORT_NUMBER,
DP0_GIGE_PORT.SLOT_NUMBER as GIGE_PORT_SLOT_NUMBER,
FCIP_CIRCUIT_PORT_MAP.SWITCH_PORT_ID as GIGE_PORT_ID,