Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

ManualsBrandsHP ManualsSoftwareHP B-series Data Center Fabric Manager Enterprise Software

1411

Brocade Network Advisor SAN User Manual 1367

53-1002696-01

Views

left outer join DEPLOYMENT_REPORT_TEMPLATE on

DEPLOYMENT_REPORT_TEMPLATE.DEPLOYMENT_HANDLER_ID = DEPLOYMENT_HANDLER.ID;

DEVICE_CONNECTION_INFO

create or replace view DEVICE_CONNECTION_INFO as

SELECT device_connection.id, device_connection.fabric_id,

device_connection.device_port_id, device_connection.switch_port_id,

device_connection.ag_port_id, COALESCE(device_enclosure_member.enclosure_id,

hba.host_id) AS device_enclosure_id, device_connection.creation_time,

device_connection.last_updated_time, device_port.node_id,

device_connection.missing, device_connection.missing_time,

swport.virtual_switch_id, device_connection.trusted, agport.virtual_switch_id AS

ag_switch_id, device_port.wwn AS device_port_wwn

FROM device_connection

LEFT JOIN device_port ON device_connection.device_port_id = device_port.id

LEFT JOIN switch_port swport ON device_connection.switch_port_id = swport.id

LEFT JOIN switch_port agport ON device_connection.ag_port_id = agport.id

LEFT JOIN hba_port_device_port_map ON device_port.id =

hba_port_device_port_map.device_port_id

LEFT JOIN hba_port ON hba_port_device_port_map.hba_port_id =

hba_port.device_port_id

LEFT JOIN hba ON hba_port.hba_id = hba.id

LEFT JOIN device_enclosure_member ON device_port.id =

device_enclosure_member.device_port_id;

SWITCH_INFO

create or replace view SWITCH_INFO as

select

CORE_SWITCH.ID as PHYSICAL_SWITCH_ID,

CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME,

CORE_SWITCH.IP_ADDRESS,

CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,

CORE_SWITCH.OPERATIONAL_STATUS as PHYSICAL_OPERATIONAL_STATUS,

CORE_SWITCH.TYPE,

CORE_SWITCH.MAX_VIRTUAL_SWITCHES,

CORE_SWITCH.NUM_VIRTUAL_SWITCHES,

CORE_SWITCH.FIRMWARE_VERSION,

CORE_SWITCH.VENDOR,

CORE_SWITCH.REACHABLE,

CORE_SWITCH.UNREACHABLE_TIME,

CORE_SWITCH.MODEL,

CORE_SWITCH.SYSLOG_REGISTERED,

CORE_SWITCH.SNMP_REGISTERED,

CORE_SWITCH.CALL_HOME_ENABLED,

CORE_SWITCH.USER_IP_ADDRESS,

CORE_SWITCH.NIC_PROFILE_ID,

CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS,

CORE_SWITCH.VF_ENABLED,

CORE_SWITCH.VF_SUPPORTED,

CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID,

CORE_SWITCH.NAT_PRIVATE_IP_ADDRESS,

CORE_SWITCH.ALTERNATE_IP_ADDRESS,

CORE_SWITCH.MAC_ADDRESS,

VIRTUAL_SWITCH.ID,

VIRTUAL_SWITCH.NAME,

VIRTUAL_SWITCH.OPERATIONAL_STATUS,