ifservices.sql

来自「opennms得相关源码 请大家看看」· SQL 代码 · 共 93 行 · 第 1/2 页

INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (1,'192.168.0.1',NULL,3,NULL,NULL,'8080            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (1,'192.168.0.1',NULL,7,NULL,NULL,'53              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (1,'192.168.0.1',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (2,'192.168.0.4',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (2,'192.168.0.4',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (2,'192.168.0.4',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (2,'192.168.0.4',NULL,16,NULL,NULL,'143             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (3,'192.168.0.5',92,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (3,'192.168.0.5',92,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (3,'192.168.0.5',92,19,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (4,'192.168.0.31',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (5,'192.168.0.32',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (5,'192.168.0.32',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (5,'192.168.0.32',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (5,'192.168.0.32',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (6,'192.168.0.33',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (6,'192.168.0.33',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (6,'192.168.0.33',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (6,'192.168.0.33',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (7,'192.168.0.35',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (7,'192.168.0.35',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (8,'192.168.0.36',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (8,'192.168.0.36',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (8,'192.168.0.36',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (8,'192.168.0.36',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (9,'192.168.0.37',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (9,'192.168.0.37',NULL,6,NULL,NULL,'3306            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (9,'192.168.0.37',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (9,'192.168.0.37',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (9,'192.168.0.37',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (10,'192.168.0.38',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (10,'192.168.0.38',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (10,'192.168.0.38',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (10,'192.168.0.38',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (11,'192.168.0.40',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (11,'192.168.0.40',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.41',2,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.41',2,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.41',2,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.41',2,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.42',3,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.42',3,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.42',3,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (12,'192.168.0.42',3,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (13,'192.168.0.188',NULL,3,NULL,NULL,'80              ','A',NULL,'N');
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (13,'192.168.0.188',NULL,9,NULL,NULL,'22              ','A',NULL,'N');
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (13,'192.168.0.188',NULL,15,NULL,NULL,'25              ','A',NULL,'N');