Skip to content

Instantly share code, notes, and snippets.

@hfleitas
Created January 19, 2024 17:05
Show Gist options
  • Save hfleitas/44793703c800dec382f86379ee72170c to your computer and use it in GitHub Desktop.
Save hfleitas/44793703c800dec382f86379ee72170c to your computer and use it in GitHub Desktop.
IPv4-Any.kql
#connect cluster('help').database('Samples')
let LocalNetworks=dynamic([
"0.0.0.0/0"
]);
let IPs=datatable(IP:string) [
"10.1.2.3",
"192.168.1.5",
"123.1.11.21",
"1.1.1.1"
];
IPs
| extend IsLocal=ipv4_is_in_any_range(IP, LocalNetworks)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment