Finding Missing IP address thru a Query

  • Thread starter Thread starter Costa, Frank
  • Start date Start date
C

Costa, Frank

Hello,

I have a database with IP of multiple devices. I would like to run a query
to find any missing/free IP's on that range.

Ex:

192.168.0.1
192.168.0.3
192.168.0.4
192.168.0.6
192.168.0.9

The query would then report

192.168.0.2
192.168.0.5
192.168.0.7
192.168.0.8
as being missed/free.

Any help would be appreciated.

Thanks
Frank
 
You could create a table of available IP addresses and
write a query that fins a null relationship to your
devices table.

i.e. In the query, match up by the IP address fields in
the two tables. Select "show all from the IP table" as
your relationship and add the IP address from the Devices
table with a restriction of "is null".

Long way around it, I'm sure. But I think it will work for
you.

Good luck..Matt
 
Thanks Matt It did the Job.... hopefully one day I can find a "mathematical"
way of doing it... but for now it's working great.

Once again thank you
Frank
 
Back
Top