ifservices.sql

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

INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (14,'192.168.0.189',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (14,'192.168.0.189',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (14,'192.168.0.189',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (15,'192.168.0.191',NULL,6,NULL,NULL,'3306            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (15,'192.168.0.191',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (16,'192.168.0.193',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (17,'192.168.0.194',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (17,'192.168.0.194',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (18,'192.168.0.195',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (18,'192.168.0.195',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (18,'192.168.0.195',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,7,NULL,NULL,'53              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (19,'192.168.0.196',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (20,'192.168.0.198',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (20,'192.168.0.198',NULL,7,NULL,NULL,'53              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (20,'192.168.0.198',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (20,'192.168.0.198',NULL,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (20,'192.168.0.198',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (21,'192.168.0.197',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (21,'192.168.0.197',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (21,'192.168.0.197',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (22,'192.168.0.204',16777219,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (22,'192.168.0.204',16777219,19,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (23,'192.168.0.208',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (24,'192.168.0.221',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (25,'192.168.0.229',NULL,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (25,'192.168.0.229',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (25,'192.168.0.229',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (26,'192.168.0.227',NULL,3,NULL,NULL,'8080            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (26,'192.168.0.227',NULL,5,NULL,NULL,'5432            ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (26,'192.168.0.227',NULL,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (26,'192.168.0.227',NULL,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (27,'192.168.0.244',2,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (27,'192.168.0.244',2,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (27,'192.168.0.244',2,9,NULL,NULL,'22              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (27,'192.168.0.244',2,19,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (28,'192.168.0.246',16777219,1,NULL,NULL,'161             ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (28,'192.168.0.246',16777219,3,NULL,NULL,'80              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (28,'192.168.0.246',16777219,11,NULL,NULL,'21              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (28,'192.168.0.246',16777219,15,NULL,NULL,'25              ','A',NULL,NULL);
INSERT INTO "ifservices" ("nodeid","ipaddr","ifindex","serviceid","lastgood","lastfail","qualifier","status","source","notify") VALUES (28,'192.168.0.246',16777219,19,NULL,NULL,'161             ','A',NULL,NULL);