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

Brocade Network Advisor SAN + IP User Manual 2597
53-1003155-01
Views
I
ZONE_DB_REPORT_INFO
CREATE OR REPLACE VIEW zone_db_report_info AS
SELECT zone_db.id, zone_db.fabric_id, zone_db.offline, zone_db.name,
zone_db.created, zone_db.created_by, zone_db.last_modified,
zone_db.last_modified_by, zone_db.last_applied, zone_db.last_applied_by,
zone_db.default_zone_status, zone_db.mcdata_default_zone,
zone_db.mcdata_safe_zone, zone_db.zone_txn_supported,
zone_db.zone_config_size, zone_db.txn_status, zone_db.zone_available_size,
zone_db_config.id AS config_id, zone_db_config.defined_content,
zone_db_config.active_content, zone_db_config.ti_zone_content,
virtual_switch.name AS seed_vs_name, virtual_switch.wwn AS vs_wwn,
virtual_switch.id AS vs_id, core_switch.name AS cs_name,
core_switch.ip_address AS seed_cs_switch_ip, core_switch.id AS cs_id,
core_switch.wwn AS cs_wwn, fabric.name AS fabric_name,
fabric.status AS fabric_status
FROM zone_db
JOIN zone_db_config ON zone_db.id = zone_db_config.zone_db_id
JOIN fabric ON zone_db.fabric_id = fabric.id
JOIN virtual_switch ON fabric.seed_switch_wwn = virtual_switch.wwn
JOIN core_switch ON virtual_switch.core_switch_id = core_switch.id
WHERE fabric.type != 4 AND fabric.managed = 1;
AP_USAGE
CREATE VIEW ap_usage AS
SELECT ap_station.device_id, ap_station.time_stamp, count(*) AS num_clients
FROM ap_station WHERE (ap_station.radio > 0) GROUP BY ap_station.device_id,
ap_station.time_stamp;
EVENTS
CREATE VIEW events AS
SELECT emain.trap_log_id, emain.trap_sender, emain."timestamp",
emain.severity, emsgs.messages, emain.is_ack, emain.log_type, emain.slot,
emain.port, emain.device_id, emain.event_action_id, emain.device_group_id,
emain.port_group_id, emain.trap_device_ip, emain.log_sub_type, emain.unit FROM
(events_main emain LEFT JOIN events_messages emsgs ON ((emain.messages_id =
emsgs.messages_id)));
SFLOW_MINUTE_BGP_VIEW
create or replace view SFLOW_MINUTE_BGP_VIEW as
select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN,
OUT_VLAN, FRAMES, BYTES
from SFLOW_MINUTE_BGP
where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_BGP_SLNUM fetch first 1 rows
only)
union all
select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN,
OUT_VLAN, FRAMES, BYTES
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only)
and SRC_AS != 0 OR SFLOW_IP_ROUTE_INFO_ID != 0;