Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1850

Advertising
background image

1798

Brocade Network Advisor SAN User Manual

53-1003154-01

Views

H

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,

Advertising
Popular Brands
Popular manuals