Finding Missing IP address thru a Query

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
 
M

Matt

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
 
C

Costa, Frank

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
 
Top