Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1744)

1690 Brocade Network Advisor IP User Manual
53-1002947-01
Views
I
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.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
from
ZONE_DB, ZONE_DB_CONFIG
where
ZONE_DB.ID = ZONE_DB_CONFIG.ZONE_DB_ID;
-- Name: ap_usage; Type: VIEW; Schema: dcm; Owner: dcmadmin
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;
-- Name: events; Type: VIEW; Schema: dcm; Owner: dcmadmin
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)));
-- Name: sflow; Type: VIEW; Schema: dcm; Owner: dcmadmin
create or replace view SFLOW as
select DEVICE_ID, IN_SLOT, IN_PORT, OUT_SLOT, OUT_PORT, L4_PROTOCOL, IP_TOS,
SRC_SUBNET_BITS, DEST_SUBNET_BITS, IN_PRIORITY, OUT_PRIORITY, IN_VLAN, OUT_VLAN,
L3_PROTOCOL, L4_SRC_PORT, L4_DEST_PORT, TIME_IN_SECONDS, SRC_MAC, DEST_MAC,
L3_SRC_ADDR, L3_DEST_ADDR, TCP_FLAGS, LOCAL_AS, SRC_AS, SRC_PEER_AS,
SFLOW_IP_ROUTE_INFO_ID, IP_FLOW_LABEL, SRC_USER, DEST_USER, FRAMES, BYTES,
IN_UNIT, OUT_UNIT
from SFLOW_HOUR_SUMMARY
where SLNUM <= (select MAX_SLNUM from SFLOW_HOUR_SUMMARY_SLNUM fetch first 1
rows only)
union all
select DEVICE_ID, IN_SLOT, IN_PORT, OUT_SLOT, OUT_PORT, L4_PROTOCOL, IP_TOS,
SRC_SUBNET_BITS, DEST_SUBNET_BITS, IN_PRIORITY, OUT_PRIORITY, IN_VLAN, OUT_VLAN,
L3_PROTOCOL, L4_SRC_PORT, L4_DEST_PORT, TIME_IN_SECONDS, SRC_MAC, DEST_MAC,
L3_SRC_ADDR, L3_DEST_ADDR, TCP_FLAGS, LOCAL_AS, SRC_AS, SRC_PEER_AS,
SFLOW_IP_ROUTE_INFO_ID, IP_FLOW_LABEL, SRC_USER, DEST_USER, FRAMES, BYTES,
IN_UNIT, OUT_UNIT
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
-- Name: sflow_minute_bgp_view; Type: VIEW; Schema: dcm; Owner: dcmadmin
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