git.sesse.net Git - nms/blob - web/nms.sql

   1 --
   2 -- NOTE: the PL/SQL in this file should probably not be trusted, it is rather
   3 --       wrong at places, especially when it comes to wraparound. -sesse
   4 --
   5
   6 --
   7 -- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
   8 --
   9
  10 CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
  11     AS '$libdir/plpgsql', 'plpgsql_call_handler'
  12     LANGUAGE c;
  13
  14
  15 ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;
  16
  17 --
  18 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
  19 --
  20
  21 CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
  22
  23 CREATE TABLE polls (
  24     "time" timestamp with time zone NOT NULL,
  25     switch integer NOT NULL,
  26     port integer NOT NULL,
  27     bytes_in bigint NOT NULL,
  28     bytes_out bigint NOT NULL
  29 );
  30 ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;
  31
  32
  33 ALTER TABLE public.polls OWNER TO postgres;
  34
  35 --
  36 -- Name: datarate; Type: TYPE; Schema: public; Owner: sesse
  37 --
  38
  39 CREATE TYPE datarate AS (
  40         switch integer,
  41         port integer,
  42         bytes_in double precision,
  43         bytes_out double precision
  44 );
  45
  46
  47 ALTER TYPE public.datarate OWNER TO sesse;
  48
  49 --
  50 -- Name: get_current_datarate(); Type: FUNCTION; Schema: public; Owner: nms
  51 --
  52
  53 CREATE FUNCTION get_current_datarate() RETURNS SETOF datarate
  54     AS $$
  55 DECLARE
  56         num_entries INTEGER;
  57         poll polls;
  58         first_poll polls;
  59         last_poll polls;
  60         timediff float;
  61         ret datarate;
  62 BEGIN
  63         num_entries := 0;
  64         last_poll.switch := -1;
  65
  66         FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
  67                 IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
  68                         IF num_entries >= 2 THEN
  69                                 timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
  70                                 ret.switch := last_poll.switch;
  71                                 ret.port := last_poll.port;
  72
  73                                 IF last_poll.bytes_in >= first_poll.bytes_in AND last_poll.bytes_out >= first_poll.bytes_out THEN
  74                                         ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
  75                                         ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
  76                                         return next ret;
  77                                 END IF;
  78                         END IF;
  79                         num_entries := 0;
  80                 ELSE
  81                         -- reset if we have wraparound
  82                         IF last_poll.bytes_in < first_poll.bytes_in OR
  83                            last_poll.bytes_out < first_poll.bytes_out THEN
  84                                 num_entries := 0;
  85                         END IF;
  86                 END IF;
  87
  88                 num_entries := num_entries + 1;
  89                 IF num_entries = 1 THEN
  90                         first_poll.switch := poll.switch;
  91                         first_poll.port := poll.port;
  92                         first_poll.time := poll.time;
  93                         first_poll.bytes_in := poll.bytes_in;
  94                         first_poll.bytes_out := poll.bytes_out;
  95                 END IF;
  96
  97                 last_poll.switch := poll.switch;
  98                 last_poll.port := poll.port;
  99                 last_poll.time := poll.time;
 100                 last_poll.bytes_in := poll.bytes_in;
 101                 last_poll.bytes_out := poll.bytes_out;
 102         END LOOP;
 103
 104         -- last
 105         IF num_entries >= 2 THEN
 106                 timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
 107                 ret.switch := last_poll.switch;
 108                 ret.port := last_poll.port;
 109
 110                 IF last_poll.bytes_in >= first_poll.bytes_in AND
 111                    last_poll.bytes_out >= first_poll.bytes_out THEN
 112                         ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
 113                         ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
 114                         return next ret;
 115                 END IF;
 116         END IF;
 117
 118         RETURN;
 119 END;
 120 $$
 121     LANGUAGE plpgsql;
 122
 123
 124 ALTER FUNCTION public.get_current_datarate() OWNER TO nms;
 125
 126 --
 127 -- Name: get_datarate(); Type: FUNCTION; Schema: public; Owner: postgres
 128 --
 129
 130 CREATE FUNCTION get_datarate() RETURNS SETOF datarate
 131     AS $$
 132 DECLARE
 133         num_entries INTEGER;
 134         poll polls;
 135         second_last_poll polls;
 136         last_poll polls;
 137         timediff float;
 138         ret datarate;
 139 BEGIN
 140         num_entries := 0;
 141         last_poll.switch = -1;
 142
 143         FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
 144                 IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
 145                         IF num_entries >= 2 THEN
 146                                 timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
 147                                 ret.switch := last_poll.switch;
 148                                 ret.port := last_poll.port;
 149
 150                                 IF last_poll.bytes_in < second_last_poll.bytes_in THEN
 151                                         second_last_poll.bytes_in = 0;
 152                                 END IF;
 153                                 IF last_poll.bytes_out < second_last_poll.bytes_out THEN
 154                                         second_last_poll.bytes_out = 0;
 155                                 END IF;
 156
 157                                 ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
 158                                 ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
 159                                 return next ret;
 160                         ELSIF num_entries = 1 THEN
 161                                 ret.switch := last_poll.switch;
 162                                 ret.port := last_poll.port;
 163                                 ret.bytes_in := -1;
 164                                 ret.bytes_out := -1;
 165                                 return next ret;
 166                         END IF;
 167                         num_entries := 1;
 168                 ELSE
 169                         num_entries := num_entries + 1;
 170                 END IF;
 171                 second_last_poll.switch := last_poll.switch;
 172                 second_last_poll.port := last_poll.port;
 173                 second_last_poll.time := last_poll.time;
 174                 second_last_poll.bytes_in := last_poll.bytes_in;
 175                 second_last_poll.bytes_out := last_poll.bytes_out;
 176                 last_poll.switch := poll.switch;
 177                 last_poll.port := poll.port;
 178                 last_poll.time := poll.time;
 179                 last_poll.bytes_in := poll.bytes_in;
 180                 last_poll.bytes_out := poll.bytes_out;
 181         END LOOP;
 182        -- pah, and once more, for the last switch/port...
 183         IF num_entries >= 2 THEN
 184                 timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
 185                 ret.switch := last_poll.switch;
 186                 ret.port := last_poll.port;
 187
 188                 IF last_poll.bytes_in < second_last_poll.bytes_in THEN
 189                         second_last_poll.bytes_in = 0;
 190                 END IF;
 191                 IF last_poll.bytes_out < second_last_poll.bytes_out THEN
 192                         second_last_poll.bytes_out = 0;
 193                 END IF;
 194
 195                 ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
 196                 ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
 197                 return next ret;
 198         ELSIF num_entries = 1 THEN
 199                 ret.switch := last_poll.switch;
 200                 ret.port := last_poll.port;
 201                 ret.bytes_in := -1;
 202                 ret.bytes_out := -1;
 203                 return next ret;
 204         END IF;
 205
 206         RETURN;
 207 END;
 208 $$
 209     LANGUAGE plpgsql;
 210
 211
 212 ALTER FUNCTION public.get_datarate() OWNER TO postgres;
 213
 214 SET default_tablespace = '';
 215
 216 SET default_with_oids = false;
 217
 218 --
 219 -- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace:
 220 --
 221
 222 CREATE TABLE dhcp (
 223     switch integer NOT NULL,
 224     network cidr NOT NULL,
 225     last_ack timestamp without time zone
 226 );
 227
 228
 229 ALTER TABLE public.dhcp OWNER TO sesse;
 230
 231 --
 232 -- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 233 --
 234
 235 CREATE TABLE placements (
 236     switch integer NOT NULL,
 237     placement box NOT NULL
 238 );
 239
 240
 241 ALTER TABLE public.placements OWNER TO postgres;
 242
 243 SET default_with_oids = true;
 244
 245 --
 246 -- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 247 --
 248
 249
 250 --
 251 -- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 252 --
 253
 254 CREATE SEQUENCE polls_poll_seq
 255     START WITH 1
 256     INCREMENT BY 1
 257     NO MAXVALUE
 258     NO MINVALUE
 259     CACHE 1;
 260
 261
 262 ALTER TABLE public.polls_poll_seq OWNER TO postgres;
 263
 264 --
 265 -- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 266 --
 267
 268 SELECT pg_catalog.setval('polls_poll_seq', 1, false);
 269
 270
 271 --
 272 -- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 273 --
 274
 275 CREATE TABLE portnames (
 276     switchtype character varying NOT NULL,
 277     port integer NOT NULL,
 278     description character varying NOT NULL
 279 );
 280
 281
 282 ALTER TABLE public.portnames OWNER TO postgres;
 283
 284 --
 285 -- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace:
 286 --
 287
 288 CREATE TABLE squeue (
 289     id integer DEFAULT nextval('squeue_sequence'::text) NOT NULL,
 290     gid integer NOT NULL,
 291     added timestamp with time zone NOT NULL,
 292     updated timestamp with time zone,
 293     addr inet,
 294     cmd character varying NOT NULL,
 295     locked boolean DEFAULT false NOT NULL,
 296     processed boolean DEFAULT false NOT NULL,
 297     disabled boolean DEFAULT false NOT NULL,
 298     priority integer DEFAULT 3,
 299     sysname character varying NOT NULL,
 300     author character varying NOT NULL,
 301     result character varying,
 302     delay timestamp with time zone,
 303     delaytime interval DEFAULT '00:01:00'::interval
 304 );
 305
 306
 307 ALTER TABLE public.squeue OWNER TO nms;
 308
 309 --
 310 -- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 311 --
 312
 313 CREATE SEQUENCE squeue_group_sequence
 314     INCREMENT BY 1
 315     NO MAXVALUE
 316     NO MINVALUE
 317     CACHE 1;
 318
 319
 320 ALTER TABLE public.squeue_group_sequence OWNER TO nms;
 321
 322 --
 323 -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 324 --
 325
 326 SELECT pg_catalog.setval('squeue_group_sequence', 21, true);
 327
 328
 329 --
 330 -- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 331 --
 332
 333 CREATE SEQUENCE squeue_sequence
 334     INCREMENT BY 1
 335     NO MAXVALUE
 336     NO MINVALUE
 337     CACHE 1;
 338
 339
 340 ALTER TABLE public.squeue_sequence OWNER TO nms;
 341
 342 --
 343 -- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 344 --
 345
 346 SELECT pg_catalog.setval('squeue_sequence', 901, true);
 347
 348
 349 --
 350 -- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms
 351 --
 352
 353 CREATE SEQUENCE stemppoll_sequence
 354     INCREMENT BY 1
 355     NO MAXVALUE
 356     NO MINVALUE
 357     CACHE 1;
 358
 359
 360 ALTER TABLE public.stemppoll_sequence OWNER TO nms;
 361
 362 --
 363 -- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
 364 --
 365
 366 SELECT pg_catalog.setval('stemppoll_sequence', 182534, true);
 367
 368
 369 SET default_with_oids = false;
 370
 371 --
 372 -- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 373 --
 374
 375 CREATE TABLE switches (
 376     switch integer DEFAULT nextval('"switches_switch_seq"'::text) NOT NULL,
 377     ip inet NOT NULL,
 378     sysname character varying NOT NULL,
 379     switchtype character varying NOT NULL,
 380     last_updated timestamp with time zone,
 381     locked boolean DEFAULT false NOT NULL,
 382     priority integer DEFAULT 0 NOT NULL,
 383     poll_frequency interval DEFAULT '00:05:00'::interval NOT NULL,
 384     community character varying DEFAULT 'public'::character varying NOT NULL
 385 );
 386
 387
 388 ALTER TABLE public.switches OWNER TO postgres;
 389
 390 --
 391 -- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres
 392 --
 393
 394 CREATE SEQUENCE switches_switch_seq
 395     INCREMENT BY 1
 396     NO MAXVALUE
 397     NO MINVALUE
 398     CACHE 1;
 399
 400
 401 ALTER TABLE public.switches_switch_seq OWNER TO postgres;
 402
 403 --
 404 -- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
 405 --
 406
 407 SELECT pg_catalog.setval('switches_switch_seq', 225, true);
 408
 409
 410 --
 411 -- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 412 --
 413
 414 CREATE TABLE switchtypes (
 415     switchtype character varying NOT NULL,
 416     ports character varying NOT NULL
 417 );
 418
 419
 420 ALTER TABLE public.switchtypes OWNER TO postgres;
 421
 422 SET default_with_oids = true;
 423
 424 --
 425 -- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
 426 --
 427
 428 CREATE TABLE temppoll (
 429     id integer DEFAULT nextval('stemppoll_sequence'::text) NOT NULL,
 430     "time" timestamp without time zone NOT NULL,
 431     switch integer NOT NULL,
 432     "temp" double precision
 433 );
 434
 435
 436 ALTER TABLE public.temppoll OWNER TO postgres;
 437
 438 --
 439 -- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: sesse
 440 --
 441
 442 COPY dhcp (switch, network, last_ack) FROM stdin;
 443 151     81.162.53.0/26  2005-03-27 11:53:29
 444 41      81.162.16.64/26 2005-03-27 11:53:35
 445 164     81.162.57.64/26 2005-03-27 11:53:39
 446 20      81.162.9.64/26  2005-03-27 11:54:27
 447 4       81.162.4.0/26   2005-03-27 11:55:33
 448 44      81.162.17.64/26 2005-03-27 11:56:37
 449 194     81.162.67.64/26 2005-03-27 11:56:38
 450 139     81.162.49.0/26  2005-03-27 11:57:08
 451 46      81.162.18.0/26  2005-03-27 11:57:27
 452 193     81.162.67.0/26  2005-03-27 11:57:36
 453 27      81.162.11.128/26        2005-03-27 11:58:07
 454 107     81.162.38.64/26 2005-03-27 11:58:31
 455 133     81.162.47.0/26  2005-03-27 11:58:52
 456 99      81.162.35.128/26        2005-03-27 11:59:09
 457 79      81.162.29.0/26  2005-03-27 11:59:18
 458 34      81.162.14.0/26  2005-03-27 11:59:28
 459 51      81.162.19.128/26        2005-03-27 11:59:34
 460 160     81.162.56.0/26  2005-03-27 12:00:01
 461 196     81.162.68.0/26  2005-03-27 12:00:11
 462 184     81.162.64.0/26  2005-03-27 12:01:48
 463 9       81.162.5.128/26 2005-03-27 12:01:54
 464 195     81.162.67.128/26        2005-03-27 12:02:18
 465 123     81.162.43.128/26        2005-03-27 12:02:46
 466 192     81.162.66.128/26        2005-03-27 12:03:09
 467 212     81.162.203.0/24 2005-03-27 12:04:12
 468 5       81.162.4.64/26  2005-03-27 12:04:14
 469 113     81.162.40.64/26 2005-03-27 12:05:01
 470 191     81.162.66.64/26 2005-03-27 12:05:01
 471 119     81.162.42.64/26 2005-03-27 12:06:01
 472 3       81.162.2.128/26 2005-03-27 12:06:03
 473 74      81.162.27.64/26 2005-03-27 12:06:12
 474 201     81.162.70.0/26  2005-03-27 12:06:25
 475 86      81.162.31.64/26 2005-03-27 12:07:56
 476 50      81.162.19.64/26 2005-03-27 12:08:36
 477 59      81.162.22.64/26 2005-03-27 12:08:59
 478 43      81.162.17.0/26  2005-03-27 12:09:02
 479 80      81.162.29.64/26 2005-03-27 12:09:14
 480 106     81.162.38.0/26  2005-03-27 12:09:15
 481 52      81.162.20.0/26  2005-03-27 12:09:22
 482 205     81.162.72.0/26  2005-03-27 12:10:08
 483 82      81.162.30.0/26  2005-03-27 12:10:10
 484 128     81.162.45.64/26 2005-03-27 12:10:38
 485 112     81.162.40.0/26  2005-03-27 12:11:16
 486 202     81.162.70.64/26 2005-03-27 12:12:30
 487 6       81.162.4.128/26 2005-03-27 12:12:49
 488 95      81.162.34.64/26 2005-03-27 12:13:02
 489 178     81.162.62.0/26  2005-03-27 12:13:10
 490 145     81.162.51.0/26  2005-03-27 12:13:15
 491 84      81.162.30.128/26        2005-03-27 12:13:34
 492 28      81.162.12.0/26  2005-03-27 12:13:58
 493 22      81.162.10.0/26  2005-03-27 12:14:40
 494 122     81.162.43.64/26 2005-03-27 12:14:57
 495 85      81.162.31.0/26  2005-03-27 12:15:21
 496 18      81.162.8.128/26 2005-03-27 12:15:24
 497 105     81.162.37.128/26        2005-03-27 12:15:24
 498 81      81.162.29.128/26        2005-03-27 12:15:36
 499 77      81.162.28.64/26 2005-03-27 12:15:47
 500 146     81.162.51.64/26 2005-03-27 12:17:09
 501 24      81.162.10.128/26        2005-03-27 12:17:10
 502 190     81.162.66.0/26  2005-03-27 12:17:10
 503 33      81.162.13.128/26        2005-03-27 12:17:17
 504 150     81.162.52.128/26        2005-03-27 12:17:27
 505 57      81.162.21.128/26        2005-03-27 12:17:37
 506 17      81.162.8.64/26  2005-03-27 12:17:39
 507 54      81.162.20.128/26        2005-03-27 12:18:24
 508 94      81.162.34.0/26  2005-03-27 12:18:24
 509 69      81.162.25.128/26        2005-03-27 12:18:26
 510 141     81.162.49.128/26        2005-03-27 12:18:43
 511 154     81.162.54.0/26  2005-03-27 12:19:25
 512 177     81.162.61.128/26        2005-03-27 12:20:17
 513 29      81.162.12.64/26 2005-03-27 12:20:37
 514 91      81.162.33.0/26  2005-03-27 12:20:53
 515 83      81.162.30.64/26 2005-03-27 12:20:57
 516 47      81.162.18.64/26 2005-03-27 12:21:10
 517 170     81.162.59.64/26 2005-03-27 12:22:01
 518 78      81.162.28.128/26        2005-03-27 12:22:26
 519 155     81.162.54.64/26 2005-03-27 12:23:11
 520 35      81.162.14.64/26 2005-03-27 12:23:12
 521 32      81.162.13.64/26 2005-03-27 12:23:55
 522 199     81.162.69.64/26 2005-03-27 12:24:13
 523 63      81.162.23.128/26        2005-03-27 12:24:33
 524 90      81.162.32.128/26        2005-03-27 12:25:31
 525 114     81.162.40.128/26        2005-03-27 12:26:04
 526 75      81.162.27.128/26        2005-03-27 12:26:06
 527 42      81.162.16.128/26        2005-03-27 12:26:26
 528 87      81.162.31.128/26        2005-03-27 12:26:42
 529 67      81.162.25.0/26  2005-03-27 12:27:31
 530 204     81.162.71.128/26        2005-03-27 12:34:04
 531 200     81.162.69.128/26        2005-03-27 12:37:19
 532 207     81.162.73.64/26 2005-03-27 12:41:57
 533 203     81.162.71.64/26 2005-03-27 12:58:48
 534 214     81.162.213.0/24 2005-03-27 13:02:26
 535 213     81.162.213.0/24 2005-03-27 13:02:26
 536 209     81.162.212.0/24 2005-03-27 13:16:02
 537 215     81.162.200.0/24 2005-03-27 13:16:14
 538 210     81.162.250.0/24 2005-03-27 13:18:02
 539 211     81.162.252.0/24 2005-03-27 12:39:02
 540 129     81.162.45.128/26        2005-03-27 10:44:11
 541 110     81.162.39.64/26 2005-03-27 08:19:17
 542 10      81.162.6.0/26   2005-03-27 08:35:15
 543 171     81.162.59.128/26        2005-03-27 08:42:52
 544 167     81.162.58.64/26 2005-03-27 09:07:47
 545 180     81.162.62.128/26        2005-03-27 09:22:15
 546 140     81.162.49.64/26 2005-03-27 09:41:51
 547 103     81.162.37.0/26  2005-03-27 09:42:30
 548 55      81.162.21.0/26  2005-03-27 09:42:54
 549 137     81.162.48.64/26 2005-03-27 09:47:06
 550 62      81.162.23.64/26 2005-03-27 09:51:30
 551 158     81.162.55.64/26 2005-03-27 09:51:55
 552 70      81.162.26.0/26  2005-03-27 09:52:09
 553 159     81.162.55.128/26        2005-03-27 10:05:56
 554 165     81.162.57.128/26        2005-03-27 10:09:30
 555 125     81.162.44.64/26 2005-03-27 10:10:14
 556 169     81.162.59.0/26  2005-03-27 10:10:29
 557 89      81.162.32.64/26 2005-03-27 10:11:14
 558 168     81.162.58.128/26        2005-03-27 10:11:42
 559 39      81.162.15.128/26        2005-03-27 10:11:49
 560 134     81.162.47.64/26 2005-03-27 10:12:00
 561 144     81.162.50.128/26        2005-03-27 10:15:46
 562 61      81.162.23.0/26  2005-03-27 10:19:36
 563 186     81.162.64.128/26        2005-03-27 10:24:08
 564 97      81.162.35.0/26  2005-03-27 10:26:13
 565 124     81.162.44.0/26  2005-03-27 10:28:37
 566 162     81.162.56.128/26        2005-03-27 10:36:33
 567 76      81.162.28.0/26  2005-03-27 10:38:20
 568 156     81.162.54.128/26        2005-03-27 10:41:07
 569 93      81.162.33.128/26        2005-03-27 10:42:16
 570 58      81.162.22.0/26  2005-03-27 10:42:50
 571 23      81.162.10.64/26 2005-03-27 10:43:27
 572 132     81.162.46.128/26        2005-03-27 10:46:35
 573 118     81.162.42.0/26  2005-03-27 10:47:16
 574 16      81.162.8.0/26   2005-03-27 10:47:53
 575 182     81.162.63.64/26 2005-03-27 10:47:58
 576 88      81.162.32.0/26  2005-03-27 10:49:28
 577 126     81.162.44.128/26        2005-03-27 10:50:02
 578 130     81.162.46.0/26  2005-03-27 10:50:46
 579 15      81.162.7.128/26 2005-03-27 10:54:20
 580 12      81.162.6.128/26 2005-03-27 10:54:40
 581 98      81.162.35.64/26 2005-03-27 10:55:15
 582 104     81.162.37.64/26 2005-03-27 10:57:11
 583 100     81.162.36.0/26  2005-03-27 10:58:55
 584 45      81.162.17.128/26        2005-03-27 11:02:32
 585 131     81.162.46.64/26 2005-03-27 11:04:23
 586 175     81.162.61.0/26  2005-03-27 11:04:47
 587 72      81.162.26.128/26        2005-03-27 11:04:50
 588 148     81.162.52.0/26  2005-03-27 11:05:19
 589 198     81.162.68.128/26        2005-03-27 11:06:42
 590 68      81.162.25.64/26 2005-03-27 11:06:55
 591 115     81.162.41.0/26  2005-03-27 11:08:58
 592 157     81.162.55.0/26  2005-03-27 11:10:30
 593 111     81.162.39.128/26        2005-03-27 11:11:10
 594 120     81.162.42.128/26        2005-03-27 10:14:01
 595 21      81.162.9.128/26 2005-03-27 10:39:11
 596 64      81.162.24.0/26  2005-03-27 11:14:54
 597 7       81.162.5.0/26   2005-03-27 11:15:07
 598 163     81.162.57.0/26  2005-03-27 11:18:50
 599 208     81.162.73.128/26        2005-03-27 11:18:53
 600 189     81.162.65.128/26        2005-03-27 11:20:12
 601 197     81.162.68.64/26 2005-03-27 11:20:46
 602 31      81.162.13.0/26  2005-03-27 11:22:31
 603 19      81.162.9.0/26   2005-03-27 11:22:48
 604 13      81.162.7.0/26   2005-03-27 11:24:35
 605 147     81.162.51.128/26        2005-03-27 11:27:37
 606 135     81.162.47.128/26        2005-03-27 11:28:43
 607 121     81.162.43.0/26  2005-03-27 11:28:58
 608 136     81.162.48.0/26  2005-03-27 11:31:04
 609 66      81.162.24.128/26        2005-03-27 11:32:10
 610 166     81.162.58.0/26  2005-03-27 09:25:55
 611 138     81.162.48.128/26        2005-03-27 10:08:33
 612 56      81.162.21.64/26 2005-03-27 11:32:34
 613 143     81.162.50.64/26 2005-03-27 11:33:03
 614 176     81.162.61.64/26 2005-03-27 11:33:36
 615 65      81.162.24.64/26 2005-03-27 11:33:40
 616 102     81.162.36.128/26        2005-03-27 11:34:00
 617 116     81.162.41.64/26 2005-03-27 11:34:56
 618 183     81.162.63.128/26        2005-03-27 11:36:02
 619 109     81.162.39.0/26  2005-03-27 11:36:45
 620 25      81.162.11.0/26  2005-03-27 11:37:44
 621 174     81.162.60.128/26        2005-03-27 11:38:11
 622 216     81.162.202.0/24 2005-03-27 11:39:03
 623 40      81.162.16.0/26  2005-03-27 11:39:31
 624 152     81.162.53.64/26 2005-03-27 11:39:47
 625 14      81.162.7.64/26  2005-03-27 11:39:59
 626 92      81.162.33.64/26 2005-03-27 11:40:05
 627 173     81.162.60.64/26 2005-03-27 11:40:28
 628 48      81.162.18.128/26        2005-03-27 11:40:28
 629 8       81.162.5.64/26  2005-03-27 11:40:45
 630 108     81.162.38.128/26        2005-03-27 11:42:43
 631 11      81.162.6.64/26  2005-03-27 08:50:50
 632 188     81.162.65.64/26 2005-03-27 08:55:21
 633 117     81.162.41.128/26        2005-03-27 09:23:35
 634 26      81.162.11.64/26 2005-03-27 11:43:18
 635 172     81.162.60.0/26  2005-03-27 11:43:21
 636 71      81.162.26.64/26 2005-03-27 11:43:51
 637 38      81.162.15.64/26 2005-03-27 11:44:11
 638 153     81.162.53.128/26        2005-03-27 11:45:51
 639 53      81.162.20.64/26 2005-03-27 11:46:24
 640 1       81.162.2.0/26   2005-03-27 11:47:03
 641 2       81.162.2.64/26  2005-03-27 11:47:10
 642 149     81.162.52.64/26 2005-03-27 11:48:35
 643 37      81.162.15.0/26  2005-03-27 11:49:04
 644 127     81.162.45.0/26  2005-03-27 11:49:22
 645 179     81.162.62.64/26 2005-03-27 11:49:48
 646 185     81.162.64.64/26 2005-03-27 11:50:36
 647 142     81.162.50.0/26  2005-03-27 11:51:18
 648 36      81.162.14.128/26        2005-03-27 11:51:19
 649 30      81.162.12.128/26        2005-03-27 11:51:20
 650 60      81.162.22.128/26        2005-03-27 11:52:08
 651 49      81.162.19.0/26  2005-03-27 10:22:15
 652 73      81.162.27.0/26  2005-03-27 11:27:55
 653 96      81.162.34.128/26        2005-03-27 11:32:26
 654 101     81.162.36.64/26 2005-03-27 11:40:47
 655 181     81.162.63.0/26  2005-03-27 11:52:55
 656 187     81.162.65.0/26  2005-03-27 11:53:23
 657 161     81.162.56.64/26 2005-03-27 08:54:44
 658 \.
 659
 660
 661 --
 662 -- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: postgres
 663 --
 664
 665 COPY placements (switch, placement) FROM stdin;
 666 221     (375,325),(350,300)
 667 222     (550,325),(525,300)
 668 224     (775,325),(750,300)
 669 223     (875,325),(850,300)
 670 225     (675,325),(650,300)
 671 218     (980,550),(930,520)
 672 1       (306,306),(294,256)
 673 2       (306,256),(294,206)
 674 3       (306,206),(294,156)
 675 4       (325,306),(313,256)
 676 5       (325,256),(313,206)
 677 6       (325,206),(313,156)
 678 7       (344,470),(332,422)
 679 8       (344,422),(332,374)
 680 9       (344,374),(332,326)
 681 10      (344,306),(332,256)
 682 11      (344,256),(332,206)
 683 12      (344,206),(332,156)
 684 13      (363,470),(351,422)
 685 14      (363,422),(351,374)
 686 15      (363,374),(351,326)
 687 16      (363,306),(351,256)
 688 17      (363,256),(351,206)
 689 18      (363,206),(351,156)
 690 19      (382,470),(370,422)
 691 20      (382,422),(370,374)
 692 21      (382,374),(370,326)
 693 22      (382,306),(370,256)
 694 23      (382,256),(370,206)
 695 24      (382,206),(370,156)
 696 25      (400,470),(388,422)
 697 26      (400,422),(388,374)
 698 27      (400,374),(388,326)
 699 28      (400,306),(388,256)
 700 29      (400,256),(388,206)
 701 30      (400,206),(388,156)
 702 31      (419,470),(407,422)
 703 32      (419,422),(407,374)
 704 33      (419,374),(407,326)
 705 34      (419,306),(407,256)
 706 35      (419,256),(407,206)
 707 36      (419,206),(407,156)
 708 37      (438,470),(426,422)
 709 38      (438,422),(426,374)
 710 39      (438,374),(426,326)
 711 40      (438,306),(426,256)
 712 41      (438,256),(426,206)
 713 42      (438,206),(426,156)
 714 43      (457,470),(445,422)
 715 44      (457,422),(445,374)
 716 45      (457,374),(445,326)
 717 46      (457,306),(445,256)
 718 47      (457,256),(445,206)
 719 48      (457,206),(445,156)
 720 49      (483,470),(471,422)
 721 50      (483,422),(471,374)
 722 51      (483,374),(471,326)
 723 52      (483,306),(471,256)
 724 53      (483,256),(471,206)
 725 54      (483,206),(471,156)
 726 55      (502,470),(490,422)
 727 56      (502,422),(490,374)
 728 57      (502,374),(490,326)
 729 58      (502,306),(490,256)
 730 59      (502,256),(490,206)
 731 60      (502,206),(490,156)
 732 61      (521,470),(509,422)
 733 62      (521,422),(509,374)
 734 63      (521,374),(509,326)
 735 64      (521,306),(509,256)
 736 65      (521,256),(509,206)
 737 66      (521,206),(509,156)
 738 67      (540,470),(528,422)
 739 68      (540,422),(528,374)
 740 69      (540,374),(528,326)
 741 70      (540,306),(528,256)
 742 71      (540,256),(528,206)
 743 72      (540,206),(528,156)
 744 73      (559,470),(547,422)
 745 74      (559,422),(547,374)
 746 75      (559,374),(547,326)
 747 76      (559,306),(547,256)
 748 77      (559,256),(547,206)
 749 78      (559,206),(547,156)
 750 79      (578,470),(566,422)
 751 80      (578,422),(566,374)
 752 81      (578,374),(566,326)
 753 82      (578,306),(566,256)
 754 83      (578,256),(566,206)
 755 84      (578,206),(566,156)
 756 85      (596,470),(584,422)
 757 86      (596,422),(584,374)
 758 87      (596,374),(584,326)
 759 88      (596,306),(584,256)
 760 89      (596,256),(584,206)
 761 90      (596,206),(584,156)
 762 91      (615,470),(603,422)
 763 92      (615,422),(603,374)
 764 93      (615,374),(603,326)
 765 94      (615,306),(603,256)
 766 95      (615,256),(603,206)
 767 96      (615,206),(603,156)
 768 97      (648,470),(636,422)
 769 98      (648,422),(636,374)
 770 99      (648,374),(636,326)
 771 100     (648,306),(636,256)
 772 101     (648,256),(636,206)
 773 102     (648,206),(636,156)
 774 103     (667,470),(655,422)
 775 104     (667,422),(655,374)
 776 105     (667,374),(655,326)
 777 106     (667,306),(655,256)
 778 107     (667,256),(655,206)
 779 108     (667,206),(655,156)
 780 109     (686,470),(674,422)
 781 110     (686,422),(674,374)
 782 111     (686,374),(674,326)
 783 112     (686,306),(674,256)
 784 113     (686,256),(674,206)
 785 114     (686,206),(674,156)
 786 115     (705,470),(693,422)
 787 116     (705,422),(693,374)
 788 117     (705,374),(693,326)
 789 118     (705,306),(693,256)
 790 119     (705,256),(693,206)
 791 120     (705,206),(693,156)
 792 121     (724,470),(712,422)
 793 122     (724,422),(712,374)
 794 123     (724,374),(712,326)
 795 124     (724,306),(712,256)
 796 125     (724,256),(712,206)
 797 126     (724,206),(712,156)
 798 127     (743,470),(731,422)
 799 128     (743,422),(731,374)
 800 129     (743,374),(731,326)
 801 130     (743,306),(731,256)
 802 131     (743,256),(731,206)
 803 132     (743,206),(731,156)
 804 133     (762,470),(750,422)
 805 134     (762,422),(750,374)
 806 135     (762,374),(750,326)
 807 136     (762,306),(750,256)
 808 137     (762,256),(750,206)
 809 138     (762,206),(750,156)
 810 139     (781,470),(769,422)
 811 140     (781,422),(769,374)
 812 141     (781,374),(769,326)
 813 142     (781,306),(769,256)
 814 143     (781,256),(769,206)
 815 144     (781,206),(769,156)
 816 145     (808,470),(796,422)
 817 146     (808,422),(796,374)
 818 147     (808,374),(796,326)
 819 148     (808,306),(796,256)
 820 149     (808,256),(796,206)
 821 150     (808,206),(796,156)
 822 151     (827,470),(815,422)
 823 152     (827,422),(815,374)
 824 153     (827,374),(815,326)
 825 154     (827,306),(815,256)
 826 155     (827,256),(815,206)
 827 156     (827,206),(815,156)
 828 157     (846,470),(834,422)
 829 158     (846,422),(834,374)
 830 159     (846,374),(834,326)
 831 160     (846,306),(834,256)
 832 161     (846,256),(834,206)
 833 162     (846,206),(834,156)
 834 163     (865,470),(853,422)
 835 164     (865,422),(853,374)
 836 165     (865,374),(853,326)
 837 166     (865,306),(853,256)
 838 167     (865,256),(853,206)
 839 168     (865,206),(853,156)
 840 169     (884,470),(872,422)
 841 170     (884,422),(872,374)
 842 171     (884,374),(872,326)
 843 172     (884,306),(872,256)
 844 173     (884,256),(872,206)
 845 174     (884,206),(872,156)
 846 175     (903,470),(891,422)
 847 176     (903,422),(891,374)
 848 177     (903,374),(891,326)
 849 178     (903,306),(891,256)
 850 179     (903,256),(891,206)
 851 180     (903,206),(891,156)
 852 181     (922,470),(910,422)
 853 182     (922,422),(910,374)
 854 183     (922,374),(910,326)
 855 184     (922,306),(910,256)
 856 185     (922,256),(910,206)
 857 186     (922,206),(910,156)
 858 187     (941,470),(929,422)
 859 188     (941,422),(929,374)
 860 189     (941,374),(929,326)
 861 190     (941,306),(929,256)
 862 191     (941,256),(929,206)
 863 192     (941,206),(929,156)
 864 193     (960,470),(948,422)
 865 194     (960,422),(948,374)
 866 195     (960,374),(948,326)
 867 196     (960,306),(948,256)
 868 197     (960,256),(948,206)
 869 198     (960,206),(948,156)
 870 199     (988,422),(976,374)
 871 200     (988,374),(976,326)
 872 201     (979,306),(967,256)
 873 202     (979,256),(967,206)
 874 203     (1006,422),(994,374)
 875 204     (1006,374),(994,326)
 876 205     (997,306),(985,256)
 877 207     (1025,422),(1013,374)
 878 208     (1025,374),(1013,326)
 879 209     (1125,225),(1100,200)
 880 210     (680,550),(630,520)
 881 211     (610,550),(560,520)
 882 212     (305,385),(270,350)
 883 213     (900,100),(800,75)
 884 214     (900,100),(800,75)
 885 215     (200,270),(170,240)
 886 216     (250,180),(220,150)
 887 \.
 888
 889
 890 --
 891 -- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: postgres
 892 --
 893
 894 \.
 895
 896
 897 --
 898 -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres
 899 --
 900
 901 COPY portnames (switchtype, port, description) FROM stdin;
 902 blackdiamond    1001    BD6808/G8Xi-Port 1:1
 903 blackdiamond    1002    BD6808/G8Xi-Port 1:2
 904 blackdiamond    1003    BD6808/G8Xi-Port 1:3
 905 blackdiamond    1004    BD6808/G8Xi-Port 1:4
 906 blackdiamond    1005    BD6808/G8Xi-Port 1:5
 907 blackdiamond    1006    BD6808/G8Xi-Port 1:6
 908 blackdiamond    1007    BD6808/G8Xi-Port 1:7
 909 blackdiamond    4001    BD6808/G16X3-Port 4:1
 910 blackdiamond    4002    BD6808/G16X3-Port 4:2
 911 blackdiamond    4003    BD6808/G16X3-Port 4:3
 912 blackdiamond    4004    BD6808/G16X3-Port 4:4
 913 blackdiamond    4005    BD6808/G16X3-Port 4:5
 914 blackdiamond    4006    BD6808/G16X3-Port 4:6
 915 blackdiamond    4007    BD6808/G16X3-Port 4:7
 916 blackdiamond    4008    BD6808/G16X3-Port 4:8
 917 blackdiamond    4009    BD6808/G16X3-Port 4:9
 918 blackdiamond    4010    BD6808/G16X3-Port 4:10
 919 blackdiamond    4011    BD6808/G16X3-Port 4:11
 920 blackdiamond    4012    BD6808/G16X3-Port 4:12
 921 blackdiamond    4013    BD6808/G16X3-Port 4:13
 922 blackdiamond    4014    BD6808/G16X3-Port 4:14
 923 blackdiamond    4015    BD6808/G16X3-Port 4:15
 924 blackdiamond    4016    BD6808/G16X3-Port 4:16
 925 blackdiamond    5001    BD6808/G24T3-Port 5:1
 926 blackdiamond    5002    BD6808/G24T3-Port 5:2
 927 blackdiamond    5003    BD6808/G24T3-Port 5:3
 928 blackdiamond    5004    BD6808/G24T3-Port 5:4
 929 blackdiamond    5005    BD6808/G24T3-Port 5:5
 930 blackdiamond    5006    BD6808/G24T3-Port 5:6
 931 blackdiamond    5007    BD6808/G24T3-Port 5:7
 932 blackdiamond    5008    BD6808/G24T3-Port 5:8
 933 blackdiamond    5009    BD6808/G24T3-Port 5:9
 934 blackdiamond    5010    BD6808/G24T3-Port 5:10
 935 blackdiamond    5011    BD6808/G24T3-Port 5:11
 936 blackdiamond    5012    BD6808/G24T3-Port 5:12
 937 blackdiamond    5013    BD6808/G24T3-Port 5:13
 938 blackdiamond    5014    BD6808/G24T3-Port 5:14
 939 blackdiamond    5015    BD6808/G24T3-Port 5:15
 940 blackdiamond    5016    BD6808/G24T3-Port 5:16
 941 blackdiamond    5017    BD6808/G24T3-Port 5:17
 942 blackdiamond    5018    BD6808/G24T3-Port 5:18
 943 blackdiamond    5019    BD6808/G24T3-Port 5:19
 944 blackdiamond    5020    BD6808/G24T3-Port 5:20
 945 blackdiamond    5021    BD6808/G24T3-Port 5:21
 946 blackdiamond    5022    BD6808/G24T3-Port 5:22
 947 blackdiamond    5023    BD6808/G24T3-Port 5:23
 948 blackdiamond    5024    BD6808/G24T3-Port 5:24
 949 blackdiamond    6001    BD6808/F48Ti-Port 6:1
 950 blackdiamond    6002    BD6808/F48Ti-Port 6:2
 951 blackdiamond    6003    BD6808/F48Ti-Port 6:3
 952 blackdiamond    6004    BD6808/F48Ti-Port 6:4
 953 blackdiamond    6005    BD6808/F48Ti-Port 6:5
 954 blackdiamond    6006    BD6808/F48Ti-Port 6:6
 955 blackdiamond    6007    BD6808/F48Ti-Port 6:7
 956 blackdiamond    6008    BD6808/F48Ti-Port 6:8
 957 blackdiamond    6009    BD6808/F48Ti-Port 6:9
 958 blackdiamond    6010    BD6808/F48Ti-Port 6:10
 959 blackdiamond    6011    BD6808/F48Ti-Port 6:11
 960 blackdiamond    6012    BD6808/F48Ti-Port 6:12
 961 blackdiamond    6013    BD6808/F48Ti-Port 6:13
 962 blackdiamond    6014    BD6808/F48Ti-Port 6:14
 963 blackdiamond    6015    BD6808/F48Ti-Port 6:15
 964 blackdiamond    6016    BD6808/F48Ti-Port 6:16
 965 blackdiamond    6017    BD6808/F48Ti-Port 6:17
 966 blackdiamond    6018    BD6808/F48Ti-Port 6:18
 967 blackdiamond    6019    BD6808/F48Ti-Port 6:19
 968 blackdiamond    6020    BD6808/F48Ti-Port 6:20
 969 blackdiamond    6021    BD6808/F48Ti-Port 6:21
 970 blackdiamond    6022    BD6808/F48Ti-Port 6:22
 971 blackdiamond    6023    BD6808/F48Ti-Port 6:23
 972 blackdiamond    6024    BD6808/F48Ti-Port 6:24
 973 blackdiamond    6025    BD6808/F48Ti-Port 6:25
 974 blackdiamond    6026    BD6808/F48Ti-Port 6:26
 975 blackdiamond    6027    BD6808/F48Ti-Port 6:27
 976 blackdiamond    6028    BD6808/F48Ti-Port 6:28
 977 blackdiamond    6029    BD6808/F48Ti-Port 6:29
 978 blackdiamond    6030    BD6808/F48Ti-Port 6:30
 979 blackdiamond    6031    BD6808/F48Ti-Port 6:31
 980 blackdiamond    6032    BD6808/F48Ti-Port 6:32
 981 blackdiamond    6033    BD6808/F48Ti-Port 6:33
 982 blackdiamond    6034    BD6808/F48Ti-Port 6:34
 983 blackdiamond    6035    BD6808/F48Ti-Port 6:35
 984 blackdiamond    6036    BD6808/F48Ti-Port 6:36
 985 blackdiamond    6037    BD6808/F48Ti-Port 6:37
 986 blackdiamond    6038    BD6808/F48Ti-Port 6:38
 987 blackdiamond    6039    BD6808/F48Ti-Port 6:39
 988 blackdiamond    6040    BD6808/F48Ti-Port 6:40
 989 blackdiamond    6041    BD6808/F48Ti-Port 6:41
 990 blackdiamond    6042    BD6808/F48Ti-Port 6:42
 991 blackdiamond    6043    BD6808/F48Ti-Port 6:43
 992 blackdiamond    6044    BD6808/F48Ti-Port 6:44
 993 blackdiamond    6045    BD6808/F48Ti-Port 6:45
 994 blackdiamond    6046    BD6808/F48Ti-Port 6:46
 995 blackdiamond    6047    BD6808/F48Ti-Port 6:47
 996 blackdiamond    6048    BD6808/F48Ti-Port 6:48
 997 cisco6509       1       GigabitEthernet1/1
 998 cisco6509       2       GigabitEthernet1/2
 999 cisco6509       3       GigabitEthernet1/3
