<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Bernard,<div class=""><br class=""></div><div class="">I don’t have any experience with it, but there is an open source tool that aims to do exactly what you are looking for, document what is on the network, what addresses are in use, and which are available. It also has some integration with both ISC DHCP and BIND.</div><div class="">It is NetDot (network documentation), published by the University of Oregon … <a href="https://osl.uoregon.edu/redmine/projects/netdot" class="">https://osl.uoregon.edu/redmine/projects/netdot</a></div><div class=""><br class=""></div><div class="">Does anyone on the list have feedback about NetDot? Any users here? <br class=""><div class=""><br class=""></div><div class="">Vicky</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Feb 24, 2016, at 10:20 AM, Bernard Fay <<a href="mailto:bernard.fay@gmail.com" class="">bernard.fay@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">This is interesting! I'll have to find out how to write such scripts. Would you have some pointers related to this subject? <br class=""><br class=""></div>Thanks Jim<br class=""></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Wed, Feb 24, 2016 at 10:00 AM, Jim Glassford <span dir="ltr" class=""><<a href="mailto:jmglass@iup.edu" target="_blank" class="">jmglass@iup.edu</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000" class="">
Hi,<br class="">
<br class="">
This works for us, ymmv. We use home grown scripts that pull
information from a database to build our dhcpd.conf and dns files
for all static assignments. We also have different scripts that
pull the arp tables from the routers each hour and from layer two
switches ports to keep track of who is where. <br class="">
<br class="">
Put these together to keep some control for IPAM, sure the
commercial products do a better job.<br class="">
<br class="">
As part of the hour run script, we do a compare on what is found in
arp tables to what we have in the assigned database. If a match, the
MAC and IP address match what is in the database, update a count
field and the date it was found. If a MAC is found in arp table does
not match the assigned IP address, send and email for a discrepancy
(someone hard coded when they should not or other issue that needs
addressed)<br class="">
Once in awhile (when I need more static IP addresses for a subnet)
review the count and last updated fields, if older than a year +/-
then safe to re-assign this IP address. <br class="">
<br class="">
best!<span class="HOEnZb"><font color="#888888" class=""><br class="">
jim</font></span><div class=""><div class="h5"><br class="">
<br class="">
<div class="">On 2/24/2016 9:16 AM, Bernard Fay
wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div dir="ltr" class="">
<div class="">
<div class="">I manage a lab where there is about 300-400 IPs assigned
to different network equipments, physical and virtual
servers. So IPs might be assigned for a while then
equipments removed because not needed anymore, remember this
is a lab. I would like to know which IPs are in used or
not. Equipments removed means IPs not used anymore so we
could reuse those IPs. <br class="">
<br class="">
</div>
I hope I am clear enough<br class="">
</div>
Thanks,<br class="">
<br class="">
</div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Wed, Feb 24, 2016 at 9:06 AM,
Patrick Trapp <span dir="ltr" class=""><<a href="mailto:ptrapp@nex-tech.com" target="_blank" class="">ptrapp@nex-tech.com</a>></span>
wrote:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">
<div style="direction: ltr; font-family: Tahoma; font-size: 10pt;" class="">I
believe a helpful answer will require some context. You
haven't told us what issues you are having with IP
management, so it's going to be difficult to identify
how static IP's might be beneficial.<br class="">
<br class="">
Are you having a specific issue you wish to address?<br class="">
<br class="">
<div style="font-family: 'Times New Roman'; font-size: 16px;" class="">
<hr class="">
<div style="direction:ltr" class=""><font face="Tahoma" size="2" class=""><b class="">From:</b> <a href="mailto:dhcp-users-bounces@lists.isc.org" target="_blank" class=""></a><a href="mailto:dhcp-users-bounces@lists.isc.org" target="_blank" class="">dhcp-users-bounces@lists.isc.org</a>
[<a href="mailto:dhcp-users-bounces@lists.isc.org" target="_blank" class="">dhcp-users-bounces@lists.isc.org</a>]
on behalf of Bernard Fay [<a href="mailto:bernard.fay@gmail.com" target="_blank" class=""></a><a href="mailto:bernard.fay@gmail.com" target="_blank" class="">bernard.fay@gmail.com</a>]<br class="">
<b class="">Sent:</b> Wednesday, February 24, 2016 7:39 AM<br class="">
<b class="">To:</b> Users of ISC DHCP<br class="">
<b class="">Subject:</b> Static IP and IP management<br class="">
</font><br class="">
</div>
<div class="">
<div class="">
<div class="">
<div dir="ltr" class="">
<div class="">
<div class="">
<div class="">
<div class="">Hello everyone,<br class="">
<br class="">
</div>
I have been told that static IP
assignation can help in IP management.
Of course, I can know which IPs are
assigned by looking in dhcpd.conf. But
after a while an IP might not be used
anymore and nothing in dhcpd or bind
will tell me if it still in use or not.
I have setup a lab to experiment where I
have configured dhcpd and bind and I
cannot find out how static IP can really
help in IP management.<br class="">
<br class="">
</div>
Did I miss something somewhere?<br class="">
<br class="">
</div>
Thanks,<br class="">
</div>
B <br class="">
<br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br class="">
_______________________________________________<br class="">
dhcp-users mailing list<br class="">
<a href="mailto:dhcp-users@lists.isc.org" target="_blank" class="">dhcp-users@lists.isc.org</a><br class="">
<a href="https://lists.isc.org/mailman/listinfo/dhcp-users" rel="noreferrer" target="_blank" class="">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br class="">
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class=""></fieldset>
<br class="">
<pre class="">_______________________________________________
dhcp-users mailing list
<a href="mailto:dhcp-users@lists.isc.org" target="_blank" class="">dhcp-users@lists.isc.org</a>
<a href="https://lists.isc.org/mailman/listinfo/dhcp-users" target="_blank" class="">https://lists.isc.org/mailman/listinfo/dhcp-users</a></pre>
</blockquote>
<br class="">
</div></div></div>
<br class="">_______________________________________________<br class="">
dhcp-users mailing list<br class="">
<a href="mailto:dhcp-users@lists.isc.org" class="">dhcp-users@lists.isc.org</a><br class="">
<a href="https://lists.isc.org/mailman/listinfo/dhcp-users" rel="noreferrer" target="_blank" class="">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br class=""></blockquote></div><br class=""></div>
_______________________________________________<br class="">dhcp-users mailing list<br class=""><a href="mailto:dhcp-users@lists.isc.org" class="">dhcp-users@lists.isc.org</a><br class="">https://lists.isc.org/mailman/listinfo/dhcp-users</div></blockquote></div><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Victoria Risk</div><div class="">Internet Systems Consortium</div><div class=""><a href="mailto:vicky@isc.org" class="">vicky@isc.org</a></div><div class=""><br class=""></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br class=""></div></div></body></html>