Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1818)

1766 Brocade Network Advisor IP User Manual
53-1003153-01
Views
I
virtual_switch.fcip_circuit_capable, virtual_switch.max_fcip_tunnels,
virtual_switch.max_fcip_circuits, virtual_switch.fcip_licensed,
virtual_switch.addressing_mode, virtual_switch.previous_state,
virtual_switch.managed_element_id, virtual_switch.hif_enabled,
virtual_switch.auto_snmp, virtual_switch.rnid_sequence_number,
virtual_switch.vcs_id, virtual_switch.cluster_type,
virtual_switch.cluster_mode, virtual_switch.rnid_tag,
virtual_switch.switch_id, virtual_switch.monitored,
virtual_switch.features_enabled, virtual_switch.maps_enabled_actions,
virtual_switch.routing_policy, fabric_member.fabric_id,
CASE
WHEN virtual_switch.switch_mode = 2 THEN 'Yes'::text
ELSE 'No'::text
END AS ag_mode,
fabric_member.trusted, fabric_member.missing, fabric_member.missing_time,
fabric.managed AS fabric_managed, fabric.principal_switch_wwn,
fabric.seed_switch_wwn, fabric.type AS fabric_type,
core_switch_details.model_number AS switchtype,
( 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%')) AS switch_port_count,
( SELECT count(device_node.id) AS count
FROM device_node, device_port, switch_port
WHERE device_node.id = device_port.node_id AND
device_port.switch_port_wwn = switch_port.wwn AND switch_port.licensed = 1 AND
switch_port.virtual_switch_id = virtual_switch.id AND device_node.type::text ~~
'Initiator'::text) AS initiatorcount,
( SELECT count(device_node.id) AS count
FROM device_node, device_port, switch_port
WHERE device_node.id = device_port.node_id AND
device_port.switch_port_wwn = switch_port.wwn AND switch_port.licensed = 1 AND
switch_port.virtual_switch_id = virtual_switch.id AND device_node.type::text ~~
'Target'::text) AS tagetcount,
( SELECT count(device_node.id) AS count
FROM device_node, device_port, switch_port
WHERE device_node.id = device_port.node_id AND
device_port.switch_port_wwn = switch_port.wwn AND switch_port.licensed = 1 AND
switch_port.virtual_switch_id = virtual_switch.id AND device_node.type::text ~~
'Initiator+Target'::text) AS initiatortargetcount,
( SELECT count(device_node.id) AS count
FROM device_node, device_port, switch_port
WHERE device_node.id = device_port.node_id AND
device_port.switch_port_wwn = switch_port.wwn AND switch_port.licensed = 1 AND
switch_port.virtual_switch_id = virtual_switch.id AND device_node.type::text ~~
'Unknown'::text) AS unknowncount,
( 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