<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Bernard,<br>
:-) <br>
I'm the campus cable dog, I am no programmer so limited help.
Another wrote the original network scripts almost 20 years ago in
Perl for our 10Mb shared Digital Equipment DECRepeaters and 3COM
SuperStacks. (when the good old days really were not that good) <br>
Been hacking at the Perl since as generations of stuff has been
upgraded over the years. Working to move off it and go with
something more supported using Open Source.<br>
<br>
I like Netdisco, does everything we are doing for pulling in the
information. No IPAM though so need to tie that in but the MAC and
IP addresses found on the layer two switches and routers are added
to the PostgresSQL db. Just need to compare what was found to what
was expected. <br>
<br>
<a class="moz-txt-link-freetext" href="https://metacpan.org/pod/App::Netdisco">https://metacpan.org/pod/App::Netdisco</a><br>
<br>
best!<br>
jim<br>
<br>
<div class="moz-cite-prefix">On 2/24/2016 1:20 PM, Bernard Fay
wrote:<br>
</div>
<blockquote
cite="mid:CAH3AE4Zhg81dVqSvtM1NGTSKuwW9QJJt0J6DohXpu9+p57KOrg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>This is interesting! I'll have to find out how to write
such scripts. Would you have some pointers related to this
subject? <br>
<br>
</div>
Thanks Jim<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Feb 24, 2016 at 10:00 AM, Jim
Glassford <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:jmglass@iup.edu" target="_blank">jmglass@iup.edu</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hi,<br>
<br>
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>
<br>
Put these together to keep some control for IPAM, sure the
commercial products do a better job.<br>
<br>
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>
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>
<br>
best!<span class="HOEnZb"><font color="#888888"><br>
jim</font></span>
<div>
<div class="h5"><br>
<br>
<div>On 2/24/2016 9:16 AM, Bernard Fay wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>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>
<br>
</div>
I hope I am clear enough<br>
</div>
Thanks,<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, Feb 24, 2016 at
9:06 AM, Patrick Trapp <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:ptrapp@nex-tech.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:ptrapp@nex-tech.com">ptrapp@nex-tech.com</a></a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div>
<div
style="direction:ltr;font-family:Tahoma;color:#000000;font-size:10pt">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>
<br>
Are you having a specific issue you wish
to address?<br>
<br>
<div style="font-family:Times New
Roman;color:#000000;font-size:16px">
<hr>
<div style="direction:ltr"><font
size="2" color="#000000"
face="Tahoma"><b>From:</b> <a
moz-do-not-send="true"
href="mailto:dhcp-users-bounces@lists.isc.org"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:dhcp-users-bounces@lists.isc.org">dhcp-users-bounces@lists.isc.org</a></a>
[<a moz-do-not-send="true"
href="mailto:dhcp-users-bounces@lists.isc.org"
target="_blank">dhcp-users-bounces@lists.isc.org</a>]
on behalf of Bernard Fay [<a
moz-do-not-send="true"
href="mailto:bernard.fay@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:bernard.fay@gmail.com">bernard.fay@gmail.com</a></a>]<br>
<b>Sent:</b> Wednesday, February 24,
2016 7:39 AM<br>
<b>To:</b> Users of ISC DHCP<br>
<b>Subject:</b> Static IP and IP
management<br>
</font><br>
</div>
<div>
<div>
<div>
<div dir="ltr">
<div>
<div>
<div>
<div>Hello everyone,<br>
<br>
</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>
<br>
</div>
Did I miss something
somewhere?<br>
<br>
</div>
Thanks,<br>
</div>
B <br>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
dhcp-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:dhcp-users@lists.isc.org"
target="_blank">dhcp-users@lists.isc.org</a><br>
<a moz-do-not-send="true"
href="https://lists.isc.org/mailman/listinfo/dhcp-users"
rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
dhcp-users mailing list
<a moz-do-not-send="true" href="mailto:dhcp-users@lists.isc.org" target="_blank">dhcp-users@lists.isc.org</a>
<a moz-do-not-send="true" href="https://lists.isc.org/mailman/listinfo/dhcp-users" target="_blank">https://lists.isc.org/mailman/listinfo/dhcp-users</a></pre>
</blockquote>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
dhcp-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:dhcp-users@lists.isc.org">dhcp-users@lists.isc.org</a><br>
<a moz-do-not-send="true"
href="https://lists.isc.org/mailman/listinfo/dhcp-users"
rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
dhcp-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dhcp-users@lists.isc.org">dhcp-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/dhcp-users">https://lists.isc.org/mailman/listinfo/dhcp-users</a></pre>
</blockquote>
<br>
</body>
</html>