// PINGDOM / SQL
pingdom · SQL

SQL inserts to load pingdom CIDRs into a database table. 156 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 ('13.232.220.164/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.22.2.46/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.83.129.219/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.92.127.2/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.106.37.99/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.111.152.74/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('23.111.159.174/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('43.225.198.122/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('43.229.84.12/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('46.20.45.18/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('46.246.122.10/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('50.16.153.186/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('52.0.204.16/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('52.24.42.103/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('52.48.244.35/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('52.52.34.158/32', 'IPv4');
INSERT INTO `pingdom_ips` (`ip_address`, `ip_type`) VALUES ('52.52.95.213/32', 'IPv4');
… (139 more lines)