microsoft365 · SQL

SQL inserts to load microsoft365 CIDRs into a database table. 93 CIDRs, refreshed daily.
// microsoft365_ips.sql

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

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

INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.6.152/31', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.6.171/32', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.6.192/32', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.9.192/32', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.18.10/31', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.18.15/32', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.128.0/22', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.136.0/22', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('13.107.140.6/32', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('20.20.32.0/19', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('20.190.128.0/18', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('20.231.128.0/19', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('23.103.160.0/20', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('40.92.0.0/15', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('40.96.0.0/13', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('40.104.0.0/15', 'IPv4');
INSERT INTO `microsoft365_ips` (`ip_address`, `ip_type`) VALUES ('40.107.0.0/16', 'IPv4');
… (76 more lines)