From 028bd0b6247ce214305eb0cc447e004c7ff592ea Mon Sep 17 00:00:00 2001 From: root Date: Tue, 3 Apr 2007 16:32:28 +0200 Subject: [PATCH] Clean the NMS data a bit. --- sql/nms.sql | 853 ---------------------------------------------------- 1 file changed, 853 deletions(-) diff --git a/sql/nms.sql b/sql/nms.sql index c1ae9eb..852f7ba 100644 --- a/sql/nms.sql +++ b/sql/nms.sql @@ -235,7 +235,6 @@ ALTER TABLE public.cpuloadpoll OWNER TO sesse; -- Name: cpuloadpoll_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sesse -- -SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('cpuloadpoll', 'id'), 12, true); -- @@ -359,7 +358,6 @@ ALTER TABLE public.squeue_group_sequence OWNER TO nms; -- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms -- -SELECT pg_catalog.setval('squeue_group_sequence', 21, true); -- @@ -472,844 +470,6 @@ CREATE TABLE temppoll ( ALTER TABLE public.temppoll OWNER TO postgres; --- --- Data for Name: cpuloadpoll; Type: TABLE DATA; Schema: public; Owner: sesse --- - -COPY cpuloadpoll (id, "time", switch, entity, value) FROM stdin; -5 2006-03-28 23:16:18.950263 1 5017 1 -6 2006-03-28 23:16:18.970211 1 5001 3 -7 2006-03-28 23:16:18.999445 1 2007 76 -8 2006-03-28 23:16:19.018999 1 1056 3 -9 2006-03-29 14:21:07.052914 1 5017 0 -10 2006-03-29 14:21:07.07474 1 5001 4 -11 2006-03-29 14:21:07.104667 1 2007 69 -12 2006-03-29 14:21:07.125 1 1056 3 -\. - - --- --- Data for Name: dhcp; Type: TABLE DATA; Schema: public; Owner: sesse --- - -COPY dhcp (switch, network, last_ack) FROM stdin; -151 81.162.53.0/26 2005-03-27 11:53:29 -41 81.162.16.64/26 2005-03-27 11:53:35 -164 81.162.57.64/26 2005-03-27 11:53:39 -20 81.162.9.64/26 2005-03-27 11:54:27 -4 81.162.4.0/26 2005-03-27 11:55:33 -44 81.162.17.64/26 2005-03-27 11:56:37 -194 81.162.67.64/26 2005-03-27 11:56:38 -139 81.162.49.0/26 2005-03-27 11:57:08 -46 81.162.18.0/26 2005-03-27 11:57:27 -193 81.162.67.0/26 2005-03-27 11:57:36 -27 81.162.11.128/26 2005-03-27 11:58:07 -107 81.162.38.64/26 2005-03-27 11:58:31 -133 81.162.47.0/26 2005-03-27 11:58:52 -99 81.162.35.128/26 2005-03-27 11:59:09 -79 81.162.29.0/26 2005-03-27 11:59:18 -34 81.162.14.0/26 2005-03-27 11:59:28 -51 81.162.19.128/26 2005-03-27 11:59:34 -160 81.162.56.0/26 2005-03-27 12:00:01 -196 81.162.68.0/26 2005-03-27 12:00:11 -184 81.162.64.0/26 2005-03-27 12:01:48 -9 81.162.5.128/26 2005-03-27 12:01:54 -195 81.162.67.128/26 2005-03-27 12:02:18 -123 81.162.43.128/26 2005-03-27 12:02:46 -192 81.162.66.128/26 2005-03-27 12:03:09 -212 81.162.203.0/24 2005-03-27 12:04:12 -5 81.162.4.64/26 2005-03-27 12:04:14 -113 81.162.40.64/26 2005-03-27 12:05:01 -191 81.162.66.64/26 2005-03-27 12:05:01 -119 81.162.42.64/26 2005-03-27 12:06:01 -3 81.162.2.128/26 2005-03-27 12:06:03 -74 81.162.27.64/26 2005-03-27 12:06:12 -201 81.162.70.0/26 2005-03-27 12:06:25 -86 81.162.31.64/26 2005-03-27 12:07:56 -50 81.162.19.64/26 2005-03-27 12:08:36 -59 81.162.22.64/26 2005-03-27 12:08:59 -43 81.162.17.0/26 2005-03-27 12:09:02 -80 81.162.29.64/26 2005-03-27 12:09:14 -106 81.162.38.0/26 2005-03-27 12:09:15 -52 81.162.20.0/26 2005-03-27 12:09:22 -205 81.162.72.0/26 2005-03-27 12:10:08 -82 81.162.30.0/26 2005-03-27 12:10:10 -128 81.162.45.64/26 2005-03-27 12:10:38 -112 81.162.40.0/26 2005-03-27 12:11:16 -202 81.162.70.64/26 2005-03-27 12:12:30 -6 81.162.4.128/26 2005-03-27 12:12:49 -95 81.162.34.64/26 2005-03-27 12:13:02 -178 81.162.62.0/26 2005-03-27 12:13:10 -145 81.162.51.0/26 2005-03-27 12:13:15 -84 81.162.30.128/26 2005-03-27 12:13:34 -28 81.162.12.0/26 2005-03-27 12:13:58 -22 81.162.10.0/26 2005-03-27 12:14:40 -122 81.162.43.64/26 2005-03-27 12:14:57 -85 81.162.31.0/26 2005-03-27 12:15:21 -18 81.162.8.128/26 2005-03-27 12:15:24 -105 81.162.37.128/26 2005-03-27 12:15:24 -81 81.162.29.128/26 2005-03-27 12:15:36 -77 81.162.28.64/26 2005-03-27 12:15:47 -146 81.162.51.64/26 2005-03-27 12:17:09 -24 81.162.10.128/26 2005-03-27 12:17:10 -190 81.162.66.0/26 2005-03-27 12:17:10 -33 81.162.13.128/26 2005-03-27 12:17:17 -150 81.162.52.128/26 2005-03-27 12:17:27 -57 81.162.21.128/26 2005-03-27 12:17:37 -17 81.162.8.64/26 2005-03-27 12:17:39 -54 81.162.20.128/26 2005-03-27 12:18:24 -94 81.162.34.0/26 2005-03-27 12:18:24 -69 81.162.25.128/26 2005-03-27 12:18:26 -141 81.162.49.128/26 2005-03-27 12:18:43 -154 81.162.54.0/26 2005-03-27 12:19:25 -177 81.162.61.128/26 2005-03-27 12:20:17 -29 81.162.12.64/26 2005-03-27 12:20:37 -91 81.162.33.0/26 2005-03-27 12:20:53 -83 81.162.30.64/26 2005-03-27 12:20:57 -47 81.162.18.64/26 2005-03-27 12:21:10 -170 81.162.59.64/26 2005-03-27 12:22:01 -78 81.162.28.128/26 2005-03-27 12:22:26 -155 81.162.54.64/26 2005-03-27 12:23:11 -35 81.162.14.64/26 2005-03-27 12:23:12 -32 81.162.13.64/26 2005-03-27 12:23:55 -199 81.162.69.64/26 2005-03-27 12:24:13 -63 81.162.23.128/26 2005-03-27 12:24:33 -90 81.162.32.128/26 2005-03-27 12:25:31 -114 81.162.40.128/26 2005-03-27 12:26:04 -75 81.162.27.128/26 2005-03-27 12:26:06 -42 81.162.16.128/26 2005-03-27 12:26:26 -87 81.162.31.128/26 2005-03-27 12:26:42 -67 81.162.25.0/26 2005-03-27 12:27:31 -204 81.162.71.128/26 2005-03-27 12:34:04 -200 81.162.69.128/26 2005-03-27 12:37:19 -207 81.162.73.64/26 2005-03-27 12:41:57 -203 81.162.71.64/26 2005-03-27 12:58:48 -214 81.162.213.0/24 2005-03-27 13:02:26 -213 81.162.213.0/24 2005-03-27 13:02:26 -209 81.162.212.0/24 2005-03-27 13:16:02 -215 81.162.200.0/24 2005-03-27 13:16:14 -210 81.162.250.0/24 2005-03-27 13:18:02 -211 81.162.252.0/24 2005-03-27 12:39:02 -129 81.162.45.128/26 2005-03-27 10:44:11 -110 81.162.39.64/26 2005-03-27 08:19:17 -10 81.162.6.0/26 2005-03-27 08:35:15 -171 81.162.59.128/26 2005-03-27 08:42:52 -167 81.162.58.64/26 2005-03-27 09:07:47 -180 81.162.62.128/26 2005-03-27 09:22:15 -140 81.162.49.64/26 2005-03-27 09:41:51 -103 81.162.37.0/26 2005-03-27 09:42:30 -55 81.162.21.0/26 2005-03-27 09:42:54 -137 81.162.48.64/26 2005-03-27 09:47:06 -62 81.162.23.64/26 2005-03-27 09:51:30 -158 81.162.55.64/26 2005-03-27 09:51:55 -70 81.162.26.0/26 2005-03-27 09:52:09 -159 81.162.55.128/26 2005-03-27 10:05:56 -165 81.162.57.128/26 2005-03-27 10:09:30 -125 81.162.44.64/26 2005-03-27 10:10:14 -169 81.162.59.0/26 2005-03-27 10:10:29 -89 81.162.32.64/26 2005-03-27 10:11:14 -168 81.162.58.128/26 2005-03-27 10:11:42 -39 81.162.15.128/26 2005-03-27 10:11:49 -134 81.162.47.64/26 2005-03-27 10:12:00 -144 81.162.50.128/26 2005-03-27 10:15:46 -61 81.162.23.0/26 2005-03-27 10:19:36 -186 81.162.64.128/26 2005-03-27 10:24:08 -97 81.162.35.0/26 2005-03-27 10:26:13 -124 81.162.44.0/26 2005-03-27 10:28:37 -162 81.162.56.128/26 2005-03-27 10:36:33 -76 81.162.28.0/26 2005-03-27 10:38:20 -156 81.162.54.128/26 2005-03-27 10:41:07 -93 81.162.33.128/26 2005-03-27 10:42:16 -58 81.162.22.0/26 2005-03-27 10:42:50 -23 81.162.10.64/26 2005-03-27 10:43:27 -132 81.162.46.128/26 2005-03-27 10:46:35 -118 81.162.42.0/26 2005-03-27 10:47:16 -16 81.162.8.0/26 2005-03-27 10:47:53 -182 81.162.63.64/26 2005-03-27 10:47:58 -88 81.162.32.0/26 2005-03-27 10:49:28 -126 81.162.44.128/26 2005-03-27 10:50:02 -130 81.162.46.0/26 2005-03-27 10:50:46 -15 81.162.7.128/26 2005-03-27 10:54:20 -12 81.162.6.128/26 2005-03-27 10:54:40 -98 81.162.35.64/26 2005-03-27 10:55:15 -104 81.162.37.64/26 2005-03-27 10:57:11 -100 81.162.36.0/26 2005-03-27 10:58:55 -45 81.162.17.128/26 2005-03-27 11:02:32 -131 81.162.46.64/26 2005-03-27 11:04:23 -175 81.162.61.0/26 2005-03-27 11:04:47 -72 81.162.26.128/26 2005-03-27 11:04:50 -148 81.162.52.0/26 2005-03-27 11:05:19 -198 81.162.68.128/26 2005-03-27 11:06:42 -68 81.162.25.64/26 2005-03-27 11:06:55 -115 81.162.41.0/26 2005-03-27 11:08:58 -157 81.162.55.0/26 2005-03-27 11:10:30 -111 81.162.39.128/26 2005-03-27 11:11:10 -120 81.162.42.128/26 2005-03-27 10:14:01 -21 81.162.9.128/26 2005-03-27 10:39:11 -64 81.162.24.0/26 2005-03-27 11:14:54 -7 81.162.5.0/26 2005-03-27 11:15:07 -163 81.162.57.0/26 2005-03-27 11:18:50 -208 81.162.73.128/26 2005-03-27 11:18:53 -189 81.162.65.128/26 2005-03-27 11:20:12 -197 81.162.68.64/26 2005-03-27 11:20:46 -31 81.162.13.0/26 2005-03-27 11:22:31 -19 81.162.9.0/26 2005-03-27 11:22:48 -13 81.162.7.0/26 2005-03-27 11:24:35 -147 81.162.51.128/26 2005-03-27 11:27:37 -135 81.162.47.128/26 2005-03-27 11:28:43 -121 81.162.43.0/26 2005-03-27 11:28:58 -136 81.162.48.0/26 2005-03-27 11:31:04 -66 81.162.24.128/26 2005-03-27 11:32:10 -166 81.162.58.0/26 2005-03-27 09:25:55 -138 81.162.48.128/26 2005-03-27 10:08:33 -56 81.162.21.64/26 2005-03-27 11:32:34 -143 81.162.50.64/26 2005-03-27 11:33:03 -176 81.162.61.64/26 2005-03-27 11:33:36 -65 81.162.24.64/26 2005-03-27 11:33:40 -102 81.162.36.128/26 2005-03-27 11:34:00 -116 81.162.41.64/26 2005-03-27 11:34:56 -183 81.162.63.128/26 2005-03-27 11:36:02 -109 81.162.39.0/26 2005-03-27 11:36:45 -25 81.162.11.0/26 2005-03-27 11:37:44 -174 81.162.60.128/26 2005-03-27 11:38:11 -216 81.162.202.0/24 2005-03-27 11:39:03 -40 81.162.16.0/26 2005-03-27 11:39:31 -152 81.162.53.64/26 2005-03-27 11:39:47 -14 81.162.7.64/26 2005-03-27 11:39:59 -92 81.162.33.64/26 2005-03-27 11:40:05 -173 81.162.60.64/26 2005-03-27 11:40:28 -48 81.162.18.128/26 2005-03-27 11:40:28 -8 81.162.5.64/26 2005-03-27 11:40:45 -108 81.162.38.128/26 2005-03-27 11:42:43 -11 81.162.6.64/26 2005-03-27 08:50:50 -188 81.162.65.64/26 2005-03-27 08:55:21 -117 81.162.41.128/26 2005-03-27 09:23:35 -26 81.162.11.64/26 2005-03-27 11:43:18 -172 81.162.60.0/26 2005-03-27 11:43:21 -71 81.162.26.64/26 2005-03-27 11:43:51 -38 81.162.15.64/26 2005-03-27 11:44:11 -153 81.162.53.128/26 2005-03-27 11:45:51 -53 81.162.20.64/26 2005-03-27 11:46:24 -1 81.162.2.0/26 2005-03-27 11:47:03 -2 81.162.2.64/26 2005-03-27 11:47:10 -149 81.162.52.64/26 2005-03-27 11:48:35 -37 81.162.15.0/26 2005-03-27 11:49:04 -127 81.162.45.0/26 2005-03-27 11:49:22 -179 81.162.62.64/26 2005-03-27 11:49:48 -185 81.162.64.64/26 2005-03-27 11:50:36 -142 81.162.50.0/26 2005-03-27 11:51:18 -36 81.162.14.128/26 2005-03-27 11:51:19 -30 81.162.12.128/26 2005-03-27 11:51:20 -60 81.162.22.128/26 2005-03-27 11:52:08 -49 81.162.19.0/26 2005-03-27 10:22:15 -73 81.162.27.0/26 2005-03-27 11:27:55 -96 81.162.34.128/26 2005-03-27 11:32:26 -101 81.162.36.64/26 2005-03-27 11:40:47 -181 81.162.63.0/26 2005-03-27 11:52:55 -187 81.162.65.0/26 2005-03-27 11:53:23 -161 81.162.56.64/26 2005-03-27 08:54:44 -\. - - --- --- Data for Name: placements; Type: TABLE DATA; Schema: public; Owner: postgres --- - -COPY placements (switch, placement) FROM stdin; -221 (375,325),(350,300) -222 (550,325),(525,300) -224 (775,325),(750,300) -223 (875,325),(850,300) -225 (675,325),(650,300) -218 (980,550),(930,520) -1 (306,306),(294,256) -2 (306,256),(294,206) -3 (306,206),(294,156) -4 (325,306),(313,256) -5 (325,256),(313,206) -6 (325,206),(313,156) -7 (344,470),(332,422) -8 (344,422),(332,374) -9 (344,374),(332,326) -10 (344,306),(332,256) -11 (344,256),(332,206) -12 (344,206),(332,156) -13 (363,470),(351,422) -14 (363,422),(351,374) -15 (363,374),(351,326) -16 (363,306),(351,256) -17 (363,256),(351,206) -18 (363,206),(351,156) -19 (382,470),(370,422) -20 (382,422),(370,374) -21 (382,374),(370,326) -22 (382,306),(370,256) -23 (382,256),(370,206) -24 (382,206),(370,156) -25 (400,470),(388,422) -26 (400,422),(388,374) -27 (400,374),(388,326) -28 (400,306),(388,256) -29 (400,256),(388,206) -30 (400,206),(388,156) -31 (419,470),(407,422) -32 (419,422),(407,374) -33 (419,374),(407,326) -34 (419,306),(407,256) -35 (419,256),(407,206) -36 (419,206),(407,156) -37 (438,470),(426,422) -38 (438,422),(426,374) -39 (438,374),(426,326) -40 (438,306),(426,256) -41 (438,256),(426,206) -42 (438,206),(426,156) -43 (457,470),(445,422) -44 (457,422),(445,374) -45 (457,374),(445,326) -46 (457,306),(445,256) -47 (457,256),(445,206) -48 (457,206),(445,156) -49 (483,470),(471,422) -50 (483,422),(471,374) -51 (483,374),(471,326) -52 (483,306),(471,256) -53 (483,256),(471,206) -54 (483,206),(471,156) -55 (502,470),(490,422) -56 (502,422),(490,374) -57 (502,374),(490,326) -58 (502,306),(490,256) -59 (502,256),(490,206) -60 (502,206),(490,156) -61 (521,470),(509,422) -62 (521,422),(509,374) -63 (521,374),(509,326) -64 (521,306),(509,256) -65 (521,256),(509,206) -66 (521,206),(509,156) -67 (540,470),(528,422) -68 (540,422),(528,374) -69 (540,374),(528,326) -70 (540,306),(528,256) -71 (540,256),(528,206) -72 (540,206),(528,156) -73 (559,470),(547,422) -74 (559,422),(547,374) -75 (559,374),(547,326) -76 (559,306),(547,256) -77 (559,256),(547,206) -78 (559,206),(547,156) -79 (578,470),(566,422) -80 (578,422),(566,374) -81 (578,374),(566,326) -82 (578,306),(566,256) -83 (578,256),(566,206) -84 (578,206),(566,156) -85 (596,470),(584,422) -86 (596,422),(584,374) -87 (596,374),(584,326) -88 (596,306),(584,256) -89 (596,256),(584,206) -90 (596,206),(584,156) -91 (615,470),(603,422) -92 (615,422),(603,374) -93 (615,374),(603,326) -94 (615,306),(603,256) -95 (615,256),(603,206) -96 (615,206),(603,156) -97 (648,470),(636,422) -98 (648,422),(636,374) -99 (648,374),(636,326) -100 (648,306),(636,256) -101 (648,256),(636,206) -102 (648,206),(636,156) -103 (667,470),(655,422) -104 (667,422),(655,374) -105 (667,374),(655,326) -106 (667,306),(655,256) -107 (667,256),(655,206) -108 (667,206),(655,156) -109 (686,470),(674,422) -110 (686,422),(674,374) -111 (686,374),(674,326) -112 (686,306),(674,256) -113 (686,256),(674,206) -114 (686,206),(674,156) -115 (705,470),(693,422) -116 (705,422),(693,374) -117 (705,374),(693,326) -118 (705,306),(693,256) -119 (705,256),(693,206) -120 (705,206),(693,156) -121 (724,470),(712,422) -122 (724,422),(712,374) -123 (724,374),(712,326) -124 (724,306),(712,256) -125 (724,256),(712,206) -126 (724,206),(712,156) -127 (743,470),(731,422) -128 (743,422),(731,374) -129 (743,374),(731,326) -130 (743,306),(731,256) -131 (743,256),(731,206) -132 (743,206),(731,156) -133 (762,470),(750,422) -134 (762,422),(750,374) -135 (762,374),(750,326) -136 (762,306),(750,256) -137 (762,256),(750,206) -138 (762,206),(750,156) -139 (781,470),(769,422) -140 (781,422),(769,374) -141 (781,374),(769,326) -142 (781,306),(769,256) -143 (781,256),(769,206) -144 (781,206),(769,156) -145 (808,470),(796,422) -146 (808,422),(796,374) -147 (808,374),(796,326) -148 (808,306),(796,256) -149 (808,256),(796,206) -150 (808,206),(796,156) -151 (827,470),(815,422) -152 (827,422),(815,374) -153 (827,374),(815,326) -154 (827,306),(815,256) -155 (827,256),(815,206) -156 (827,206),(815,156) -157 (846,470),(834,422) -158 (846,422),(834,374) -159 (846,374),(834,326) -160 (846,306),(834,256) -161 (846,256),(834,206) -162 (846,206),(834,156) -163 (865,470),(853,422) -164 (865,422),(853,374) -165 (865,374),(853,326) -166 (865,306),(853,256) -167 (865,256),(853,206) -168 (865,206),(853,156) -169 (884,470),(872,422) -170 (884,422),(872,374) -171 (884,374),(872,326) -172 (884,306),(872,256) -173 (884,256),(872,206) -174 (884,206),(872,156) -175 (903,470),(891,422) -176 (903,422),(891,374) -177 (903,374),(891,326) -178 (903,306),(891,256) -179 (903,256),(891,206) -180 (903,206),(891,156) -181 (922,470),(910,422) -182 (922,422),(910,374) -183 (922,374),(910,326) -184 (922,306),(910,256) -185 (922,256),(910,206) -186 (922,206),(910,156) -187 (941,470),(929,422) -188 (941,422),(929,374) -189 (941,374),(929,326) -190 (941,306),(929,256) -191 (941,256),(929,206) -192 (941,206),(929,156) -193 (960,470),(948,422) -194 (960,422),(948,374) -195 (960,374),(948,326) -196 (960,306),(948,256) -197 (960,256),(948,206) -198 (960,206),(948,156) -199 (988,422),(976,374) -200 (988,374),(976,326) -201 (979,306),(967,256) -202 (979,256),(967,206) -203 (1006,422),(994,374) -204 (1006,374),(994,326) -205 (997,306),(985,256) -207 (1025,422),(1013,374) -208 (1025,374),(1013,326) -209 (1125,225),(1100,200) -210 (680,550),(630,520) -211 (610,550),(560,520) -212 (305,385),(270,350) -213 (900,100),(800,75) -214 (900,100),(800,75) -215 (200,270),(170,240) -216 (250,180),(220,150) -\. - - --- --- Data for Name: polls; Type: TABLE DATA; Schema: public; Owner: postgres --- - -COPY polls ("time", switch, port, bytes_in, bytes_out) FROM stdin; -2006-03-28 22:39:09.893643+02 1 1 0 0 -2006-03-28 22:39:09.913546+02 1 2 0 0 -2006-03-28 22:39:09.933906+02 1 3 0 0 -2006-03-28 22:39:09.953638+02 1 4 0 0 -2006-03-28 22:39:09.973536+02 1 5 0 0 -2006-03-28 22:39:09.993418+02 1 6 0 0 -2006-03-28 22:39:10.013146+02 1 7 0 0 -2006-03-28 22:39:10.032774+02 1 8 0 0 -2006-03-28 22:39:10.052348+02 1 9 0 0 -2006-03-28 22:39:10.072177+02 1 10 0 0 -2006-03-28 22:39:10.092731+02 1 11 0 0 -2006-03-28 22:39:10.11247+02 1 12 0 0 -2006-03-28 22:39:10.132382+02 1 13 7747123 14112208 -2006-03-28 22:39:10.152582+02 1 14 7713082 14042766 -2006-03-28 22:39:10.172369+02 1 15 8056118 17207110 -2006-03-28 22:39:10.192118+02 1 16 0 0 -2006-03-28 22:39:10.212055+02 1 17 0 0 -2006-03-28 22:39:10.231483+02 1 18 0 0 -2006-03-28 22:39:10.251181+02 1 19 138414013 203348896 -2006-03-28 22:39:10.271767+02 1 20 199834250 208491729 -2006-03-28 22:39:10.29177+02 1 21 6357743 13961928 -2006-03-28 22:39:10.311587+02 1 22 0 0 -2006-03-28 22:39:10.331091+02 1 23 0 0 -2006-03-28 22:39:10.350932+02 1 24 0 0 -2006-03-28 22:39:10.370631+02 1 25 0 0 -2006-03-28 22:39:10.390715+02 1 26 0 0 -2006-03-28 22:39:10.410346+02 1 27 0 0 -2006-03-28 22:39:10.430225+02 1 28 0 0 -2006-03-28 22:39:10.450417+02 1 29 0 0 -2006-03-28 22:39:10.471318+02 1 30 0 0 -2006-03-28 22:39:10.490967+02 1 31 0 0 -2006-03-28 22:39:10.511826+02 1 32 0 0 -2006-03-28 22:39:10.53276+02 1 33 0 0 -2006-03-28 22:39:10.553075+02 1 34 0 0 -2006-03-28 22:39:10.573845+02 1 35 0 0 -2006-03-28 22:39:10.595012+02 1 36 0 0 -2006-03-28 22:39:10.615023+02 1 37 0 0 -2006-03-28 22:39:10.634971+02 1 38 0 0 -2006-03-28 22:39:10.654731+02 1 39 0 0 -2006-03-28 22:39:10.686279+02 1 40 0 0 -2006-03-28 22:39:10.705889+02 1 41 0 0 -2006-03-28 22:39:10.72543+02 1 42 0 0 -2006-03-28 22:39:10.745098+02 1 43 0 0 -2006-03-28 22:39:10.764735+02 1 44 0 0 -2006-03-28 22:39:10.784882+02 1 45 0 0 -2006-03-28 22:39:10.804477+02 1 46 816 976127 -2006-03-28 22:39:10.82424+02 1 47 748 503124 -2006-03-28 22:39:10.843866+02 1 48 816 276935 -2006-03-28 22:39:10.863439+02 1 49 2890 2890 -2006-03-28 22:39:10.883028+02 1 50 210 210 -2006-03-28 22:39:10.90281+02 1 51 210 210 -2006-03-28 22:39:10.922442+02 1 52 210 210 -2006-03-28 22:39:10.942226+02 1 53 210 210 -2006-03-28 22:39:10.96199+02 1 54 210 210 -2006-03-28 22:39:10.983951+02 1 55 210 210 -2006-03-28 22:39:11.003594+02 1 56 210 210 -2006-03-28 22:39:11.023272+02 1 57 1058 1058 -2006-03-28 22:39:11.043103+02 1 58 210 210 -2006-03-28 22:39:11.062924+02 1 59 210 210 -2006-03-28 22:39:11.083132+02 1 60 210 210 -2006-03-28 22:39:11.103073+02 1 61 210 210 -2006-03-28 22:39:11.123076+02 1 62 370389 1367489 -2006-03-28 22:39:11.142765+02 1 63 210 535911 -2006-03-28 22:39:11.162409+02 1 64 210 243777 -2006-03-28 22:39:11.18224+02 1 65 228 5275950 -2006-03-28 22:39:11.202296+02 1 66 7020 164802316 -2006-03-28 22:39:11.221934+02 1 67 0 0 -2006-03-28 22:39:11.24138+02 1 68 0 0 -2006-03-28 22:39:11.260987+02 1 69 0 0 -2006-03-28 22:39:11.280526+02 1 70 0 0 -2006-03-28 22:39:11.300239+02 1 71 228 228 -2006-03-28 22:39:11.319742+02 1 72 146 5274588 -2006-03-28 22:39:11.339383+02 1 73 240 240 -2006-03-28 22:39:11.35914+02 1 74 240 240 -2006-03-28 22:39:11.378792+02 1 75 240 240 -2006-03-28 22:39:11.398351+02 1 76 240 240 -2006-03-28 22:39:11.41811+02 1 77 240 240 -2006-03-28 22:39:11.437892+02 1 78 240 240 -2006-03-28 22:39:11.457433+02 1 79 0 0 -2006-03-28 22:39:11.477388+02 1 80 4286507245 3471154200 -2006-03-28 22:39:11.497485+02 1 81 146 146 -2006-03-28 22:39:11.517205+02 1 82 0 0 -2006-03-28 22:39:11.536948+02 1 83 146 146 -2006-03-28 22:39:11.556906+02 1 84 0 0 -2006-03-28 22:39:11.576549+02 1 85 0 0 -2006-03-28 22:39:11.597038+02 1 86 0 0 -2006-03-28 22:39:11.616963+02 1 87 0 0 -2006-03-28 22:39:11.636499+02 1 88 0 0 -2006-03-28 22:39:11.656367+02 1 89 0 0 -2006-03-28 22:39:11.67601+02 1 90 0 0 -2006-03-28 22:39:11.696501+02 1 91 0 0 -2006-03-28 22:39:11.715967+02 1 92 0 0 -2006-03-28 22:39:11.735507+02 1 93 0 0 -2006-03-28 22:39:11.755479+02 1 94 0 0 -2006-03-28 22:39:11.775257+02 1 95 0 0 -2006-03-28 22:39:11.795138+02 1 96 0 0 -2006-03-28 22:39:11.815197+02 1 97 240 1620567769 -2006-03-28 22:39:11.834833+02 1 98 39356 122027824 -2006-03-28 22:39:11.854636+02 1 99 9234 1182439 -2006-03-28 22:39:11.874374+02 1 100 240 28805070 -2006-03-28 22:39:11.894428+02 1 101 240 1096957 -2006-03-28 22:39:11.91458+02 1 102 620 619669 -2006-03-28 22:39:11.934683+02 1 103 0 0 -2006-03-28 22:39:11.954545+02 1 104 2746281650 1380471316 -2006-03-28 22:39:11.974981+02 1 105 0 0 -2006-03-28 22:39:11.994707+02 1 106 0 0 -2006-03-28 22:39:12.016469+02 1 107 0 0 -2006-03-28 22:39:12.036156+02 1 108 154278739 16885365 -2006-03-28 22:39:12.055859+02 1 109 0 953869 -2006-03-28 22:39:12.075687+02 1 110 11485 93069 -2006-03-28 22:39:12.095999+02 1 111 17993418 93133 -2006-03-28 22:39:12.1156+02 1 112 5310060 6561837 -2006-03-28 22:39:12.135708+02 1 113 0 97485 -2006-03-28 22:39:12.155377+02 1 114 0 0 -2006-03-28 22:39:12.174924+02 1 115 0 93133 -2006-03-28 22:39:12.195017+02 1 116 0 93133 -2006-03-28 22:39:12.214711+02 1 117 40502 130091 -2006-03-28 22:39:12.234355+02 1 118 0 0 -2006-03-28 22:39:12.253895+02 1 119 1440 1440 -2006-03-28 22:39:12.273878+02 1 120 49930 1774299728 -2006-03-28 22:39:12.383056+02 1 121 7476090 7476090 -2006-03-28 22:39:12.403941+02 1 122 0 0 -2006-03-28 22:39:12.424965+02 1 123 0 0 -2006-03-28 22:45:50.691773+02 1 1 0 0 -2006-03-28 22:45:50.712108+02 1 2 0 0 -2006-03-28 22:45:50.732551+02 1 3 0 0 -2006-03-28 22:45:50.752709+02 1 4 0 0 -2006-03-28 22:45:50.772544+02 1 5 0 0 -2006-03-28 22:45:50.792215+02 1 6 0 0 -2006-03-28 22:45:50.811996+02 1 7 0 0 -2006-03-28 22:45:50.838285+02 1 8 0 0 -2006-03-28 22:45:50.859209+02 1 9 0 0 -2006-03-28 22:45:50.879008+02 1 10 0 0 -2006-03-28 22:45:50.899314+02 1 11 0 0 -2006-03-28 22:45:50.918892+02 1 12 0 0 -2006-03-28 22:45:50.938681+02 1 13 7781011 14166925 -2006-03-28 22:45:50.958276+02 1 14 7742093 14093748 -2006-03-28 22:45:50.978192+02 1 15 8089140 17260526 -2006-03-28 22:45:50.998131+02 1 16 0 0 -2006-03-28 22:45:51.017874+02 1 17 0 0 -2006-03-28 22:45:51.037875+02 1 18 0 0 -2006-03-28 22:45:51.057617+02 1 19 138442049 203409365 -2006-03-28 22:45:51.07741+02 1 20 199872795 208568010 -2006-03-28 22:45:51.09707+02 1 21 6385320 14021490 -2006-03-28 22:45:51.116944+02 1 22 0 0 -2006-03-28 22:45:51.136723+02 1 23 0 0 -2006-03-28 22:45:51.156402+02 1 24 0 0 -2006-03-28 22:46:04.439098+02 1 1 0 0 -2006-03-28 22:46:04.459636+02 1 2 0 0 -2006-03-28 22:46:04.479286+02 1 3 0 0 -2006-03-28 22:46:04.498935+02 1 4 0 0 -2006-03-28 22:46:04.5186+02 1 5 0 0 -2006-03-28 22:46:04.538232+02 1 6 0 0 -2006-03-28 22:46:04.55788+02 1 7 0 0 -2006-03-28 22:46:04.577626+02 1 8 0 0 -2006-03-28 22:46:04.597683+02 1 9 0 0 -2006-03-28 22:46:04.617111+02 1 10 0 0 -2006-03-28 22:46:04.637422+02 1 11 0 0 -2006-03-28 22:46:04.657219+02 1 12 0 0 -2006-03-28 22:46:04.67687+02 1 13 7781329 14167539 -2006-03-28 22:46:04.696741+02 1 14 7742221 14094648 -2006-03-28 22:46:04.716788+02 1 15 8089268 17261268 -2006-03-28 22:46:04.736581+02 1 16 0 0 -2006-03-28 22:46:04.756341+02 1 17 0 0 -2006-03-28 22:46:04.775933+02 1 18 0 0 -2006-03-28 22:46:04.795543+02 1 19 138442495 203409877 -2006-03-28 22:46:04.815504+02 1 20 199872859 208568458 -2006-03-28 22:46:04.835122+02 1 21 6385384 14022032 -2006-03-28 22:46:04.855403+02 1 22 0 0 -2006-03-28 22:46:04.875114+02 1 23 0 0 -2006-03-28 22:46:04.895722+02 1 24 0 0 -2006-03-28 23:04:10.517298+02 1 1 0 0 -2006-03-28 23:04:10.537186+02 1 2 0 0 -2006-03-28 23:04:10.556902+02 1 3 0 0 -2006-03-28 23:04:10.576559+02 1 4 0 0 -2006-03-28 23:04:10.596516+02 1 5 0 0 -2006-03-28 23:04:10.617152+02 1 6 0 0 -2006-03-28 23:04:10.636818+02 1 7 0 0 -2006-03-28 23:04:10.656596+02 1 8 0 0 -2006-03-28 23:04:10.676103+02 1 9 0 0 -2006-03-28 23:04:10.696325+02 1 10 0 0 -2006-03-28 23:04:10.716109+02 1 11 0 0 -2006-03-28 23:04:10.736552+02 1 12 0 0 -2006-03-28 23:04:10.75648+02 1 13 7856336 14296955 -2006-03-28 23:04:10.776391+02 1 14 7823592 14228507 -2006-03-28 23:04:10.796099+02 1 15 8167545 17392530 -2006-03-28 23:04:10.816284+02 1 16 0 0 -2006-03-28 23:04:10.836317+02 1 17 0 0 -2006-03-28 23:04:10.855804+02 1 18 0 0 -2006-03-28 23:04:10.876015+02 1 19 138516087 203568321 -2006-03-28 23:04:10.896711+02 1 20 199973797 208768486 -2006-03-28 23:04:10.916745+02 1 21 6458453 14179252 -2006-03-28 23:04:10.937118+02 1 22 0 0 -2006-03-28 23:04:10.956641+02 1 23 0 0 -2006-03-28 23:04:10.976821+02 1 24 0 0 -2006-03-28 23:04:38.934053+02 1 1 0 0 -2006-03-28 23:04:38.95404+02 1 2 0 0 -2006-03-28 23:04:38.973763+02 1 3 0 0 -2006-03-28 23:04:38.993548+02 1 4 0 0 -2006-03-28 23:04:39.013146+02 1 5 0 0 -2006-03-28 23:04:39.032762+02 1 6 0 0 -2006-03-28 23:04:39.05292+02 1 7 0 0 -2006-03-28 23:04:39.073058+02 1 8 0 0 -2006-03-28 23:04:39.093076+02 1 9 0 0 -2006-03-28 23:04:39.112943+02 1 10 0 0 -2006-03-28 23:04:39.142183+02 1 11 0 0 -2006-03-28 23:04:39.16179+02 1 12 0 0 -2006-03-28 23:04:39.181511+02 1 13 7857656 14300001 -2006-03-28 23:04:39.201421+02 1 14 7825006 14231647 -2006-03-28 23:04:39.221197+02 1 15 8169119 17395512 -2006-03-28 23:04:39.24095+02 1 16 0 0 -2006-03-28 23:04:39.260593+02 1 17 0 0 -2006-03-28 23:04:39.28024+02 1 18 0 0 -2006-03-28 23:04:39.300251+02 1 19 138516907 203572473 -2006-03-28 23:04:39.320172+02 1 20 199974935 208772794 -2006-03-28 23:04:39.340547+02 1 21 6459209 14183340 -2006-03-28 23:04:39.36032+02 1 22 0 0 -2006-03-28 23:04:39.379996+02 1 23 0 0 -2006-03-28 23:04:39.399682+02 1 24 0 0 -2006-03-28 23:08:25.811543+02 1 1 0 0 -2006-03-28 23:08:25.832178+02 1 2 0 0 -2006-03-28 23:08:25.851821+02 1 3 0 0 -2006-03-28 23:08:25.871447+02 1 4 0 0 -2006-03-28 23:08:25.891095+02 1 5 0 0 -2006-03-28 23:08:25.911042+02 1 6 0 0 -2006-03-28 23:08:25.930796+02 1 7 0 0 -2006-03-28 23:08:25.950443+02 1 8 0 0 -2006-03-28 23:08:25.970441+02 1 9 0 0 -2006-03-28 23:08:25.990093+02 1 10 0 0 -2006-03-28 23:08:26.009844+02 1 11 0 0 -2006-03-28 23:08:26.029585+02 1 12 0 0 -2006-03-28 23:08:26.04914+02 1 13 7876029 14330508 -2006-03-28 23:08:26.068755+02 1 14 7842402 14260671 -2006-03-28 23:08:26.088424+02 1 15 8186302 17425712 -2006-03-28 23:08:26.108129+02 1 16 0 0 -2006-03-28 23:08:26.128018+02 1 17 0 0 -2006-03-28 23:08:26.147692+02 1 18 0 0 -2006-03-28 23:08:26.167393+02 1 19 138532007 203604699 -2006-03-28 23:08:26.187095+02 1 20 199996249 208814508 -2006-03-28 23:08:26.206925+02 1 21 6474499 14215586 -2006-03-28 23:08:26.226462+02 1 22 0 0 -2006-03-28 23:08:26.246118+02 1 23 0 0 -2006-03-28 23:08:26.265827+02 1 24 0 0 -2006-03-28 23:09:33.136981+02 1 1 0 0 -2006-03-28 23:09:33.15741+02 1 2 0 0 -2006-03-28 23:09:33.177081+02 1 3 0 0 -2006-03-28 23:09:33.196591+02 1 4 0 0 -2006-03-28 23:09:33.216282+02 1 5 0 0 -2006-03-28 23:09:33.235922+02 1 6 0 0 -2006-03-28 23:09:33.255785+02 1 7 0 0 -2006-03-28 23:09:33.27593+02 1 8 0 0 -2006-03-28 23:09:33.295795+02 1 9 0 0 -2006-03-28 23:09:33.3154+02 1 10 0 0 -2006-03-28 23:09:33.337366+02 1 11 0 0 -2006-03-28 23:09:33.357016+02 1 12 0 0 -2006-03-28 23:09:33.376724+02 1 13 7880337 14338168 -2006-03-28 23:09:33.396546+02 1 14 7845454 14268425 -2006-03-28 23:09:33.416402+02 1 15 8189578 17433278 -2006-03-28 23:09:33.436008+02 1 16 0 0 -2006-03-28 23:09:33.455964+02 1 17 0 0 -2006-03-28 23:09:33.475705+02 1 18 0 0 -2006-03-28 23:09:33.495599+02 1 19 138538669 203617075 -2006-03-28 23:09:33.515334+02 1 20 200004048 208829958 -2006-03-28 23:09:33.535467+02 1 21 6478630 14226719 -2006-03-28 23:09:33.556044+02 1 22 0 0 -2006-03-28 23:09:33.575656+02 1 23 0 0 -2006-03-28 23:09:33.595203+02 1 24 0 0 -2006-03-28 23:09:35.995013+02 1 1 0 0 -2006-03-28 23:09:36.014831+02 1 2 0 0 -2006-03-28 23:09:36.035206+02 1 3 0 0 -2006-03-28 23:09:36.054957+02 1 4 0 0 -2006-03-28 23:09:36.074448+02 1 5 0 0 -2006-03-28 23:09:36.094459+02 1 6 0 0 -2006-03-28 23:09:36.114187+02 1 7 0 0 -2006-03-28 23:09:36.134162+02 1 8 0 0 -2006-03-28 23:09:36.153924+02 1 9 0 0 -2006-03-28 23:09:36.173467+02 1 10 0 0 -2006-03-28 23:09:36.192962+02 1 11 0 0 -2006-03-28 23:09:36.212584+02 1 12 0 0 -2006-03-28 23:09:36.232421+02 1 13 7880337 14338168 -2006-03-28 23:09:36.252247+02 1 14 7845454 14268425 -2006-03-28 23:09:36.271956+02 1 15 8189578 17433278 -2006-03-28 23:09:36.291855+02 1 16 0 0 -2006-03-28 23:09:36.311497+02 1 17 0 0 -2006-03-28 23:09:36.331351+02 1 18 0 0 -2006-03-28 23:09:36.351106+02 1 19 138538669 203617075 -2006-03-28 23:09:36.371495+02 1 20 200004048 208829958 -2006-03-28 23:09:36.391472+02 1 21 6478630 14226719 -2006-03-28 23:09:36.411218+02 1 22 0 0 -2006-03-28 23:09:36.432314+02 1 23 0 0 -2006-03-28 23:09:36.452165+02 1 24 0 0 -2006-03-28 23:15:40.752379+02 1 1 0 0 -2006-03-28 23:15:40.772684+02 1 2 0 0 -2006-03-28 23:15:40.792228+02 1 3 0 0 -2006-03-28 23:15:40.811814+02 1 4 0 0 -2006-03-28 23:15:40.83156+02 1 5 0 0 -2006-03-28 23:15:40.851352+02 1 6 0 0 -2006-03-28 23:15:40.870986+02 1 7 0 0 -2006-03-28 23:15:40.890991+02 1 8 0 0 -2006-03-28 23:15:40.911205+02 1 9 0 0 -2006-03-28 23:15:40.931349+02 1 10 0 0 -2006-03-28 23:15:40.951733+02 1 11 0 0 -2006-03-28 23:15:40.971545+02 1 12 0 0 -2006-03-28 23:15:40.991322+02 1 13 7911314 14387025 -2006-03-28 23:15:41.010894+02 1 14 7871637 14313012 -2006-03-28 23:15:41.031336+02 1 15 8219073 17479349 -2006-03-28 23:15:41.051693+02 1 16 0 0 -2006-03-28 23:15:41.071363+02 1 17 0 0 -2006-03-28 23:15:41.091194+02 1 18 0 0 -2006-03-28 23:15:41.111185+02 1 19 138562273 203670334 -2006-03-28 23:15:41.131322+02 1 20 200037822 208897207 -2006-03-28 23:15:41.15099+02 1 21 6502475 14279258 -2006-03-28 23:15:41.171033+02 1 22 0 0 -2006-03-28 23:15:41.190836+02 1 23 0 0 -2006-03-28 23:15:41.210909+02 1 24 0 0 -2006-03-28 23:16:18.461384+02 1 1 0 0 -2006-03-28 23:16:18.481697+02 1 2 0 0 -2006-03-28 23:16:18.501411+02 1 3 0 0 -2006-03-28 23:16:18.521355+02 1 4 0 0 -2006-03-28 23:16:18.541475+02 1 5 0 0 -2006-03-28 23:16:18.561151+02 1 6 0 0 -2006-03-28 23:16:18.581281+02 1 7 0 0 -2006-03-28 23:16:18.601048+02 1 8 0 0 -2006-03-28 23:16:18.621418+02 1 9 0 0 -2006-03-28 23:16:18.641084+02 1 10 0 0 -2006-03-28 23:16:18.660893+02 1 11 0 0 -2006-03-28 23:16:18.680749+02 1 12 0 0 -2006-03-28 23:16:18.700982+02 1 13 7914272 14391758 -2006-03-28 23:16:18.720543+02 1 14 7874595 14317587 -2006-03-28 23:16:18.740221+02 1 15 8221649 17484018 -2006-03-28 23:16:18.760369+02 1 16 0 0 -2006-03-28 23:16:18.780054+02 1 17 0 0 -2006-03-28 23:16:18.800943+02 1 18 0 0 -2006-03-28 23:16:18.820712+02 1 19 138564103 203674931 -2006-03-28 23:16:18.84036+02 1 20 200041217 208903898 -2006-03-28 23:16:18.860027+02 1 21 6506271 14285384 -2006-03-28 23:16:18.87964+02 1 22 0 0 -2006-03-28 23:16:18.899632+02 1 23 0 0 -2006-03-28 23:16:18.919771+02 1 24 0 0 -2006-03-29 14:21:06.538631+02 1 1 0 0 -2006-03-29 14:21:06.566347+02 1 2 0 0 -2006-03-29 14:21:06.586281+02 1 3 0 0 -2006-03-29 14:21:06.606101+02 1 4 0 0 -2006-03-29 14:21:06.626253+02 1 5 0 0 -2006-03-29 14:21:06.646471+02 1 6 0 0 -2006-03-29 14:21:06.666186+02 1 7 0 0 -2006-03-29 14:21:06.685778+02 1 8 0 0 -2006-03-29 14:21:06.705397+02 1 9 0 0 -2006-03-29 14:21:06.725104+02 1 10 0 0 -2006-03-29 14:21:06.745612+02 1 11 0 0 -2006-03-29 14:21:06.765703+02 1 12 0 0 -2006-03-29 14:21:06.785214+02 1 13 11913823 21156032 -2006-03-29 14:21:06.805512+02 1 14 11834383 21035751 -2006-03-29 14:21:06.825285+02 1 15 12216402 24218350 -2006-03-29 14:21:06.845644+02 1 16 0 0 -2006-03-29 14:21:06.865666+02 1 17 0 0 -2006-03-29 14:21:06.885942+02 1 18 0 0 -2006-03-29 14:21:06.905781+02 1 19 142415383 211673321 -2006-03-29 14:21:06.926271+02 1 20 205266368 218989817 -2006-03-29 14:21:06.946227+02 1 21 10315756 22231663 -2006-03-29 14:21:06.966297+02 1 22 0 0 -2006-03-29 14:21:06.985762+02 1 23 0 0 -2006-03-29 14:21:07.005733+02 1 24 0 0 -\. - -- -- Data for Name: portnames; Type: TABLE DATA; Schema: public; Owner: postgres @@ -1545,19 +705,6 @@ COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, pr \. --- --- Data for Name: switches; Type: TABLE DATA; Schema: public; Owner: postgres --- - -COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin; -210 81.162.239.10 noc cisco6509 2005-03-27 13:21:26.109659+02 f 5 00:00:20 removed -1 62.148.36.20 zorro cisco6509 2006-03-29 14:21:06.525009+02 f 5 00:01:00 tg06 -\. - - --- --- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: postgres --- COPY switchtypes (switchtype, ports, wide_counters) FROM stdin; blackdiamond 1001-1007,4001-4016,5001-5024,6001-6048 f -- 2.39.2