Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1825)

Brocade Network Advisor SAN User Manual 1773
53-1003154-01
Views
H
varying, 'EX-Port'::character varying, 'FL-Port'::character varying,
'SIM-Port'::character varying, 'N-Port'::character varying]::text[]))OR
switch_port.type like'LB-Port%') AND switch_port.occupied = 1 ) AS
occupied_switch_port_count,
( SELECT count(switch_port.id) AS count
FROM switch_port
WHERE switch_port.virtual_switch_id = virtual_switch.id AND
switch_port.licensed = 1 AND ((switch_port.type::text = ANY
(ARRAY['E-Port'::character varying, 'G-Port'::character varying,
'U-Port'::character varying, 'F-Port'::character varying, 'L-Port'::character
varying, 'EX-Port'::character varying, 'FL-Port'::character varying,
'SIM-Port'::character varying, 'N-Port'::character varying]::text[]))OR
switch_port.type like'LB-Port%') AND switch_port.occupied = 0 ) AS
free_switch_port_count,
( SELECT count(switch_port.id) AS count
FROM switch_port
WHERE switch_port.virtual_switch_id = virtual_switch.id AND
switch_port.licensed = 0 AND ((switch_port.type::text = ANY
(ARRAY['E-Port'::character varying, 'G-Port'::character varying,
'U-Port'::character varying, 'F-Port'::character varying, 'L-Port'::character
varying, 'EX-Port'::character varying, 'FL-Port'::character varying,
'SIM-Port'::character varying, 'N-Port'::character varying]::text[]))OR
switch_port.type like'LB-Port%')) AS unlicensed_switch_port_count
FROM fabric, fabric_member, virtual_switch,
core_switch
LEFT JOIN core_switch_details ON core_switch_details.core_switch_id =
core_switch.id
WHERE virtual_switch.core_switch_id = core_switch.id AND core_switch.type NOT
IN(40,41) AND virtual_switch.monitored = 1 AND (virtual_switch.switch_mode = ANY
(ARRAY[0, 2])) AND fabric_member.virtual_switch_id = virtual_switch.id AND
fabric_member.fabric_id = fabric.id AND fabric.managed = 1 AND (fabric.type <> ALL
(ARRAY[65, 66, 4]))
DEVICE_INFO
create or replace view DEVICE_INFO as
select distinct
DEVICE_NODE.ID as DEVICE_NODE_ID,
DEVICE_NODE.WWN as DEVICE_NODE_WWN,
DEVICE_NODE.TYPE as DEVICE_NODE_TYPE,
DEVICE_NODE.SYMBOLIC_NAME as DEVICE_NODE_SYMBOLIC_NAME,
DEVICE_NODE.DEVICE_TYPE,
DEVICE_NODE.FDMI_HOST_NAME,
DEVICE_NODE.VENDOR,
DEVICE_NODE.CAPABILITY_,
DEVICE_NODE.AG,
DEVICE_NODE.SIMULATED,
DEVICE_PORT.ID as DEVICE_PORT_ID,
DEVICE_PORT.DOMAIN_ID as DEVICE_PORT_DOMAIN_ID,
DEVICE_PORT.WWN as DEVICE_PORT_WWN,
DEVICE_PORT.NUMBER,
DEVICE_PORT.PORT_ID,
DEVICE_PORT.TYPE as DEVICE_PORT_TYPE,
DEVICE_PORT.SYMBOLIC_NAME as DEVICE_PORT_SYMBOLIC_NAME,
DEVICE_PORT.FC4_TYPE,
DEVICE_PORT.IP_PORT,
DEVICE_PORT.HARDWARE_ADDRESS,
DEVICE_PORT.TRUSTED as DEVICE_PORT_TRUSTED,
DEVICE_PORT.MISSING as DEVICE_PORT_MISSING,