ipv4_is_in_any_range()

Learn how to use the ipv4_is_in_any_range() function to check if the IPv4 string address is in any of the IPv4 address ranges.

Checks whether IPv4 string address is in any of the specified IPv4 address ranges.

Performance tips

Syntax

ipv4_is_in_any_range(Ipv4Address , Ipv4Range [ , Ipv4Range …] )

ipv4_is_in_any_range(Ipv4Address , Ipv4Ranges )

Parameters

NameTypeRequiredDescription
Ipv4Addressstring✔️An expression representing an IPv4 address.
Ipv4Rangestring✔️An IPv4 range or list of IPv4 ranges written with IP-prefix notation.
Ipv4Rangesdynamic✔️A dynamic array containing IPv4 ranges written with IP-prefix notation.

Returns

  • true: If the IPv4 address is in the range of any of the specified IPv4 networks.
  • false: Otherwise.
  • null: If conversion for one of the two IPv4 strings wasn’t successful.

Examples

Syntax using list of strings

print Result=ipv4_is_in_any_range('192.168.1.6', '192.168.1.1/24', '10.0.0.1/8', '127.1.0.1/16')

Output

Result
true

Syntax using dynamic array

print Result=ipv4_is_in_any_range("127.0.0.1", dynamic(["127.0.0.1", "192.168.1.1"]))

Output

Result
true

Extend table with IPv4 range check

let LocalNetworks=dynamic([
    "192.168.1.1/16",
    "127.0.0.1/8",
    "10.0.0.1/8"
]);
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)

Output

IPIsLocal
10.1.2.3true
192.168.1.5true
123.1.11.21false
1.1.1.1false

Related content