// PINGDOM / SQL
pingdom · SQL

SQL inserts to load pingdom CIDRs into a database table. 206 CIDRs, refreshed daily.
// pingdom_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `pingdom_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `pingdom_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.10.222.182/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.11.131.95/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.66.99.59/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.120.200.34/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.121.108.101/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.125.198.20/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.127.78.190/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.219.128.11/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('3.234.196.132/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.41.140.26/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.41.156.80/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.48.152.99/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.49.128.195/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.232.220.164/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.238.73.96/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('13.238.127.47/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('15.157.158.165/32', 'IPv4');
… (189 more lines)