Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1188 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
authenticated smallint,
associated smallint,
isforwarding smallint,
keytype smallint,
lastauthenticatedtime bigint,
associatedtime bigint,
lastassociatedtime bigint,
lastdisassociatedtime bigint,
txpacketcount bigint,
rxpacketcount bigint,
txbytecount bigint,
rxbytecount bigint,
time_interval bigint,
radio smallint,
channel smallint
);
-- Name: ap_station_last_saved; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE ap_station_last_saved (
device_id integer NOT NULL,
time_stamp bigint NOT NULL
);
-- Name: ap_station_sqnum_seq; Type: SEQUENCE; Schema: dcm; Owner: dcmadmin
CREATE SEQUENCE ap_station_sqnum_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
-- 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: apple_talk_cable_vlan; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE apple_talk_cable_vlan (
vlan_db_id integer NOT NULL,
vlan_id smallint NOT NULL
);
-- Name: atm_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE atm_interface (
interface_id integer NOT NULL
);
-- Name: authentication_encryption; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE authentication_encryption (
authentication_encryption_id integer NOT NULL,
ssid_authentication_id integer NOT NULL,
encryption_type numeric(2,0),
is_shared numeric(1,0),
data_encryption_on numeric(1,0),
table_subtype character varying(32) NOT NULL,
uiengine_realm_security_device_config_id integer