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

1224 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
-- Name: sflow_report_l3_source; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE sflow_report_l3_source (
sflow_report_l3_source_id integer NOT NULL,
report_definition_id integer NOT NULL,
address_group_id integer,
ip_subnet_definition_id integer
);
-- Name: sflow_report_l4_source; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE sflow_report_l4_source (
sflow_report_l4_source_id integer NOT NULL,
report_definition_id integer NOT NULL,
service_port_definition_id integer,
service_group_id integer
);
-- Name: sharing; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE sharing (
sharing_id integer NOT NULL,
object_type character varying(128),
object_id integer,
role_id integer,
user_id integer,
permission numeric(2,0)
);
-- Name: slot; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE slot (
slot_id integer NOT NULL,
physical_device_id integer NOT NULL,
slot_num numeric(4,0) NOT NULL
);
-- Name: snmp_data; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE snmp_data (
ID serial not null,
mib_object_id integer NOT NULL,
target_type numeric(2,0) NOT NULL,
target_id integer NOT NULL,
value double precision NOT NULL,
time_in_seconds integer NOT NULL,
collector_id integer NOT NULL,
mib_index character varying(256) default '',
constraint PK_SNMP_DATA primary key (ID)
);
-- Name: snmp_expr_data; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE snmp_expr_data (
ID serial not null,
expression_id integer NOT NULL,
target_type smallint NOT NULL,
target_id integer NOT NULL,
value double precision NOT NULL,
time_in_seconds integer NOT NULL,
collector_id integer NOT NULL,