// AZURE / SQL
Azure · SQL

SQL inserts to load Azure CIDRs into a database table. 103,021 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.145.74.52/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.149.254.68/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.150.239.212/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.151.103.92/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.171.31.152/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.190.136.180/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.200.251.84/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.202.253.100/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.206.229.96/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.207.242.64/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.216.204.200/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.218.236.160/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.219.249.220/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.220.138.104/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.232.48.104/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.232.106.88/30', 'IPv4');
INSERT INTO `azure_ips` (`ip_address`, `ip_type`) VALUES ('4.240.148.92/30', 'IPv4');
… (103004 more lines)