Query for IP and exclude multiple address strings

Usage and Config
1

How to I accomplish this:

(it as string) of addresses whose(it as string does not start with ("127.0";"10.1.1";"192.") ) of ip interfaces of network
2

You can do something like:

addresses whose ((item 0 of it as string does not start with item 1 of it) of (it, ("127.0";"10.1.1";"192."))) of ip interfaces of network
1 Like
3

Here is another option:

(it as string) whose(it does not start with "127.0" AND it does not start with "10.1.1" AND it does not start with "192." ) of addresses of ip interfaces of network

Related: https://bigfix.me/relevance/details/3000004

addresses whose(it as string does not start with "172." AND it as string does not start with "10." AND it as string does not start with "192.168." AND it as string does not start with "169.254." AND it as string does not start with "127." AND it as string does not start with "0.") of adapters of network
4

know how to get just the first result? something like:

fist address whose(.....
5

This basic method works for most things:

(tuple string item 0 of it | it) of concatenations ", " of (it as string) of addresses whose( ...

This option will give the first one alphabetized:

(tuple string item 0 of it | it) of concatenations ", " of unique values of (it as string) of addresses whose( ...