Groups based in IP addresses

Im trying to create groups based on IP addresses.
I’ve tried %devices.ip ~ “10.12.2.@” || and %devices.ip ~ “10.9%” ||
Nothing hits.
Is my wildcard wrong? What is the wildcard?

You can’t use devices.ip as it’s a binary field. You’d need to use ipv4_addresses.ipv4_address


%ipv4_addresses.ipv4_address ~ “10.12.2.@” solved it

It’s also worth mentioning to realise that that IP could be on multiple devices.

Trying to do the ipv4_addresses.ipv4_address as the search and it’s not autofilling when I start typing it in as a pattern. Is it not there anymore?

Yup, 100% there:select ipv4_addresses.ipv4_address from ipv4_addresses;

This is what I see when I try to use it to create the group:


You have to type it all the way out like this ipv4_addresses.

Hi, I created a group based on IP address
the pattern I used is:
%ipv4_addresses_ipv4_address like "172.16.1.@"
but it’s not filling the group correctly its filling the group with all IP like 172.16.X.X and I need only IP’s like 172.16.1.X


can you post a screenshot of what the group looks like?

That’s not gonna work

it’s basically saying that Ip address has to match both with the && connection.

You need to use the OR || Connection.

Thank you for your time and answer me
well if I take off the second statement them the rule list all my devices on 172.16.X.X and I want to list devices on 172.16.1.X or 172.16.2.X or 172.16.3.X but not 172.16.0.X



To make it easy I want to list devices on 172.16.1-9.X but not 172.16.0.X

you link do not explain very well how groups work, sorry

You need to read the part about SQL connections.

But try this

unfortunately, your rule still listing all my devices on 172.16.X.X

try this maybe? image