1000 cisco6509       4       GigabitEthernet1/4
1001 cisco6509       5       GigabitEthernet1/5
1002 cisco6509       6       GigabitEthernet1/6
1003 cisco6509       7       GigabitEthernet1/7
1004 cisco6509       8       GigabitEthernet1/8
1005 cisco6509       9       GigabitEthernet1/9
1006 cisco6509       10      GigabitEthernet1/10
1007 cisco6509       11      GigabitEthernet1/11
1008 cisco6509       12      GigabitEthernet1/12
1009 cisco6509       13      GigabitEthernet1/13
1010 cisco6509       14      GigabitEthernet1/14
1011 cisco6509       15      GigabitEthernet1/15
1012 cisco6509       16      GigabitEthernet1/16
1013 cisco6509       17      GigabitEthernet1/17
1014 cisco6509       18      GigabitEthernet1/18
1015 cisco6509       19      GigabitEthernet1/19
1016 cisco6509       20      GigabitEthernet1/20
1017 cisco6509       21      GigabitEthernet1/21
1018 cisco6509       22      GigabitEthernet1/22
1019 cisco6509       23      GigabitEthernet1/23
1020 cisco6509       24      GigabitEthernet1/24
1021 cisco6509       25      GigabitEthernet1/25
1022 cisco6509       26      GigabitEthernet1/26
1023 cisco6509       27      GigabitEthernet1/27
1024 cisco6509       28      GigabitEthernet1/28
1025 cisco6509       29      GigabitEthernet1/29
1026 cisco6509       30      GigabitEthernet1/30
1027 cisco6509       31      GigabitEthernet1/31
1028 cisco6509       32      GigabitEthernet1/32
1029 cisco6509       33      GigabitEthernet1/33
1030 cisco6509       34      GigabitEthernet1/34
1031 cisco6509       35      GigabitEthernet1/35
1032 cisco6509       36      GigabitEthernet1/36
1033 cisco6509       37      GigabitEthernet1/37
1034 cisco6509       38      GigabitEthernet1/38
1035 cisco6509       39      GigabitEthernet1/39
1036 cisco6509       40      GigabitEthernet1/40
1037 cisco6509       41      GigabitEthernet1/41
1038 cisco6509       42      GigabitEthernet1/42
1039 cisco6509       43      GigabitEthernet1/43
1040 cisco6509       44      GigabitEthernet1/44
1041 cisco6509       45      GigabitEthernet1/45
1042 cisco6509       46      GigabitEthernet1/46
1043 cisco6509       47      GigabitEthernet1/47
1044 cisco6509       48      GigabitEthernet1/48
1045 cisco6509       49      GigabitEthernet2/1
1046 cisco6509       50      GigabitEthernet2/2
1047 cisco6509       51      GigabitEthernet2/3
1048 cisco6509       52      GigabitEthernet2/4
1049 cisco6509       53      GigabitEthernet2/5
1050 cisco6509       54      GigabitEthernet2/6
1051 cisco6509       55      GigabitEthernet2/7
1052 cisco6509       56      GigabitEthernet2/8
1053 cisco6509       57      GigabitEthernet2/9
1054 cisco6509       58      GigabitEthernet2/10
1055 cisco6509       59      GigabitEthernet2/11
1056 cisco6509       60      GigabitEthernet2/12
1057 cisco6509       61      GigabitEthernet2/13
1058 cisco6509       62      GigabitEthernet2/14
1059 cisco6509       63      GigabitEthernet2/15
1060 cisco6509       64      GigabitEthernet2/16
1061 cisco6509       65      FastEthernet4/1
1062 cisco6509       66      FastEthernet4/2
1063 cisco6509       67      FastEthernet4/3
1064 cisco6509       68      FastEthernet4/4
1065 cisco6509       69      FastEthernet4/5
1066 cisco6509       70      FastEthernet4/6
1067 cisco6509       71      FastEthernet4/7
1068 cisco6509       72      FastEthernet4/8
1069 cisco6509       73      FastEthernet4/9
1070 cisco6509       74      FastEthernet4/10
1071 cisco6509       75      FastEthernet4/11
1072 cisco6509       76      FastEthernet4/12
1073 cisco6509       77      FastEthernet4/13
1074 cisco6509       78      FastEthernet4/14
1075 cisco6509       79      FastEthernet4/15
1076 cisco6509       80      FastEthernet4/16
1077 cisco6509       81      FastEthernet4/17
1078 cisco6509       82      FastEthernet4/18
1079 cisco6509       83      FastEthernet4/19
1080 cisco6509       84      FastEthernet4/20
1081 cisco6509       85      FastEthernet4/21
1082 cisco6509       86      FastEthernet4/22
1083 cisco6509       87      FastEthernet4/23
1084 cisco6509       88      FastEthernet4/24
1085 cisco6509       89      FastEthernet4/25
1086 cisco6509       90      FastEthernet4/26
1087 cisco6509       91      FastEthernet4/27
1088 cisco6509       92      FastEthernet4/28
1089 cisco6509       93      FastEthernet4/29
1090 cisco6509       94      FastEthernet4/30
1091 cisco6509       95      FastEthernet4/31
1092 cisco6509       96      FastEthernet4/32
1093 cisco6509       97      FastEthernet4/33
1094 cisco6509       98      FastEthernet4/34
1095 cisco6509       99      FastEthernet4/35
1096 cisco6509       100     FastEthernet4/36
1097 cisco6509       101     FastEthernet4/37
1098 cisco6509       102     FastEthernet4/38
1099 cisco6509       103     FastEthernet4/39
1100 cisco6509       104     FastEthernet4/40
1101 cisco6509       105     FastEthernet4/41
1102 cisco6509       106     FastEthernet4/42
1103 cisco6509       107     FastEthernet4/43
1104 cisco6509       108     FastEthernet4/44
1105 cisco6509       109     FastEthernet4/45
1106 cisco6509       110     FastEthernet4/46
1107 cisco6509       111     FastEthernet4/47
1108 cisco6509       112     FastEthernet4/48
1109 cisco6509       113     GigabitEthernet5/1
1110 cisco6509       114     GigabitEthernet5/2
1111 cisco6509       115     GigabitEthernet8/1
1112 cisco6509       116     GigabitEthernet8/2
1113 cisco6509       117     GigabitEthernet8/3
1114 cisco6509       118     GigabitEthernet8/4
1115 cisco6509       119     GigabitEthernet8/5
1116 cisco6509       120     GigabitEthernet8/6
1117 cisco6509       121     GigabitEthernet8/7
1118 cisco6509       122     GigabitEthernet8/8
1119 cisco6509       123     GigabitEthernet8/9
1120 \.
1121
1122
1123 --
1124 -- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: postgres
1125 --
1126
1127 COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin;
1128 107     81.162.243.120  e37-5sw es3024  2005-03-27 13:17:34.571591+02   f       0       00:05:00        removed
1129 82      81.162.242.95   e29-4sw es3024  2005-03-27 13:16:26.93166+02    f       0       00:05:00        removed
1130 104     81.162.243.117  e37-2sw es3024  2005-03-27 13:17:56.76605+02    f       0       00:05:00        removed
1131 54      81.162.242.67   e19-6sw es3024  2005-03-27 13:18:06.955298+02   f       0       00:05:00        removed
1132 112     81.162.243.125  e39-4sw es3024  2005-03-27 13:18:08.119358+02   f       0       00:05:00        removed
1133 99      81.162.243.112  e35-3sw es3024  2005-03-27 13:18:18.138712+02   f       0       00:05:00        removed
1134 96      81.162.243.109  e33-6sw es3024  2005-03-27 13:19:12.471088+02   f       0       00:05:00        removed
1135 189     81.162.245.202  e65-3sw es3024  2005-03-27 13:19:14.973227+02   f       0       00:05:00        removed
1136 22      81.162.241.35   e9-4sw  es3024  2005-03-27 13:20:32.530723+02   f       0       00:05:00        removed
1137 11      81.162.241.24   e5-5sw  es3024  2005-03-27 13:20:41.845068+02   f       0       00:05:00        removed
1138 168     81.162.244.181  e57-6sw es3024  2005-03-27 13:20:42.537996+02   f       0       00:05:00        removed
1139 21      81.162.241.34   e9-3sw  es3024  2005-03-27 13:21:34.547743+02   t       0       00:05:00        removed
1140 45      81.162.242.58   e17-3sw es3024  2005-03-27 13:21:35.095512+02   t       0       00:05:00        removed
1141 171     81.162.245.184  e59-3sw es3024  2005-03-27 13:21:42.545292+02   t       0       00:05:00        removed
1142 191     81.162.245.204  e65-5sw es3024  2005-03-27 13:16:31.123889+02   f       0       00:05:00        removed
1143 209     127.0.0.1       game    es3024  2005-03-27 13:17:24.559535+02   f       0       00:05:00        removed
1144 213     127.0.0.1       logistics       es3024  2005-03-27 13:17:24.565673+02   f       0       00:05:00        removed
1145 65      81.162.242.78   e23-5sw es3024  2005-03-27 13:17:46.939821+02   f       0       00:05:00        removed
1146 170     81.162.245.183  e59-2sw es3024  2005-03-27 13:18:04.978308+02   f       0       00:05:00        removed
1147 27      81.162.241.40   e11-3sw es3024  2005-03-27 13:18:17.760774+02   f       0       00:05:00        removed
1148 29      81.162.241.42   e11-5sw es3024  2005-03-27 13:18:31.402994+02   f       0       00:05:00        removed
1149 190     81.162.245.203  e65-4sw es3024  2005-03-27 13:18:36.97826+02    f       0       00:05:00        removed
1150 198     81.162.245.211  e67-6sw es3024  2005-03-27 13:18:46.960978+02   f       0       00:05:00        removed
1151 94      81.162.243.107  e33-4sw es3024  2005-03-27 13:18:54.836293+02   f       0       00:05:00        removed
1152 167     81.162.244.180  e57-5sw es3024  2005-03-27 13:18:59.347337+02   f       0       00:05:00        removed
1153 207     81.162.245.220  e73-2sw es3024  2005-03-27 13:16:31.90388+02    f       0       00:05:00        removed
1154 121     81.162.243.134  e43-1sw es3024  2005-03-27 13:17:32.374414+02   f       0       00:05:00        removed
1155 35      81.162.241.48   e13-5sw es3024  2005-03-27 13:17:36.647606+02   f       0       00:05:00        removed
1156 48      81.162.242.61   e17-6sw es3024  2005-03-27 13:17:37.509652+02   f       0       00:05:00        removed
1157 39      81.162.241.52   e15-3sw es3024  2005-03-27 13:17:46.961826+02   f       0       00:05:00        removed
1158 28      81.162.241.41   e11-4sw es3024  2005-03-27 13:17:46.6959+02     f       0       00:05:00        removed
1159 109     81.162.243.122  e39-1sw es3024  2005-03-27 13:17:56.906062+02   f       0       00:05:00        removed
1160 25      81.162.241.38   e11-1sw es3024  2005-03-27 13:18:31.344059+02   f       0       00:05:00        removed
1161 72      81.162.242.85   e25-6sw es3024  2005-03-27 13:18:52.027008+02   f       0       00:05:00        removed
1162 155     81.162.244.168  e53-5sw es3024  2005-03-27 13:19:11.997064+02   f       0       00:05:00        removed
1163 19      81.162.241.32   e9-1sw  es3024  2005-03-27 13:20:23.30851+02    f       0       00:05:00        removed
1164 42      81.162.241.55   e15-6sw es3024  2005-03-27 13:20:23.334654+02   f       0       00:05:00        removed
1165 180     81.162.245.193  e61-6sw es3024  2005-03-27 13:20:37.173987+02   f       0       00:05:00        removed
1166 200     81.162.245.213  e69-3sw es3024  2005-03-27 13:20:47.20716+02    f       0       00:05:00        removed
1167 224     81.162.239.24   d04     summit400       2005-03-27 13:21:24.972747+02   f       5       00:00:20        removed
1168 219     81.162.240.61   game-gw summit48        2005-03-27 13:21:33.484975+02   t       5       00:00:20        removed
1169 88      81.162.243.101  e31-4sw es3024  2005-03-27 13:16:26.527548+02   f       0       00:05:00        removed
1170 113     81.162.243.126  e39-5sw es3024  2005-03-27 13:18:06.543322+02   f       0       00:05:00        removed
1171 64      81.162.242.77   e23-4sw es3024  2005-03-27 13:18:26.656294+02   f       0       00:05:00        removed
1172 81      81.162.242.94   e29-3sw es3024  2005-03-27 13:17:35.445561+02   f       0       00:05:00        removed
1173 101     81.162.243.114  e35-5sw es3024  2005-03-27 13:17:36.945531+02   f       0       00:05:00        removed
1174 16      81.162.241.29   e7-4sw  es3024  2005-03-27 13:17:45.453891+02   f       0       00:05:00        removed
1175 43      81.162.242.56   e17-1sw es3024  2005-03-27 13:17:55.459964+02   f       0       00:05:00        removed
1176 122     81.162.243.135  e43-2sw es3024  2005-03-27 13:18:05.467243+02   f       0       00:05:00        removed
1177 133     81.162.244.146  e47-1sw es3024  2005-03-27 13:18:41.709491+02   f       0       00:05:00        removed
1178 32      81.162.241.45   e13-2sw es3024  2005-03-27 13:19:11.73096+02    f       0       00:05:00        removed
1179 4       81.162.241.17   e3-4sw  es3024  2005-03-27 13:19:21.737736+02   f       0       00:05:00        removed
1180 80      81.162.242.93   e29-2sw es3024  2005-03-27 13:20:34.240028+02   f       0       00:05:00        removed
1181 62      81.162.242.75   e23-2sw es3024  2005-03-27 13:21:31.873108+02   f       0       00:05:00        removed
1182 214     127.0.0.1       logistics       es3024  2005-03-27 13:21:31.924796+02   f       0       00:05:00        removed
1183 215     127.0.0.1       vision  es3024  2005-03-27 13:21:31.930782+02   f       0       00:05:00        removed
1184 57      81.162.242.70   e21-3sw es3024  2005-03-27 13:21:40.84502+02    f       0       00:05:00        removed
1185 146     81.162.244.159  e51-2sw es3024  2005-03-27 13:17:45.214911+02   f       0       00:05:00        removed
1186 47      81.162.242.60   e17-5sw es3024  2005-03-27 13:17:51.983994+02   f       0       00:05:00        removed
1187 140     81.162.244.153  e49-2sw es3024  2005-03-27 13:18:28.990817+02   f       0       00:05:00        removed
1188 186     81.162.245.199  e63-6sw es3024  2005-03-27 13:18:38.997342+02   f       0       00:05:00        removed
1189 152     81.162.244.165  e53-2sw es3024  2005-03-27 13:18:49.281799+02   f       0       00:05:00        removed
1190 108     81.162.243.121  e37-6sw es3024  2005-03-27 13:19:01.723458+02   f       0       00:05:00        removed
1191 158     81.162.244.171  e55-2sw es3024  2005-03-27 13:19:09.602985+02   f       0       00:05:00        removed
1192 178     81.162.245.191  e61-4sw es3024  2005-03-27 13:19:19.609527+02   f       0       00:05:00        removed
1193 85      81.162.243.98   e31-1sw es3024  2005-03-27 13:20:29.849688+02   f       0       00:05:00        removed
1194 70      81.162.242.83   e25-4sw es3024  2005-03-27 13:20:39.869994+02   f       0       00:05:00        removed
1195 75      81.162.242.88   e27-3sw es3024  2005-03-27 13:20:49.343969+02   f       0       00:05:00        removed
1196 223     81.162.245.2    d05     summit400       2005-03-27 13:21:36.931022+02   t       5       00:00:20        removed
1197 61      81.162.242.74   e23-1sw es3024  2005-03-27 13:16:26.916608+02   f       0       00:05:00        removed
1198 149     81.162.244.162  e51-5sw es3024  2005-03-27 13:17:41.922862+02   f       0       00:05:00        removed
1199 157     81.162.244.170  e55-1sw es3024  2005-03-27 13:18:18.9515+02     f       0       00:05:00        removed
1200 63      81.162.242.76   e23-3sw es3024  2005-03-27 13:18:27.768739+02   f       0       00:05:00        removed
1201 141     81.162.244.154  e49-3sw es3024  2005-03-27 13:18:31.991117+02   f       0       00:05:00        removed
1202 84      81.162.242.97   e29-6sw es3024  2005-03-27 13:18:37.040327+02   f       0       00:05:00        removed
1203 18      81.162.241.31   e7-6sw  es3024  2005-03-27 13:18:41.999541+02   f       0       00:05:00        removed
1204 97      81.162.243.110  e35-1sw es3024  2005-03-27 13:18:45.253797+02   f       0       00:05:00        removed
1205 195     81.162.245.208  e67-3sw es3024  2005-03-27 13:18:51.715929+02   f       0       00:05:00        removed
1206 127     81.162.244.140  e45-1sw es3024  2005-03-27 13:19:02.072477+02   f       0       00:05:00        removed
1207 98      81.162.243.111  e35-2sw es3024  2005-03-27 13:19:04.918692+02   f       0       00:05:00        removed
1208 150     81.162.244.163  e51-6sw es3024  2005-03-27 13:20:32.007722+02   f       0       00:05:00        removed
1209 23      81.162.241.36   e9-5sw  es3024  2005-03-27 13:20:41.903998+02   f       0       00:05:00        removed
1210 201     81.162.245.214  e69-4sw es3024  2005-03-27 13:20:49.876993+02   f       0       00:05:00        removed
1211 30      81.162.241.43   e11-6sw es3024  2005-03-27 13:17:56.948002+02   f       0       00:05:00        removed
1212 87      81.162.243.100  e31-3sw es3024  2005-03-27 13:17:58.687121+02   f       0       00:05:00        removed
1213 86      81.162.243.99   e31-2sw es3024  2005-03-27 13:18:05.554204+02   f       0       00:05:00        removed
1214 14      81.162.241.27   e7-2sw  es3024  2005-03-27 13:18:08.944334+02   f       0       00:05:00        removed
1215 10      81.162.241.23   e5-4sw  es3024  2005-03-27 13:18:16.601602+02   f       0       00:05:00        removed
1216 17      81.162.241.30   e7-5sw  es3024  2005-03-27 13:18:28.157952+02   f       0       00:05:00        removed
1217 9       81.162.241.22   e5-3sw  es3024  2005-03-27 13:18:36.939248+02   f       0       00:05:00        removed
1218 67      81.162.242.80   e25-1sw es3024  2005-03-27 13:18:51.943995+02   f       0       00:05:00        removed
1219 7       81.162.241.20   e5-1sw  es3024  2005-03-27 13:18:58.991329+02   f       0       00:05:00        removed
1220 92      81.162.243.105  e33-2sw es3024  2005-03-27 13:19:06.989323+02   f       0       00:05:00        removed
1221 71      81.162.242.84   e25-5sw es3024  2005-03-27 13:19:09.011272+02   f       0       00:05:00        removed
1222 179     81.162.245.192  e61-5sw es3024  2005-03-27 13:20:29.194747+02   f       0       00:05:00        removed
1223 124     81.162.243.137  e43-4sw es3024  2005-03-27 13:20:39.258962+02   f       0       00:05:00        removed
1224 162     81.162.244.175  e55-6sw es3024  2005-03-27 13:20:42.061636+02   f       0       00:05:00        removed
1225 78      81.162.242.91   e27-6sw es3024  2005-03-27 13:16:29.572827+02   f       0       00:05:00        removed
1226 176     81.162.245.189  e61-2sw es3024  2005-03-27 13:17:32.393394+02   f       0       00:05:00        removed
1227 105     81.162.243.118  e37-3sw es3024  2005-03-27 13:17:45.539842+02   f       0       00:05:00        removed
1228 116     81.162.243.129  e41-2sw es3024  2005-03-27 13:17:42.437966+02   f       0       00:05:00        removed
1229 119     81.162.243.132  e41-5sw es3024  2005-03-27 13:18:07.716339+02   f       0       00:05:00        removed
1230 31      81.162.241.44   e13-1sw es3024  2005-03-27 13:18:44.72174+02    f       0       00:05:00        removed
1231 203     81.162.245.216  e71-2sw es3024  2005-03-27 13:20:52.126954+02   f       0       00:05:00        removed
1232 217     81.162.239.1    inet-gw cisco3550       2005-03-27 13:21:34.339813+02   f       5       00:00:20        removed
1233 221     81.162.241.2    d01     summit400       2005-03-27 13:21:38.690758+02   f       5       00:00:20        removed
1234 220     81.162.240.7    info-gw summit48        2005-03-27 13:21:38.74123+02    t       5       00:00:20        removed
1235 37      81.162.241.50   e15-1sw es3024  2005-03-27 13:21:42.323351+02   t       0       00:05:00        removed
1236 53      81.162.242.66   e19-5sw es3024  2005-03-27 13:17:44.668027+02   f       0       00:05:00        removed
1237 192     81.162.245.205  e65-6sw es3024  2005-03-27 13:19:11.969024+02   f       0       00:05:00        removed
1238 46      81.162.242.59   e17-4sw es3024  2005-03-27 13:20:43.449971+02   f       0       00:05:00        removed
1239 204     81.162.245.217  e71-3sw es3024  2005-03-27 13:20:52.107916+02   f       0       00:05:00        removed
1240 161     81.162.244.174  e55-5sw es3024  2005-03-27 13:21:35.234881+02   t       0       00:05:00        removed
1241 142     81.162.244.155  e49-4sw es3024  2005-03-27 13:21:41.936852+02   f       0       00:05:00        removed
1242 143     81.162.244.156  e49-5sw es3024  2005-03-27 13:21:42.169429+02   t       0       00:05:00        removed
1243 165     81.162.244.178  e57-3sw es3024  2005-03-27 13:17:57.668107+02   f       0       00:05:00        removed
1244 2       81.162.241.12   e1-5sw  es3024  2005-03-27 13:18:06.980239+02   f       0       00:05:00        removed
1245 182     81.162.245.195  e63-2sw es3024  2005-03-27 13:16:31.752876+02   f       0       00:05:00        removed
1246 147     81.162.244.160  e51-3sw es3024  2005-03-27 13:17:58.091146+02   f       0       00:05:00        removed
1247 193     81.162.245.206  e67-1sw es3024  2005-03-27 13:18:35.580223+02   f       0       00:05:00        removed
1248 83      81.162.242.96   e29-5sw es3024  2005-03-27 13:18:36.721338+02   f       0       00:05:00        removed
1249 194     81.162.245.207  e67-2sw es3024  2005-03-27 13:18:38.974352+02   f       0       00:05:00        removed
1250 6       81.162.241.19   e3-6sw  es3024  2005-03-27 13:18:47.075003+02   f       0       00:05:00        removed
1251 49      81.162.242.62   e19-1sw es3024  2005-03-27 13:19:01.806447+02   f       0       00:05:00        removed
1252 211     127.0.0.1       presse  es3024  2005-03-27 13:17:25.438397+02   f       0       00:05:00        removed
1253 90      81.162.243.103  e31-6sw es3024  2005-03-27 13:17:36.889596+02   f       0       00:05:00        removed
1254 52      81.162.242.65   e19-4sw es3024  2005-03-27 13:18:26.931818+02   f       0       00:05:00        removed
1255 136     81.162.244.149  e47-4sw es3024  2005-03-27 13:18:38.226473+02   f       0       00:05:00        removed
1256 5       81.162.241.18   e3-5sw  es3024  2005-03-27 13:18:42.447575+02   f       0       00:05:00        removed
1257 183     81.162.245.196  e63-3sw es3024  2005-03-27 13:18:48.289809+02   f       0       00:05:00        removed
1258 169     81.162.245.182  e59-1sw es3024  2005-03-27 13:18:51.524996+02   f       0       00:05:00        removed
1259 137     81.162.244.150  e47-5sw es3024  2005-03-27 13:18:58.34439+02    f       0       00:05:00        removed
1260 111     81.162.243.124  e39-3sw es3024  2005-03-27 13:19:08.389862+02   f       0       00:05:00        removed
1261 126     81.162.243.139  e43-6sw es3024  2005-03-27 13:19:18.396631+02   f       0       00:05:00        removed
1262 115     81.162.243.128  e41-1sw es3024  2005-03-27 13:20:21.794673+02   f       0       00:05:00        removed
1263 144     81.162.244.157  e49-6sw es3024  2005-03-27 13:20:27.601697+02   f       0       00:05:00        removed
1264 205     81.162.245.218  e71-4sw es3024  2005-03-27 13:20:37.610991+02   f       0       00:05:00        removed
1265 103     81.162.243.116  e37-1sw es3024  2005-03-27 13:17:35.19156+02    f       0       00:05:00        removed
1266 160     81.162.244.173  e55-4sw es3024  2005-03-27 13:17:46.897831+02   f       0       00:05:00        removed
1267 177     81.162.245.190  e61-3sw es3024  2005-03-27 13:18:15.475485+02   f       0       00:05:00        removed
1268 79      81.162.242.92   e29-1sw es3024  2005-03-27 13:18:36.728294+02   f       0       00:05:00        removed
1269 208     81.162.245.221  e73-3sw es3024  2005-03-27 13:19:22.036778+02   f       0       00:05:00        removed
1270 24      81.162.241.37   e9-6sw  es3024  2005-03-27 13:20:32.103714+02   f       0       00:05:00        removed
1271 76      81.162.242.89   e27-4sw es3024  2005-03-27 13:20:42.111557+02   f       0       00:05:00        removed
1272 44      81.162.242.57   e17-2sw es3024  2005-03-27 13:17:41.971894+02   f       0       00:05:00        removed
1273 66      81.162.242.79   e23-6sw es3024  2005-03-27 13:17:56.972013+02   f       0       00:05:00        removed
1274 41      81.162.241.54   e15-5sw es3024  2005-03-27 13:18:21.393627+02   f       0       00:05:00        removed
1275 8       81.162.241.21   e5-2sw  es3024  2005-03-27 13:18:28.967927+02   f       0       00:05:00        removed
1276 15      81.162.241.28   e7-3sw  es3024  2005-03-27 13:18:36.799213+02   f       0       00:05:00        removed
1277 1       81.162.241.11   e1-4sw  es3024  2005-03-27 13:18:42.522553+02   f       0       00:05:00        removed
1278 123     81.162.243.136  e43-3sw es3024  2005-03-27 13:18:51.995005+02   f       0       00:05:00        removed
1279 129     81.162.244.142  e45-3sw es3024  2005-03-27 13:18:54.851215+02   f       0       00:05:00        removed
1280 56      81.162.242.69   e21-2sw es3024  2005-03-27 13:19:02.014465+02   f       0       00:05:00        removed
1281 181     81.162.245.194  e63-1sw es3024  2005-03-27 13:19:12.059112+02   f       0       00:05:00        removed
1282 33      81.162.241.46   e13-3sw es3024  2005-03-27 13:19:12.08011+02    f       0       00:05:00        removed
1283 68      81.162.242.81   e25-2sw es3024  2005-03-27 13:20:22.092638+02   f       0       00:05:00        removed
1284 139     81.162.244.152  e49-1sw es3024  2005-03-27 13:21:32.131187+02   f       0       00:05:00        removed
1285 166     81.162.244.179  e57-4sw es3024  2005-03-27 13:21:42.167871+02   f       0       00:05:00        removed
1286 55      81.162.242.68   e21-1sw es3024  2005-03-27 13:18:27.760928+02   f       0       00:05:00        removed
1287 187     81.162.245.200  e65-1sw es3024  2005-03-27 13:18:37.783633+02   f       0       00:05:00        removed
1288 135     81.162.244.148  e47-3sw es3024  2005-03-27 13:18:47.790825+02   f       0       00:05:00        removed
1289 69      81.162.242.82   e25-3sw es3024  2005-03-27 13:19:01.960433+02   f       0       00:05:00        removed
1290 114     81.162.243.127  e39-6sw es3024  2005-03-27 13:19:07.807795+02   f       0       00:05:00        removed
1291 185     81.162.245.198  e63-5sw es3024  2005-03-27 13:19:21.979734+02   f       0       00:05:00        removed
1292 163     81.162.244.176  e57-1sw es3024  2005-03-27 13:20:37.80015+02    f       0       00:05:00        removed
1293 222     81.162.242.2    d02     summit400       2005-03-27 13:21:26.058745+02   f       5       00:00:20        removed
1294 120     81.162.243.133  e41-6sw es3024  2005-03-27 13:21:30.769149+02   f       0       00:05:00        removed
1295 128     81.162.244.141  e45-2sw es3024  2005-03-27 13:17:36.931503+02   f       0       00:05:00        removed
1296 174     81.162.245.187  e59-6sw es3024  2005-03-27 13:18:16.963474+02   f       0       00:05:00        removed
1297 148     81.162.244.161  e51-4sw es3024  2005-03-27 13:18:26.970802+02   f       0       00:05:00        removed
1298 110     81.162.243.123  e39-2sw es3024  2005-03-27 13:18:47.000886+02   f       0       00:05:00        removed
1299 77      81.162.242.90   e27-5sw es3024  2005-03-27 13:19:11.815032+02   f       0       00:05:00        removed
1300 145     81.162.244.158  e51-1sw es3024  2005-03-27 13:21:33.428323+02   f       0       00:05:00        removed
1301 218     81.162.239.11   telematics-gw   summit7i        2005-03-27 13:21:40.916277+02   t       5       00:00:20        removed
1302 153     81.162.244.166  e53-3sw es3024  2005-03-27 13:17:44.926073+02   f       0       00:05:00        removed
1303 3       81.162.241.13   e1-6sw  es3024  2005-03-27 13:19:01.621559+02   f       0       00:05:00        removed
1304 175     81.162.245.188  e61-1sw es3024  2005-03-27 13:19:21.726775+02   f       0       00:05:00        removed
1305 159     81.162.244.172  e55-3sw es3024  2005-03-27 13:20:47.807065+02   f       0       00:05:00        removed
1306 13      81.162.241.26   e7-1sw  es3024  2005-03-27 13:20:48.110995+02   f       0       00:05:00        removed
1307 210     81.162.239.10   noc     cisco6509       2005-03-27 13:21:26.109659+02   f       5       00:00:20        removed
1308 34      81.162.241.47   e13-4sw es3024  2005-03-27 13:17:34.658518+02   f       0       00:05:00        removed
1309 151     81.162.244.164  e53-1sw es3024  2005-03-27 13:21:41.93941+02    t       0       00:05:00        removed
1310 93      81.162.243.106  e33-3sw es3024  2005-03-27 13:21:42.589349+02   t       0       00:05:00        removed
1311 51      81.162.242.64   e19-3sw es3024  2005-03-27 13:16:25.080516+02   f       0       00:05:00        removed
1312 58      81.162.242.71   e21-4sw es3024  2005-03-27 13:17:35.16855+02    f       0       00:05:00        removed
1313 130     81.162.244.143  e45-4sw es3024  2005-03-27 13:17:55.221024+02   f       0       00:05:00        removed
1314 172     81.162.245.185  e59-4sw es3024  2005-03-27 13:18:05.249512+02   f       0       00:05:00        removed
1315 91      81.162.243.104  e33-1sw es3024  2005-03-27 13:18:51.619208+02   f       0       00:05:00        removed
1316 74      81.162.242.87   e27-2sw es3024  2005-03-27 13:19:01.627392+02   f       0       00:05:00        removed
1317 12      81.162.241.25   e5-6sw  es3024  2005-03-27 13:19:11.65907+02    f       0       00:05:00        removed
1318 89      81.162.243.102  e31-5sw es3024  2005-03-27 13:20:31.837713+02   f       0       00:05:00        removed
1319 225     81.162.240.98   bd      blackdiamond    2005-03-27 13:21:35.038465+02   f       10      00:00:20        removed
1320 154     81.162.244.167  e53-4sw es3024  2005-03-27 13:16:25.504565+02   f       0       00:05:00        removed
1321 36      81.162.241.49   e13-6sw es3024  2005-03-27 13:17:35.531534+02   f       0       00:05:00        removed
1322 50      81.162.242.63   e19-2sw es3024  2005-03-27 13:17:55.547006+02   f       0       00:05:00        removed
1323 106     81.162.243.119  e37-4sw es3024  2005-03-27 13:18:15.562463+02   f       0       00:05:00        removed
1324 138     81.162.244.151  e47-6sw es3024  2005-03-27 13:19:21.822733+02   f       0       00:05:00        removed
1325 59      81.162.242.72   e21-5sw es3024  2005-03-27 13:17:47.590918+02   f       0       00:05:00        removed
1326 102     81.162.243.115  e35-6sw es3024  2005-03-27 13:18:06.775277+02   f       0       00:05:00        removed
1327 134     81.162.244.147  e47-2sw es3024  2005-03-27 13:18:16.783539+02   f       0       00:05:00        removed
1328 26      81.162.241.39   e11-2sw es3024  2005-03-27 13:18:26.79084+02    f       0       00:05:00        removed
1329 216     127.0.0.1       vision-sponsor  es3024  2005-03-27 13:20:53.695607+02   f       0       00:05:00        removed
1330 184     81.162.245.197  e63-4sw es3024  2005-03-27 13:18:06.9152+02     f       0       00:05:00        removed
1331 196     81.162.245.209  e67-4sw es3024  2005-03-27 13:18:16.922538+02   f       0       00:05:00        removed
1332 95      81.162.243.108  e33-5sw es3024  2005-03-27 13:18:16.988269+02   f       0       00:05:00        removed
1333 38      81.162.241.51   e15-2sw es3024  2005-03-27 13:18:26.99682+02    f       0       00:05:00        removed
1334 60      81.162.242.73   e21-6sw es3024  2005-03-27 13:18:57.086812+02   f       0       00:05:00        removed
1335 73      81.162.242.86   e27-1sw es3024  2005-03-27 13:19:07.114926+02   f       0       00:05:00        removed
1336 118     81.162.243.131  e41-4sw es3024  2005-03-27 13:18:52.456053+02   f       0       00:05:00        removed
1337 100     81.162.243.113  e35-4sw es3024  2005-03-27 13:20:22.485517+02   f       0       00:05:00        removed
1338 132     81.162.244.145  e45-6sw es3024  2005-03-27 13:20:32.492844+02   f       0       00:05:00        removed
1339 131     81.162.244.144  e45-5sw es3024  2005-03-27 13:21:42.507294+02   t       0       00:05:00        removed
1340 125     81.162.243.138  e43-5sw es3024  2005-03-27 13:18:52.532065+02   f       0       00:05:00        removed
1341 173     81.162.245.186  e59-5sw es3024  2005-03-27 13:19:12.547121+02   f       0       00:05:00        removed
1342 212     127.0.0.1       info-desk       es3024  2005-03-27 13:20:12.561191+02   f       0       00:05:00        removed
1343 188     81.162.245.201  e65-2sw es3024  2005-03-27 13:20:22.567537+02   f       0       00:05:00        removed
1344 40      81.162.241.53   e15-4sw es3024  2005-03-27 13:20:32.574729+02   f       0       00:05:00        removed
1345 199     81.162.245.212  e69-2sw es3024  2005-03-27 13:20:42.582037+02   f       0       00:05:00        removed
1346 156     81.162.244.169  e53-6sw es3024  2005-03-27 13:20:33.372782+02   f       0       00:05:00        removed
1347 202     81.162.245.215  e69-5sw es3024  2005-03-27 13:20:47.618076+02   f       0       00:05:00        removed
1348 20      81.162.241.33   e9-2sw  es3024  2005-03-27 13:18:57.800335+02   f       0       00:05:00        removed
1349 117     81.162.243.130  e41-3sw es3024  2005-03-27 13:19:02.463533+02   f       0       00:05:00        removed
1350 164     81.162.244.177  e57-2sw es3024  2005-03-27 13:20:42.500004+02   f       0       00:05:00        removed
1351 197     81.162.245.210  e67-5sw es3024  2005-03-27 13:19:13.321114+02   f       0       00:05:00        removed
1352 \.
1353
1354
1355 --
1356 -- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: postgres
1357 --
1358
1359 COPY switchtypes (switchtype, ports) FROM stdin;
1360 blackdiamond    1001-1007,4001-4016,5001-5024,6001-6048
1361 es3024  1-25
1362 cisco6509       1-123
1363 summit400       1-50
1364 cisco3550       1-50
1365 summit7i        1-32
1366 summit48        1-50
1367 \.
1368
1369