How to Find Azure Resources with Public IP Addresses

The query is ugly, but I think it works. It matches IPv4 without RFC1918 private addresses. To be precise, it matches more than just IPv4 (.e.g. 0.999.999.999), but I think it should do the trick here.

resources
| where properties matches regex @'\b[0-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b1[1-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b[2-9][0-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b1[0-6][0-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b171\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b172\.3[3-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b172\.[4-9][0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b17[3-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b18[0-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b19[0-1]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.[0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.[1-9][0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.1[0-5][0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.16[0-7]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.169\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.1[7-9][0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b192\.2[0-5][0-9]\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b19[3-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b' or
properties matches regex @'\b2[0-5][0-9]\.\d{1,3}\.\d{1,3}\.\d{1,3}\b'
|project  name, type, location, resourceGroup, subscriptionId, properties