// AZURE / SQL
Azure · SQL

SQL inserts to load Azure CIDRs into a database table. 106,887 CIDRs, refreshed daily.
// azure_ips.sql

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

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

INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.0.0/17', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.0.0/17', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.9.0/26', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.9.0/26', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.9.64/27', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.9.64/27', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.32/27', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.32/27', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.32/27', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.64/26', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.64/26', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.10.64/26', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.15.72/29', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.15.72/29', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.32.35/32', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.32.35/32', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.144.32.35/32', 'IPv4');
… (106870 more lines)