| 1 |
|
--
|
| 2 |
|
-- PostgreSQL database dump
|
| 3 |
|
--
|
| 4 |
|
|
| 5 |
|
SET client_encoding = 'SQL_ASCII';
|
| 6 |
|
SET standard_conforming_strings = off;
|
| 7 |
|
SET check_function_bodies = false;
|
| 8 |
|
SET client_min_messages = warning;
|
| 9 |
|
SET escape_string_warning = off;
|
| 10 |
|
|
| 11 |
|
SET search_path = public, pg_catalog;
|
| 12 |
|
|
| 13 |
|
--
|
| 14 |
|
-- Name: event_history_idhistory_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 15 |
|
--
|
| 16 |
|
|
| 17 |
|
SELECT pg_catalog.setval('event_history_idhistory_seq', 322801, true);
|
| 18 |
|
|
| 19 |
|
|
| 20 |
|
--
|
| 21 |
|
-- Name: events_idevent_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 22 |
|
--
|
| 23 |
|
|
| 24 |
|
SELECT pg_catalog.setval('events_idevent_seq', 28, true);
|
| 25 |
|
|
| 26 |
|
|
| 27 |
|
--
|
| 28 |
|
-- Name: state_idstat_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 29 |
|
--
|
| 30 |
|
|
| 31 |
|
SELECT pg_catalog.setval('state_idstat_seq', 47, true);
|
| 32 |
|
|
| 33 |
|
|
| 34 |
|
--
|
| 35 |
|
-- Name: tg_group_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 36 |
|
--
|
| 37 |
|
|
| 38 |
|
SELECT pg_catalog.setval('tg_group_group_id_seq', 2, true);
|
| 39 |
|
|
| 40 |
|
|
| 41 |
|
--
|
| 42 |
|
-- Name: tg_permission_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 43 |
|
--
|
| 44 |
|
|
| 45 |
|
SELECT pg_catalog.setval('tg_permission_permission_id_seq', 2, true);
|
| 46 |
|
|
| 47 |
|
|
| 48 |
|
--
|
| 49 |
|
-- Name: tg_user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vigiboard
|
| 50 |
|
--
|
| 51 |
|
|
| 52 |
|
SELECT pg_catalog.setval('tg_user_user_id_seq', 2, true);
|
| 53 |
|
|
| 54 |
|
|
| 55 |
|
|
| 56 |
|
|
| 57 |
|
--
|
| 58 |
|
-- Data for Name: graph; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 59 |
|
--
|
| 60 |
|
|
| 61 |
|
|
| 62 |
|
|
| 63 |
|
--
|
| 64 |
|
-- Data for Name: graphgroups; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 65 |
|
--
|
| 66 |
|
|
| 67 |
|
|
| 68 |
|
|
| 69 |
|
--
|
| 70 |
|
-- Data for Name: graphtogroups; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 71 |
|
--
|
| 72 |
|
|
| 73 |
|
|
| 74 |
|
--
|
| 75 |
|
-- Data for Name: host; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 76 |
|
--
|
| 77 |
|
|
| 78 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('ajc.fw.1', 'check1', 'com1', 'fqhn1', 'tpl1', '192.168.0.1', 1, 1, '1');
|
| 79 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('ajc.linux1', 'check2', 'com2', 'fqhn2', 'tpl2', '192.168.0.2', 2, 2, '2');
|
| 80 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('ajc.sw.1', 'check3', 'com3', 'fqhn3', 'tpl3', '192.168.0.3', 3, 3, '3');
|
| 81 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bdx.fw.1', 'check4', 'com4', 'fqhn4', 'tpl4', '192.168.0.4', 4, 4, '4');
|
| 82 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bdx.linux1', 'check5', 'com5', 'fqhn5', 'tpl5', '192.168.0.5', 5, 5, '5');
|
| 83 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('brouteur', 'check6', 'com6', 'fqhn6', 'tpl6', '192.168.0.6', 6, 6, '6');
|
| 84 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bst.fw.1', 'check7', 'com7', 'fqhn7', 'tpl7', '192.168.0.7', 7, 7, '7');
|
| 85 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bst.unix0', 'check8', 'com8', 'fqhn8', 'tpl8', '192.168.0.8', 8, 8, '8');
|
| 86 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bst.unix1', 'check9', 'com9', 'fqhn9', 'tpl9', '192.168.0.9', 9, 9, '9');
|
| 87 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('bst.win0', 'check10', 'com10', 'fqhn10', 'tpl10', '192.168.0.10', 10, 10, '10');
|
| 88 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('messagerie', 'check11', 'com11', 'fqhn11', 'tpl11', '192.168.0.11', 11, 11, '11');
|
| 89 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('par.fw.1', 'check12', 'com12', 'fqhn12', 'tpl12', '192.168.0.12', 12, 12, '12');
|
| 90 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('par.linux0', 'check13', 'com13', 'fqhn13', 'tpl13', '192.168.0.13', 13, 13, '13');
|
| 91 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('par.linux1', 'check14', 'com14', 'fqhn14', 'tpl14', '192.168.0.14', 14, 14, '14');
|
| 92 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('par.unix0', 'check15', 'com15', 'fqhn15', 'tpl15', '192.168.0.15', 15, 15, '15');
|
| 93 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('proto4', 'check16', 'com16', 'fqhn16', 'tpl16', '192.168.0.16', 16, 16, '16');
|
| 94 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('server.mails', 'check17', 'com17', 'fqhn17', 'tpl17', '192.168.0.17', 17, 17, '17');
|
| 95 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('testaix', 'check18', 'com18', 'fqhn18', 'tpl18', '192.168.0.18', 18, 18, '18');
|
| 96 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('testnortel', 'check19', 'com19', 'fqhn19', 'tpl19', '192.168.0.19', 19, 19, '19');
|
| 97 |
|
INSERT INTO host (name, checkhostcmd, community, fqhn, hosttpl, mainip, port, snmpoidsperpdu, snmpversion) VALUES ('testsolaris', 'check20', 'com20', 'fqhn20', 'tpl20', '192.168.0.20', 20, 20, '20');
|
| 98 |
|
|
| 99 |
|
--
|
| 100 |
|
-- Data for Name: service; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 101 |
|
--
|
| 102 |
|
|
| 103 |
|
INSERT INTO service (name, type, command) VALUES ('Charge 01', '1', 'cmd1');
|
| 104 |
|
INSERT INTO service (name, type, command) VALUES ('Charge 05', '2', 'cmd2');
|
| 105 |
|
INSERT INTO service (name, type, command) VALUES ('Charge 15', '3', 'cmd3');
|
| 106 |
|
INSERT INTO service (name, type, command) VALUES ('Collector', '4', 'cmd4');
|
| 107 |
|
INSERT INTO service (name, type, command) VALUES ('CPU', '5', 'cmd5');
|
| 108 |
|
INSERT INTO service (name, type, command) VALUES ('Entrees / Sorties', '6', 'cmd6');
|
| 109 |
|
INSERT INTO service (name, type, command) VALUES ('FakeSNMPVal', '7', 'cmd7');
|
| 110 |
|
INSERT INTO service (name, type, command) VALUES ('FakeSNMPVal2', '8', 'cmd8');
|
| 111 |
|
INSERT INTO service (name, type, command) VALUES ('Partition Donnees', '9', 'cmd9');
|
| 112 |
|
INSERT INTO service (name, type, command) VALUES ('Partition Fausse part', '10', 'cmd10');
|
| 113 |
|
INSERT INTO service (name, type, command) VALUES ('Partition Root', '11', 'cmd11');
|
| 114 |
|
INSERT INTO service (name, type, command) VALUES ('Processes', '12', 'cmd12');
|
| 115 |
|
INSERT INTO service (name, type, command) VALUES ('Processus: cleanup', '13', 'cmd13');
|
| 116 |
|
INSERT INTO service (name, type, command) VALUES ('Processus: pop3d', '14', 'cmd14');
|
| 117 |
|
INSERT INTO service (name, type, command) VALUES ('Synchro NTP', '15', 'cmd15');
|
| 118 |
|
INSERT INTO service (name, type, command) VALUES ('TCP connections', '16', 'cmd16');
|
| 119 |
|
INSERT INTO service (name, type, command) VALUES ('Temperature mb_p0_t_core', '17', 'cmd17');
|
| 120 |
|
INSERT INTO service (name, type, command) VALUES ('UpTime', '18', 'cmd18');
|
| 121 |
|
INSERT INTO service (name, type, command) VALUES ('Ventilateur mb_p0_f0_rs', '19', 'cmd19');
|
| 122 |
|
|
| 123 |
|
--
|
| 124 |
|
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 125 |
|
--
|
| 126 |
|
|
| 127 |
|
INSERT INTO groups (name, parent) VALUES ('bla1', NULL);
|
| 128 |
|
INSERT INTO groups (name, parent) VALUES ('bla2', 'bla1');
|
| 129 |
|
|
| 130 |
|
|
| 131 |
|
|
| 132 |
|
--
|
| 133 |
|
-- Data for Name: grouppermissions; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 134 |
|
--
|
| 135 |
|
|
| 136 |
|
INSERT INTO grouppermissions (groupname, idpermission) VALUES ('bla1', 1);
|
| 137 |
|
INSERT INTO grouppermissions (groupname, idpermission) VALUES ('bla2', 2);
|
| 138 |
|
|
| 139 |
|
|
| 140 |
|
--
|
| 141 |
|
-- Data for Name: hostgroups; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 142 |
|
--
|
| 143 |
|
|
| 144 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('ajc.fw.1', 'bla1');
|
| 145 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('ajc.linux1', 'bla1');
|
| 146 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('ajc.sw.1', 'bla1');
|
| 147 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bdx.fw.1', 'bla1');
|
| 148 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bdx.linux1', 'bla1');
|
| 149 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('brouteur', 'bla1');
|
| 150 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bst.fw.1', 'bla1');
|
| 151 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bst.unix0', 'bla1');
|
| 152 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bst.unix1', 'bla1');
|
| 153 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('bst.win0', 'bla2');
|
| 154 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('messagerie', 'bla2');
|
| 155 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('par.fw.1', 'bla2');
|
| 156 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('par.linux0', 'bla2');
|
| 157 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('par.linux1', 'bla2');
|
| 158 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('par.unix0', 'bla2');
|
| 159 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('proto4', 'bla2');
|
| 160 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('server.mails', 'bla2');
|
| 161 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('testaix', 'bla2');
|
| 162 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('testnortel', 'bla2');
|
| 163 |
|
INSERT INTO hostgroups (hostname, groupname) VALUES ('testsolaris', 'bla2');
|
| 164 |
|
|
| 165 |
|
|
| 166 |
|
--
|
| 167 |
|
-- Data for Name: perfdatasource; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 168 |
|
--
|
| 169 |
|
|
| 170 |
|
|
| 171 |
|
|
| 172 |
|
|
| 173 |
|
|
| 174 |
|
--
|
| 175 |
|
-- Data for Name: servicegroups; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 176 |
|
--
|
| 177 |
|
|
| 178 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Charge 01', 'bla1');
|
| 179 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Charge 05', 'bla1');
|
| 180 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Charge 15', 'bla1');
|
| 181 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Collector', 'bla1');
|
| 182 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('CPU', 'bla1');
|
| 183 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Entrees / Sorties', 'bla1');
|
| 184 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('FakeSNMPVal', 'bla1');
|
| 185 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('FakeSNMPVal2', 'bla1');
|
| 186 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Partition Donnees', 'bla1');
|
| 187 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Partition Fausse part', 'bla1');
|
| 188 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Partition Root', 'bla1');
|
| 189 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Processes', 'bla1');
|
| 190 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Processus: cleanup', 'bla1');
|
| 191 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Processus: pop3d', 'bla1');
|
| 192 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Synchro NTP', 'bla1');
|
| 193 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('TCP connections', 'bla1');
|
| 194 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Temperature mb_p0_t_core', 'bla1');
|
| 195 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('UpTime', 'bla1');
|
| 196 |
|
INSERT INTO servicegroups (servicename, groupname) VALUES ('Ventilateur mb_p0_f0_rs', 'bla1');
|
| 197 |
|
|
| 198 |
|
|
| 199 |
|
--
|
| 200 |
|
-- Data for Name: servicehautniveau; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 201 |
|
--
|
| 202 |
|
|
| 203 |
|
INSERT INTO servicehautniveau (servicename, servicename_dep) VALUES ('Charge 01', 'Charge 15');
|
| 204 |
|
INSERT INTO servicehautniveau (servicename, servicename_dep) VALUES ('Charge 05', 'Charge 15');
|
| 205 |
|
INSERT INTO servicehautniveau (servicename, servicename_dep) VALUES ('Charge 15', 'UpTime');
|
| 206 |
|
INSERT INTO servicehautniveau (servicename, servicename_dep) VALUES ('CPU', 'UpTime');
|
| 207 |
|
|
| 208 |
|
|
| 209 |
|
--
|
| 210 |
|
-- Data for Name: servicetopo; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 211 |
|
--
|
| 212 |
|
|
| 213 |
|
|
| 214 |
|
|
| 215 |
|
--
|
| 216 |
|
-- Data for Name: state; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 217 |
|
--
|
| 218 |
|
|
| 219 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (36, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 220 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (37, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 221 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (38, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 222 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (39, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 223 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (41, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 224 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (42, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 225 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (43, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 226 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (44, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 227 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (45, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 228 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (46, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 229 |
|
INSERT INTO state (idstat, hostname, servicename, ip, "timestamp", statename, type, attempt, message) VALUES (47, 'ajc.fw.1', 'Processes', '192.168.1.1', '2009-04-07 13:33:26', 'WARNING', 'SOFT', 2, 'WARNING: Charge 01 average is above 4 (4.5)');
|
| 230 |
|
|
| 231 |
|
|
| 232 |
|
--
|
| 233 |
|
-- Data for Name: tg_group; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 234 |
|
--
|
| 235 |
|
|
| 236 |
|
INSERT INTO tg_group (group_id, group_name, display_name, created) VALUES (1, 'managers', 'Managers Group', '2009-07-30 11:41:53.827429');
|
| 237 |
|
INSERT INTO tg_group (group_id, group_name, display_name, created) VALUES (2, 'editors', 'Editors Group', '2009-07-30 11:41:53.830247');
|
| 238 |
|
|
| 239 |
|
--
|
| 240 |
|
-- Data for Name: tg_permission; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 241 |
|
--
|
| 242 |
|
|
| 243 |
|
INSERT INTO tg_permission (permission_id, permission_name, description) VALUES (1, 'manage', 'This permission give an administrative right to the bearer');
|
| 244 |
|
INSERT INTO tg_permission (permission_id, permission_name, description) VALUES (2, 'edit', 'This permission give an Editor the right to edit');
|
| 245 |
|
|
| 246 |
|
|
| 247 |
|
--
|
| 248 |
|
-- Data for Name: tg_group_permission; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 249 |
|
--
|
| 250 |
|
|
| 251 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 252 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (2, 2);
|
| 253 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (2, 2);
|
| 254 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 255 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 256 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 257 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 258 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 259 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 260 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 261 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 262 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 263 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 264 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (2, 2);
|
| 265 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 266 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 267 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 268 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 269 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 270 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 271 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 272 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 273 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 274 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 275 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (2, 2);
|
| 276 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 277 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 278 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 279 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 280 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 281 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 282 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 283 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 284 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 285 |
|
INSERT INTO tg_group_permission (group_id, permission_id) VALUES (1, 1);
|
| 286 |
|
|
| 287 |
|
|
| 288 |
|
|
| 289 |
|
--
|
| 290 |
|
-- Data for Name: tg_user; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 291 |
|
--
|
| 292 |
|
|
| 293 |
|
INSERT INTO tg_user (user_id, user_name, email_address, display_name, password, created) VALUES (1, 'manager', 'manager@somedomain.com', 'Example manager', '3ee2d6b235795773c40dcd7dd992a00a481a712a6c04d6d18c3c4feab1705fc6692cf0408f330c44', '2009-07-30 11:41:53.840328');
|
| 294 |
|
INSERT INTO tg_user (user_id, user_name, email_address, display_name, password, created) VALUES (2, 'editor', 'editor@somedomain.com', 'Example editor', '84983f2f7c2e67a65e7dbd200f91caf000845334ff81c9e449ffc7392e71bcc2738f0b3eb1c6ba16', '2009-07-30 11:41:53.843094');
|
| 295 |
|
|
| 296 |
|
|
| 297 |
|
--
|
| 298 |
|
-- Data for Name: tg_user_group; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 299 |
|
--
|
| 300 |
|
|
| 301 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (2, 2);
|
| 302 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 303 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (2, 2);
|
| 304 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 305 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 306 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 307 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 308 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 309 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 310 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 311 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 312 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 313 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 314 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (2, 2);
|
| 315 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 316 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 317 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 318 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 319 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 320 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 321 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 322 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 323 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 324 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 325 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (2, 2);
|
| 326 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 327 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 328 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 329 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 330 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 331 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 332 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 333 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 334 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 335 |
|
INSERT INTO tg_user_group (user_id, group_id) VALUES (1, 1);
|
| 336 |
|
|
| 337 |
|
|
| 338 |
|
--
|
| 339 |
|
-- Data for Name: version; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 340 |
|
--
|
| 341 |
|
|
| 342 |
|
INSERT INTO version (name, version) VALUES ('vigiboard', '0.1');
|
| 343 |
|
|
| 344 |
|
|
| 345 |
|
--
|
| 346 |
|
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 347 |
|
--
|
| 348 |
|
|
| 349 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (23, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'CRITICAL: Charge 01 average is above 5 (5.2)', '2009-08-03 15:52:23.906009', NULL, 2, NULL, 'CRITICAL');
|
| 350 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (24, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'WARNING: Charge 01 average is above 4 (4.5)', '2009-08-03 15:52:23.906009', NULL, 2, 130, 'WARNING');
|
| 351 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (25, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'WARNING: Charge 01 average is above 4 (4.5)', '2009-08-03 15:52:23.906009', NULL, 2, 130, 'WARNING');
|
| 352 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7076, 'brouteur', 'Temperature mb_p0_t_core', 1, 'Acknowledged', true, '2008-06-17 17:19:19', 'WARNING: Temperature: 63.00 Celsius degrees', '2008-06-17 17:19:19', NULL, 1, NULL, NULL);
|
| 353 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7077, 'par.linux1', 'Partition Fausse part', 2, 'None', true, '2008-06-17 17:19:34', 'WARNING: Usage: 8.12 MB (85.95%)', '2008-06-17 17:30:34', NULL, 3, NULL, NULL);
|
| 354 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7078, 'messagerie', 'Partition Root', 3, 'None', true, '2008-06-17 17:19:58', 'WARNING: Usage: 859.78 MB (85.30%)', '2008-06-17 17:19:58', NULL, 1, NULL, NULL);
|
| 355 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7079, 'messagerie', 'Processes', 4, 'None', true, '2008-06-17 17:19:58', 'WARNING: 823 processus en cours', '2008-07-10 11:57:56', NULL, 170, NULL, NULL);
|
| 356 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7080, 'testsolaris', 'Temperature mb_p0_t_core', 5, 'Acknowledged', false, '2008-06-17 17:20:04', 'WARNING: Temperature: 61.00 Celsius degrees', '2008-07-04 08:20:12', NULL, 9, NULL, NULL);
|
| 357 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7081, 'bdx.linux1', 'Collector', 6, 'None', true, '2008-06-17 17:21:16', 'WARNING2: SNMP error: No response from remote host 172.17.103.144', '2008-06-17 17:21:16', '', 1, NULL, NULL);
|
| 358 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7082, 'testsolaris', 'Ventilateur mb_p0_f0_rs', 7, 'AAClosed', false, '2008-06-17 17:21:20', 'CRITICAL: Vitesse : 0 tours/min', '2008-06-17 17:21:20', NULL, 1, NULL, NULL);
|
| 359 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7083, 'messagerie', 'Charge 01', 1, 'Acknowledged', false, '2008-06-17 17:25:58', 'WARNING: Charge : 10.03', '2008-06-24 16:47:17', '2', 138, NULL, NULL);
|
| 360 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7084, 'messagerie', 'Processus: pop3d', 2, 'Acknowledged', false, '2008-06-17 17:27:58', 'CRITICAL: 0 instances de pop3d trouvees', '2008-07-04 15:38:24', NULL, 2668, NULL, NULL);
|
| 361 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7085, 'par.linux1', 'Partition Fausse part', 3, 'Acknowledged', false, '2008-06-17 17:35:50', 'WARNING: Usage: 8.12 MB (85.95%)', '2008-06-17 17:55:34', NULL, 2, NULL, NULL);
|
| 362 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7086, 'testaix', 'FakeSNMPVal', 4, 'Acknowledged', false, '2008-06-17 17:40:13', 'WARNING: Fake sine Value: 533', '2008-07-03 17:09:21', NULL, 780, NULL, NULL);
|
| 363 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7087, 'proto4', 'FakeSNMPVal', 5, 'Acknowledged', false, '2008-06-17 17:40:13', 'WARNING: Fake sine Value: 527', '2008-06-24 16:28:56', NULL, 361, NULL, NULL);
|
| 364 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7088, 'bdx.fw.1', 'FakeSNMPVal', 6, 'Acknowledged', false, '2008-06-17 17:53:52', 'WARNING: Fake sine Value: 4689', '2008-07-30 08:53:44', NULL, 2165, NULL, NULL);
|
| 365 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7089, 'bst.unix1', 'FakeSNMPVal', 7, 'None', false, '2008-06-17 17:54:34', 'WARNING: Fake sine Value: 4687', '2008-07-30 08:53:44', '12', 2165, NULL, NULL);
|
| 366 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7090, 'par.linux1', 'Partition Donnees', 1, 'AAClosed', true, '2008-06-17 17:57:41', 'WARNING: Usage: 8.12 MB (85.95%)', '2008-06-17 18:06:41', NULL, 3, NULL, NULL);
|
| 367 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7091, 'ajc.fw.1', 'FakeSNMPVal', 2, 'AAClosed', true, '2008-06-17 18:01:23', 'WARNING: Fake sine Value: 641', '2008-07-10 15:04:02', NULL, 1140, NULL, NULL);
|
| 368 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7092, 'bst.fw.1', 'FakeSNMPVal', 3, 'AAClosed', true, '2008-06-17 18:01:26', 'WARNING: Fake sine Value: 641', '2008-07-10 15:04:02', NULL, 1140, NULL, NULL);
|
| 369 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7093, 'par.fw.1', 'FakeSNMPVal', 4, 'AAClosed', true, '2008-06-17 18:01:53', 'WARNING: Fake sine Value: 5360', '2008-07-30 08:40:39', NULL, 2163, NULL, NULL);
|
| 370 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7094, 'par.linux1', 'Partition Donnees', 5, 'AAClosed', false, '2008-06-17 18:11:57', 'WARNING: Usage: 8.44 MB (89.36%)', '2008-06-20 11:29:51', NULL, 6, NULL, NULL);
|
| 371 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7095, 'proto4', 'FakeSNMPVal2', 6, 'AAClosed', true, '2008-06-17 19:14:20', 'WARNING: Fake sine Value: 5480', '2008-06-24 08:28:56', NULL, 42, NULL, NULL);
|
| 372 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7096, 'messagerie', 'Charge 05', 7, 'AAClosed', true, '2008-06-18 07:51:15', 'WARNING: Charge: 10.02', '2008-06-24 15:32:17', NULL, 53, NULL, NULL);
|
| 373 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7097, 'messagerie', 'Charge 15', 1, 'AAClosed', false, '2008-06-18 07:58:15', 'WARNING: Charge: 8.21', '2008-06-24 11:46:17', NULL, 21, NULL, NULL);
|
| 374 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7098, 'messagerie', 'TCP connections', 2, 'AAClosed', false, '2008-06-18 11:22:18', 'WARNING: 1014 connexions TCP etablies', '2008-07-04 11:34:38', NULL, 20, NULL, NULL);
|
| 375 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7100, 'messagerie', 'Processus: cleanup', 3, 'AAClosed', false, '2008-06-18 21:21:15', 'CRITICAL: 0 instances de cleanup trouvees', '2008-07-03 03:56:14', NULL, 269, NULL, NULL);
|
| 376 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7101, 'messagerie', 'Entrees / Sorties', 4, 'AAClosed', false, '2008-06-19 00:02:07', 'CRITICAL: Ecritures a 15ko/s', '2008-06-19 00:02:10', NULL, 2, NULL, NULL);
|
| 377 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7102, 'testnortel', 'CPU', 5, 'AAClosed', false, '2008-06-19 10:45:06', 'CRITICAL: CPU : 92%', '2008-06-19 10:45:06', NULL, 1, NULL, NULL);
|
| 378 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7103, 'brouteur', 'Synchro NTP', 5, 'AAClosed', false, '2008-06-20 05:31:34', 'NTP CRITICAL: No response from NTP server', '2008-06-23 09:56:04', NULL, 4, NULL, NULL);
|
| 379 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7104, 'testaix', 'Synchro NTP', 7, 'AAClosed', false, '2008-06-20 05:31:45', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-06-20 16:08:23', NULL, 2, NULL, NULL);
|
| 380 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7105, 'testsolaris', 'Synchro NTP', 6, 'None', true, '2008-06-20 05:32:19', 'NTP CRITICAL: No response from NTP server', '2008-07-04 05:32:57', NULL, 5, NULL, NULL);
|
| 381 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7109, 'bst.win0', 'Collector', 6, 'None', true, '2008-06-20 15:13:35', 'CRITICAL: No response (timeout)', '2008-06-23 09:28:26', NULL, 27, NULL, NULL);
|
| 382 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7207, 'par.linux1', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 10.16 (430 s)', '2008-07-03 21:02:42', NULL, 8, NULL, NULL);
|
| 383 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7208, 'ajc.fw.1', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 10.13 (430 s)', '2008-07-03 21:02:42', '2', 8, NULL, NULL);
|
| 384 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (26, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'WARNING: Charge 01 average is above 4 (4.5)', '2009-08-03 15:53:25.230363', NULL, 2, 130, 'WARNING');
|
| 385 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (27, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'WARNING: Charge 01 average is above 4 (4.5)', '2009-08-03 15:53:25.230363', NULL, 2, 130, 'WARNING');
|
| 386 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (28, 'ajc.fw.1', 'Charge 01', 7, 'None', true, '2009-04-07 13:33:26', 'CRITICAL: Charge 01 average is above 5 (5.2)', '2009-08-03 15:53:25.230363', NULL, 2, 130, 'CRITICAL');
|
| 387 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7209, 'par.linux0', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 42.57 (462 s)', '2008-07-03 21:03:17', NULL, 8, NULL, NULL);
|
| 388 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7210, 'server.mails', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 19.85 (439 s)', '2008-07-09 10:11:28', NULL, 16, NULL, NULL);
|
| 389 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7211, 'bst.unix0', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 10.33 (430 s)', '2008-07-03 21:02:42', NULL, 8, NULL, NULL);
|
| 390 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7212, 'bdx.fw.1', 'UpTime', 6, 'None', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 42.35 (462 s)', '2008-07-03 21:03:17', '2', 8, NULL, NULL);
|
| 391 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7213, 'bst.fw.1', 'UpTime', 7, 'Acknowledged', true, '2008-07-01 13:59:56', 'WARNING: sysUpTime is 7 minutes, 43.61 (463 s)', '2008-07-03 21:03:19', NULL, 8, NULL, NULL);
|
| 392 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7215, 'testsolaris', 'Collector', 7, 'AAClosed', true, '2008-07-01 14:38:22', 'WARNING2: SNMP error: No response from remote host 172.17.103.139', '2008-07-01 14:38:22', NULL, 1, NULL, NULL);
|
| 393 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7216, 'bdx.fw.1', 'Synchro NTP', 7, 'Acknowledged', true, '2008-07-01 18:19:28', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', '4', 2, NULL, NULL);
|
| 394 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7217, 'ajc.sw.1', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:28', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', NULL, 2, NULL, NULL);
|
| 395 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7218, 'bdx.linux1', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:28', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', NULL, 2, NULL, NULL);
|
| 396 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7219, 'par.fw.1', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:34', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', NULL, 2, NULL, NULL);
|
| 397 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7220, 'server.mails', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:34', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-08 13:28:46', NULL, 4, NULL, NULL);
|
| 398 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7221, 'par.unix0', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:34', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', NULL, 2, NULL, NULL);
|
| 399 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7222, 'ajc.linux1', 'Synchro NTP', 5, 'None', true, '2008-07-01 18:19:37', 'CHECK_NRPE: Socket timeout after 10 seconds.', '2008-07-03 20:51:26', NULL, 2, NULL, NULL);
|
| 400 |
|
INSERT INTO events (idevent, hostname, servicename, severity, status, active, "timestamp", output, timestamp_active, trouble_ticket, occurence, impact, rawstate) VALUES (7214, 'testsolaris', 'UpTime', 7, 'None', true, '2008-07-01 14:04:13', 'WARNING: sysUpTime is 6 minutes, 58.81 (418 s)', '2008-07-03 21:00:06', '1', 4, NULL, NULL);
|
| 401 |
|
--
|
| 402 |
|
-- Data for Name: event_history; Type: TABLE DATA; Schema: public; Owner: vigiboard
|
| 403 |
|
--
|
| 404 |
|
|
| 405 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (322800, 'Ticket change', 7214, '', '', '2009-07-09 09:29:23.449422', 'manager');
|
| 406 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (322801, 'Ticket change', 7214, '', '', '2009-07-09 14:28:35.759311', 'manager');
|
| 407 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (1, 'Nagios update state', 7087, '6', 'PROBLEM WARNING: Fake sine Value: 5452', '2008-06-19 09:56:30', NULL);
|
| 408 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (2, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 09:56:30', 'nagios_system');
|
| 409 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (3, 'Nagios update state', 7086, '6', 'PROBLEM WARNING: Fake sine Value: 5452', '2008-06-19 09:56:30', NULL);
|
| 410 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (4, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 09:56:30', 'nagios_system');
|
| 411 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (5, 'Nagios update state', 7086, '7', 'PROBLEM CRITICAL: Fake sine Value: 5481', '2008-06-19 09:59:46', NULL);
|
| 412 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (6, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 09:59:46', 'nagios_system');
|
| 413 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (7, 'Nagios update state', 7087, '7', 'PROBLEM CRITICAL: Fake sine Value: 5481', '2008-06-19 09:59:46', NULL);
|
| 414 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (8, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 09:59:46', 'nagios_system');
|
| 415 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (9, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 10:00:15', NULL);
|
| 416 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (10, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:00:15', 'nagios_system');
|
| 417 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (11, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 10:00:17', NULL);
|
| 418 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (12, 'Nagios update state', 7101, '6', 'PROBLEM CRITICAL: Ecritures a 15ko/s', '2008-06-19 10:05:07', NULL);
|
| 419 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (13, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 11.44', '2008-06-19 10:05:15', NULL);
|
| 420 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (14, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:05:15', 'nagios_system');
|
| 421 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (15, 'Nagios update state', 7087, '6', 'PROBLEM WARNING: Fake sine Value: 5474', '2008-06-19 10:05:30', NULL);
|
| 422 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (16, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:05:30', 'nagios_system');
|
| 423 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (17, 'Nagios update state', 7086, '6', 'PROBLEM WARNING: Fake sine Value: 5474', '2008-06-19 10:05:30', NULL);
|
| 424 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (18, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:05:30', 'nagios_system');
|
| 425 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (19, 'Nagios update state', 7101, '7', 'PROBLEM CRITICAL: Ecritures a 15ko/s', '2008-06-19 10:05:45', NULL);
|
| 426 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (20, 'Acknowlegement change state', 7101, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:05:45', 'nagios_system');
|
| 427 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (21, 'Nagios update state', 7097, '6', 'PROBLEM WARNING: Charge: 8.52', '2008-06-19 10:07:15', NULL);
|
| 428 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (22, 'Acknowlegement change state', 7097, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:07:15', 'nagios_system');
|
| 429 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (23, 'Nagios update state', 7096, '6', 'PROBLEM WARNING: Charge: 14.33', '2008-06-19 10:07:15', NULL);
|
| 430 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (24, 'Acknowlegement change state', 7096, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:07:15', 'nagios_system');
|
| 431 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (25, 'Nagios update state', 7086, '0', 'RECOVERY OK: Fake sine Value: 5440', '2008-06-19 10:07:30', NULL);
|
| 432 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (26, 'Nagios update state', 7087, '0', 'RECOVERY OK: Fake sine Value: 5440', '2008-06-19 10:07:30', NULL);
|
| 433 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (27, 'Nagios update state', 7079, '6', 'Volatile WARNING: 931 processus en cours', '2008-06-19 10:08:15', NULL);
|
| 434 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (28, 'Nagios update state', 7083, '6', 'Volatile WARNING: Charge : 16.00', '2008-06-19 10:08:15', NULL);
|
| 435 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (29, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 7.85', '2008-06-19 10:09:15', NULL);
|
| 436 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (30, 'Nagios update state', 7097, '0', 'RECOVERY OK: Charge: 7.84', '2008-06-19 10:10:15', NULL);
|
| 437 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (31, 'Nagios update state', 7096, '0', 'RECOVERY OK: Charge: 8.97', '2008-06-19 10:11:15', NULL);
|
| 438 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (32, 'Nagios update state', 7093, '6', 'PROBLEM WARNING: Fake sine Value: 994', '2008-06-19 10:18:03', NULL);
|
| 439 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (33, 'Acknowlegement change state', 7093, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:18:03', 'nagios_system');
|
| 440 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (34, 'Nagios update state', 7088, '6', 'PROBLEM WARNING: Fake sine Value: 988', '2008-06-19 10:18:09', NULL);
|
| 441 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (35, 'Acknowlegement change state', 7088, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:18:09', 'nagios_system');
|
| 442 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (36, 'Nagios update state', 7091, '6', 'PROBLEM WARNING: Fake sine Value: 968', '2008-06-19 10:18:33', NULL);
|
| 443 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (37, 'Acknowlegement change state', 7091, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:18:33', 'nagios_system');
|
| 444 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (38, 'Nagios update state', 7092, '6', 'PROBLEM WARNING: Fake sine Value: 964', '2008-06-19 10:18:36', NULL);
|
| 445 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (39, 'Acknowlegement change state', 7092, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:18:36', 'nagios_system');
|
| 446 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (40, 'Nagios update state', 7089, '6', 'PROBLEM WARNING: Fake sine Value: 951', '2008-06-19 10:18:51', NULL);
|
| 447 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (41, 'Acknowlegement change state', 7089, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:18:51', 'nagios_system');
|
| 448 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (42, 'Nagios update state', 7088, '7', 'PROBLEM CRITICAL: Fake sine Value: 745', '2008-06-19 10:24:25', NULL);
|
| 449 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (43, 'Acknowlegement change state', 7088, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:24:25', 'nagios_system');
|
| 450 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (44, 'Nagios update state', 7089, '7', 'PROBLEM CRITICAL: Fake sine Value: 719', '2008-06-19 10:25:07', NULL);
|
| 451 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (45, 'Acknowlegement change state', 7089, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:25:07', 'nagios_system');
|
| 452 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (46, 'Nagios update state', 7091, '7', 'PROBLEM CRITICAL: Fake sine Value: 599', '2008-06-19 10:28:49', NULL);
|
| 453 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (47, 'Acknowlegement change state', 7091, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:28:49', 'nagios_system');
|
| 454 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (48, 'Nagios update state', 7092, '7', 'PROBLEM CRITICAL: Fake sine Value: 597', '2008-06-19 10:28:52', NULL);
|
| 455 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (49, 'Acknowlegement change state', 7092, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:28:52', 'nagios_system');
|
| 456 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (50, 'Nagios update state', 7093, '7', 'PROBLEM CRITICAL: Fake sine Value: 586', '2008-06-19 10:29:19', NULL);
|
| 457 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (51, 'Acknowlegement change state', 7093, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:29:19', 'nagios_system');
|
| 458 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (52, 'Nagios update state', 7096, '6', 'PROBLEM WARNING: Charge: 11.88', '2008-06-19 10:31:15', NULL);
|
| 459 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (53, 'Acknowlegement change state', 7096, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:31:15', 'nagios_system');
|
| 460 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (54, 'Nagios update state', 7097, '6', 'PROBLEM WARNING: Charge: 9.60', '2008-06-19 10:32:18', NULL);
|
| 461 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (55, 'Acknowlegement change state', 7097, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:32:18', 'nagios_system');
|
| 462 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (56, 'Nagios update state', 7079, '7', 'PROBLEM CRITICAL: 1313 processus en cours', '2008-06-19 10:32:31', NULL);
|
| 463 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (57, 'Acknowlegement change state', 7079, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:32:31', 'nagios_system');
|
| 464 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (58, 'Nagios update state', 7083, '7', 'PROBLEM CRITICAL: Charge : 29.56', '2008-06-19 10:32:31', NULL);
|
| 465 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (59, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:32:31', 'nagios_system');
|
| 466 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (60, 'Nagios update state', 7079, '6', 'PROBLEM WARNING: 1000 processus en cours', '2008-06-19 10:34:15', NULL);
|
| 467 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (61, 'Acknowlegement change state', 7079, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:34:15', 'nagios_system');
|
| 468 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (62, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 12.41', '2008-06-19 10:34:15', NULL);
|
| 469 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (63, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:34:15', 'nagios_system');
|
| 470 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (64, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 6.89', '2008-06-19 10:35:15', NULL);
|
| 471 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (65, 'Acknowlegement change state', 7101, '2', '', '2008-06-19 10:36:44', '');
|
| 472 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (66, 'Ticket change', 7101, '35', '', '2008-06-19 10:36:44', '');
|
| 473 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (67, 'Nagios update state', 7096, '0', 'RECOVERY OK: Charge: 8.48', '2008-06-19 10:40:15', NULL);
|
| 474 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (68, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 10:42:15', NULL);
|
| 475 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (69, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:42:15', 'nagios_system');
|
| 476 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (70, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 10:42:17', NULL);
|
| 477 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (71, 'Nagios update state', 7092, '6', 'PROBLEM WARNING: Fake sine Value: 601', '2008-06-19 10:42:36', NULL);
|
| 478 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (72, 'Acknowlegement change state', 7092, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:42:36', 'nagios_system');
|
| 479 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (73, 'Nagios update state', 7093, '6', 'PROBLEM WARNING: Fake sine Value: 613', '2008-06-19 10:43:03', NULL);
|
| 480 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (74, 'Acknowlegement change state', 7093, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:43:03', 'nagios_system');
|
| 481 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (75, 'Nagios update state', 7091, '6', 'PROBLEM WARNING: Fake sine Value: 627', '2008-06-19 10:43:33', NULL);
|
| 482 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (76, 'Acknowlegement change state', 7091, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:43:33', 'nagios_system');
|
| 483 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (77, 'Nagios update state', 7102, '7', 'PROBLEM CRITICAL: CPU : 92%', '2008-06-19 10:45:06', NULL);
|
| 484 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (78, 'Nagios update state', 7102, '0', 'RECOVERY FLAPPING OK: CPU : 1% ', '2008-06-19 10:45:08', NULL);
|
| 485 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (79, 'Nagios update state', 7088, '6', 'PROBLEM WARNING: Fake sine Value: 757', '2008-06-19 10:47:09', NULL);
|
| 486 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (80, 'Acknowlegement change state', 7088, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:47:09', 'nagios_system');
|
| 487 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (81, 'Nagios update state', 7089, '6', 'PROBLEM WARNING: Fake sine Value: 785', '2008-06-19 10:47:51', NULL);
|
| 488 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (82, 'Acknowlegement change state', 7089, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:47:51', 'nagios_system');
|
| 489 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (83, 'Nagios update state', 7097, '0', 'RECOVERY OK: Charge: 7.98', '2008-06-19 10:49:15', NULL);
|
| 490 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (84, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 10:49:15', NULL);
|
| 491 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (85, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:49:15', 'nagios_system');
|
| 492 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (86, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 2 instances de pop3d trouvees ', '2008-06-19 10:49:17', NULL);
|
| 493 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (87, 'Nagios update state', 7088, '0', 'RECOVERY OK: Fake sine Value: 1003', '2008-06-19 10:52:09', NULL);
|
| 494 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (88, 'Nagios update state', 7091, '0', 'RECOVERY OK: Fake sine Value: 1024', '2008-06-19 10:52:33', NULL);
|
| 495 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (89, 'Nagios update state', 7092, '0', 'RECOVERY OK: Fake sine Value: 1028', '2008-06-19 10:52:36', NULL);
|
| 496 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (90, 'Nagios update state', 7089, '0', 'RECOVERY OK: Fake sine Value: 1042', '2008-06-19 10:52:51', NULL);
|
| 497 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (91, 'Nagios update state', 7093, '0', 'RECOVERY OK: Fake sine Value: 1055', '2008-06-19 10:53:03', NULL);
|
| 498 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (92, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 10:55:15', NULL);
|
| 499 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (93, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:55:15', 'nagios_system');
|
| 500 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (94, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 10:55:17', NULL);
|
| 501 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (95, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 10:58:15', NULL);
|
| 502 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (96, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 10:58:15', 'nagios_system');
|
| 503 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (97, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 10:58:17', NULL);
|
| 504 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (98, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:00:15', NULL);
|
| 505 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (99, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:00:15', 'nagios_system');
|
| 506 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (100, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 11:00:17', NULL);
|
| 507 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (101, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:06:15', NULL);
|
| 508 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (102, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:06:15', 'nagios_system');
|
| 509 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (103, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 6 instances de pop3d trouvees ', '2008-06-19 11:06:17', NULL);
|
| 510 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (104, 'Nagios update state', 7094, '0', 'RECOVERY OK: Usage: 0.09 MB (0.95%)', '2008-06-19 11:14:51', NULL);
|
| 511 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (105, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:18:31', NULL);
|
| 512 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (106, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:18:31', 'nagios_system');
|
| 513 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (107, 'Nagios update state', 7084, '0', 'RECOVERY OK: 1 instances de pop3d trouvees', '2008-06-19 11:19:15', NULL);
|
| 514 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (108, 'Nagios update state', 7087, '6', 'PROBLEM WARNING: Fake sine Value: 536', '2008-06-19 11:20:30', NULL);
|
| 515 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (109, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:20:30', 'nagios_system');
|
| 516 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (110, 'Nagios update state', 7086, '6', 'PROBLEM WARNING: Fake sine Value: 536', '2008-06-19 11:20:30', NULL);
|
| 517 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (111, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:20:30', 'nagios_system');
|
| 518 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (112, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:22:15', NULL);
|
| 519 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (113, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:22:15', 'nagios_system');
|
| 520 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (114, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 3 instances de pop3d trouvees ', '2008-06-19 11:22:17', NULL);
|
| 521 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (115, 'Nagios update state', 7086, '7', 'PROBLEM CRITICAL: Fake sine Value: 511', '2008-06-19 11:23:46', NULL);
|
| 522 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (116, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:23:46', 'nagios_system');
|
| 523 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (117, 'Nagios update state', 7087, '7', 'PROBLEM CRITICAL: Fake sine Value: 511', '2008-06-19 11:23:46', NULL);
|
| 524 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (118, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:23:46', 'nagios_system');
|
| 525 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (119, 'Nagios update state', 7096, '6', 'PROBLEM WARNING: Charge: 11.12', '2008-06-19 11:26:15', NULL);
|
| 526 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (120, 'Acknowlegement change state', 7096, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:26:15', 'nagios_system');
|
| 527 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (121, 'Nagios update state', 7098, '6', 'PROBLEM WARNING: 1008 connexions TCP etablies', '2008-06-19 11:27:15', NULL);
|
| 528 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (122, 'Acknowlegement change state', 7098, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:27:15', 'nagios_system');
|
| 529 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (123, 'Nagios update state', 7097, '6', 'PROBLEM WARNING: Charge: 9.24', '2008-06-19 11:27:15', NULL);
|
| 530 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (124, 'Acknowlegement change state', 7097, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:27:15', 'nagios_system');
|
| 531 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (125, 'Nagios update state', 7083, '7', 'PROBLEM CRITICAL: Charge : 22.83', '2008-06-19 11:27:31', NULL);
|
| 532 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (126, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:27:31', 'nagios_system');
|
| 533 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (127, 'Nagios update state', 7098, '0', 'RECOVERY OK: 927 connexions TCP etablies', '2008-06-19 11:28:15', NULL);
|
| 534 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (128, 'Nagios update state', 7079, '6', 'Volatile WARNING: 962 processus en cours', '2008-06-19 11:28:15', NULL);
|
| 535 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (129, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 15.07', '2008-06-19 11:28:15', NULL);
|
| 536 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (130, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:28:15', 'nagios_system');
|
| 537 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (131, 'Nagios update state', 7087, '6', 'PROBLEM WARNING: Fake sine Value: 521', '2008-06-19 11:28:30', NULL);
|
| 538 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (132, 'Acknowlegement change state', 7087, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:28:30', 'nagios_system');
|
| 539 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (133, 'Nagios update state', 7086, '6', 'PROBLEM WARNING: Fake sine Value: 521', '2008-06-19 11:28:30', NULL);
|
| 540 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (134, 'Acknowlegement change state', 7086, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:28:30', 'nagios_system');
|
| 541 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (135, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 6.32', '2008-06-19 11:30:15', NULL);
|
| 542 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (136, 'Nagios update state', 7087, '0', 'RECOVERY OK: Fake sine Value: 552', '2008-06-19 11:30:30', NULL);
|
| 543 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (137, 'Nagios update state', 7086, '0', 'RECOVERY OK: Fake sine Value: 552', '2008-06-19 11:30:30', NULL);
|
| 544 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (138, 'Nagios update state', 7096, '0', 'RECOVERY OK: Charge: 8.97', '2008-06-19 11:33:15', NULL);
|
| 545 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (139, 'Nagios update state', 7089, '6', 'PROBLEM WARNING: Fake sine Value: 4504', '2008-06-19 11:33:51', NULL);
|
| 546 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (140, 'Acknowlegement change state', 7089, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:33:51', 'nagios_system');
|
| 547 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (141, 'Nagios update state', 7088, '6', 'PROBLEM WARNING: Fake sine Value: 4530', '2008-06-19 11:34:09', NULL);
|
| 548 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (142, 'Acknowlegement change state', 7088, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:34:09', 'nagios_system');
|
| 549 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (143, 'Nagios update state', 7097, '0', 'RECOVERY OK: Charge: 8.00', '2008-06-19 11:35:15', NULL);
|
| 550 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (144, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:35:15', NULL);
|
| 551 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (145, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:35:15', 'nagios_system');
|
| 552 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (146, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 1 instances de pop3d trouvees ', '2008-06-19 11:35:17', NULL);
|
| 553 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (147, 'Nagios update state', 7084, '7', 'PROBLEM CRITICAL: 0 instances de pop3d trouvees', '2008-06-19 11:37:15', NULL);
|
| 554 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (148, 'Acknowlegement change state', 7084, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:37:15', 'nagios_system');
|
| 555 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (149, 'Nagios update state', 7084, '0', 'RECOVERY FLAPPING OK: 6 instances de pop3d trouvees ', '2008-06-19 11:37:17', NULL);
|
| 556 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (150, 'Nagios update state', 7089, '7', 'PROBLEM CRITICAL: Fake sine Value: 4787', '2008-06-19 11:39:07', NULL);
|
| 557 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (151, 'Acknowlegement change state', 7089, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:39:07', 'nagios_system');
|
| 558 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (152, 'Nagios update state', 7088, '7', 'PROBLEM CRITICAL: Fake sine Value: 4809', '2008-06-19 11:39:25', NULL);
|
| 559 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (153, 'Acknowlegement change state', 7088, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:39:25', 'nagios_system');
|
| 560 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (154, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 13.22', '2008-06-19 11:41:15', NULL);
|
| 561 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (155, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:41:15', 'nagios_system');
|
| 562 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (156, 'Nagios update state', 7091, '6', 'PROBLEM WARNING: Fake sine Value: 5013', '2008-06-19 11:41:33', NULL);
|
| 563 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (157, 'Acknowlegement change state', 7091, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:41:33', 'nagios_system');
|
| 564 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (158, 'Nagios update state', 7092, '6', 'PROBLEM WARNING: Fake sine Value: 5017', '2008-06-19 11:41:36', NULL);
|
| 565 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (159, 'Acknowlegement change state', 7092, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:41:36', 'nagios_system');
|
| 566 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (160, 'Nagios update state', 7093, '6', 'PROBLEM WARNING: Fake sine Value: 5041', '2008-06-19 11:42:03', NULL);
|
| 567 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (161, 'Acknowlegement change state', 7093, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:42:03', 'nagios_system');
|
| 568 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (162, 'Nagios update state', 7097, '6', 'PROBLEM WARNING: Charge: 8.59', '2008-06-19 11:42:15', NULL);
|
| 569 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (163, 'Acknowlegement change state', 7097, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:42:15', 'nagios_system');
|
| 570 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (164, 'Nagios update state', 7079, '6', 'Volatile WARNING: 990 processus en cours', '2008-06-19 11:42:15', NULL);
|
| 571 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (165, 'Nagios update state', 7096, '6', 'PROBLEM WARNING: Charge: 10.13', '2008-06-19 11:42:15', NULL);
|
| 572 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (166, 'Acknowlegement change state', 7096, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:42:15', 'nagios_system');
|
| 573 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (167, 'Nagios update state', 7096, '0', 'RECOVERY OK: Charge: 8.99', '2008-06-19 11:43:15', NULL);
|
| 574 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (168, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 7.84', '2008-06-19 11:43:15', NULL);
|
| 575 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (169, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 12.83', '2008-06-19 11:44:15', NULL);
|
| 576 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (170, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:44:15', 'nagios_system');
|
| 577 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (171, 'Nagios update state', 7096, '6', 'PROBLEM WARNING: Charge: 10.57', '2008-06-19 11:44:15', NULL);
|
| 578 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (172, 'Acknowlegement change state', 7096, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:44:15', 'nagios_system');
|
| 579 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (173, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 7.53', '2008-06-19 11:45:15', NULL);
|
| 580 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (174, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 10.07', '2008-06-19 11:46:18', NULL);
|
| 581 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (175, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:46:18', 'nagios_system');
|
| 582 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (176, 'Nagios update state', 7096, '0', 'RECOVERY OK: Charge: 8.98', '2008-06-19 11:47:15', NULL);
|
| 583 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (177, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 7.35', '2008-06-19 11:47:15', NULL);
|
| 584 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (178, 'Nagios update state', 7097, '0', 'RECOVERY OK: Charge: 7.98', '2008-06-19 11:50:15', NULL);
|
| 585 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (179, 'Nagios update state', 7094, '6', 'PROBLEM WARNING: Usage: 8.13 MB (86.02%)', '2008-06-19 11:50:51', NULL);
|
| 586 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (180, 'Acknowlegement change state', 7094, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:50:51', 'nagios_system');
|
| 587 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (181, 'Nagios update state', 7093, '7', 'PROBLEM CRITICAL: Fake sine Value: 5405', '2008-06-19 11:52:19', NULL);
|
| 588 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (182, 'Acknowlegement change state', 7093, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:52:19', 'nagios_system');
|
| 589 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (183, 'Nagios update state', 7091, '7', 'PROBLEM CRITICAL: Fake sine Value: 5417', '2008-06-19 11:52:49', NULL);
|
| 590 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (184, 'Acknowlegement change state', 7091, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:52:49', 'nagios_system');
|
| 591 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (185, 'Nagios update state', 7092, '7', 'PROBLEM CRITICAL: Fake sine Value: 5419', '2008-06-19 11:52:52', NULL);
|
| 592 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (186, 'Acknowlegement change state', 7092, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:52:52', 'nagios_system');
|
| 593 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (187, 'Nagios update state', 7097, '6', 'PROBLEM WARNING: Charge: 8.26', '2008-06-19 11:54:15', NULL);
|
| 594 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (188, 'Acknowlegement change state', 7097, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:54:15', 'nagios_system');
|
| 595 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (189, 'Nagios update state', 7083, '6', 'PROBLEM WARNING: Charge : 11.66', '2008-06-19 11:54:15', NULL);
|
| 596 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (190, 'Acknowlegement change state', 7083, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:54:15', 'nagios_system');
|
| 597 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (191, 'Nagios update state', 7083, '0', 'RECOVERY OK: Charge : 9.32', '2008-06-19 11:55:15', NULL);
|
| 598 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (192, 'Nagios update state', 7094, '7', 'PROBLEM CRITICAL: Usage: 9.13 MB (96.65%)', '2008-06-19 11:57:07', NULL);
|
| 599 |
|
INSERT INTO event_history (idhistory, type_action, idevent, value, text, "timestamp", username) VALUES (193, 'Acknowlegement change state', 7094, '1', 'System forced treatment to None.<BR>Reason: Event was reactivated due to new outage.', '2008-06-19 11:57:07', 'nagios_system');
|
