// ZSCALER / SQL
zscaler · SQL

SQL inserts to load zscaler CIDRs into a database table. 946 CIDRs, refreshed daily.
// zscaler_ips.sql

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

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

INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('8.25.203.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('8.34.34.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('8.35.35.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('64.62.169.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('64.215.22.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('70.39.159.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('70.40.176.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('70.40.177.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('70.40.178.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('87.58.64.0/18', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('89.18.89.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.192.0/18', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.192.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.193.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.194.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.195.0/24', 'IPv4');
INSERT INTO `zscaler_ips` (`ip_address`, `ip_type`) VALUES ('101.2.196.0/24', 'IPv4');
… (929 more lines)