IP address management

[michieltimmers]

Hi,

I was wondering what you all are using for you IP management. How, for example, do you quickly search for a free IP range withing NeDi that you can use? As NeDi doesn't show you the subnetmask or CIDR from a particular network.

I was looking into IPplan ( http://iptrack.sourceforge.net/ ), but I would like to stick to one tool.

[rickli]

If you put it like that, it shouldn't be too hard to create a report which shows each subnet and the occupied/free addresses. The information is all in the DB. However you can search for an IP like 10.10.10.0/24 with Nodes-List for now, which should at least show what's used in a subnet...

[michieltimmers]

yes, I now use to search based on a /24, and then I get a bit of a picture of how many ip addresses are used in that specific /24. However, then I need to check where in that /24 is for for example a free /28 that is not used.
Only to see what addresses are grouped in a particular subnet, for example a /28, within the list of the /24 would be enough for me. Then I can quickly see what is free.

To give you an example, if you would search on "10.10.10.0/24" and get somewhat like the following

IP	subnet
10.10.10.1	10.10.10.0/27
10.10.10.2	10.10.10.0/27
10.10.10.3	10.10.10.0/27
10.10.10.15	10.10.10.0/27
10.10.10.22	10.10.10.0/27
10.10.10.65	10.10.10.64/28
10.10.10.65	10.10.10.64/28
10.10.10.65	10.10.10.64/28
10.10.10.81	10.10.10.80/28
10.10.10.86	10.10.10.80/28
10.10.10.88	10.10.10.80/28

In the above I can more easily see that 10.10.10.32/27 is free for use.
Or what would be even nicer would be to show that a subnet and the following are not "attached". Like so:

IP	subnet
10.10.10.1	10.10.10.0/27
10.10.10.2	10.10.10.0/27
10.10.10.3	10.10.10.0/27
10.10.10.15	10.10.10.0/27
10.10.10.22	10.10.10.0/27
10.10.10.65	10.10.10.64/28
10.10.10.65	10.10.10.64/28
10.10.10.65	10.10.10.64/28
10.10.10.81	10.10.10.80/28
10.10.10.86	10.10.10.80/28
10.10.10.88	10.10.10.80/28

But that would only be possible if you would sort on the "subnet" column.

Thank you for your quick reply!!

[michieltimmers]

would the subnet column be possible in the next 1.0.7 release?

[rickli]

If I find the time I'll look into an approach. Hopefully the community helps to evolve it...

[rickli]

Not quite what you wanted, but maybe this could be an alternative? The beauty is, it could be combined with DNS to find stale entries or other IP mgmt tools...

[ntmark]

That looks kinda cool.
What are the bluey coloured blocks?

[rickli]

Devices are blue, nodes are green. If an IP is found for both it comes up yellow...

[michieltimmers]

Sorry for the late reply. I think this will work for me.
Is this already in 1.07? or scheduled for 1.08?

[michieltimmers]

can you comment on my question? otherwise i will just wait for 1.08 release.
thanks!

[tristanbob]

I can confirm this is working in 1.0.7.

Reports -> Population Report

There is a TON of output, and the "Network Population" graph is the one that has the graphical output you want.

Cheers and good luck!

Tristan

[tristanbob]

BTW, Remo this is a really cool feature!  Makes it easy to see how full our networks are getting. 

We can do a similar view in Infoblox appliances, but only one network at a time.  This will list our 300 networks and let us scroll through them.

Tristan

[rickli]

Yepp, I think it came out well.

It's also available in Reports-Interfaces under Network-Population. You can easily filter on the IP/Prefix as well...

[harry]

Cool..! I  havent seen that option, just checked. It is wonderfull.
Are there any more features?, which we are not aware off?

[richard.lajaunie]

Hello,
In my compagny we've decide to add a new report to list all network.
Here is the code:

Code: [Select]

<?php
/*
#============================================================================
# Program: Reports-Networks.php
# Programmer: Richard Lajaunie
#
*/

$printable = 1;

include_once ("inc/header.php");
include_once ("inc/libdev.php");
include_once ("inc/libdb-rl.php");

$_GET = sanitize($_GET);
$sta = isset($_GET['sta']) ? $_GET['sta'] : "";
$stb = isset($_GET['stb']) ? $_GET['stb'] : "";
$ina = isset($_GET['ina']) ? $_GET['ina'] : "";
$inb = isset($_GET['inb']) ? $_GET['inb'] : "";
$opa = isset($_GET['opa']) ? $_GET['opa'] : "";
$opb = isset($_GET['opb']) ? $_GET['opb'] : "";
$cop = isset($_GET['cop']) ? $_GET['cop'] : "";
$ord = isset($_GET['ord']) ? $_GET['ord'] : "";
$col = isset($_GET['col']) ? $_GET['col'] : array('vrfname','network','mask','devices','population');

$cols = array( "vrfname"=>"Vrf",
"network"=>"Network",
"mask"=>$msklbl,
"devices"=>"Devices",
"population"=>$poplbl
);
?>
<h1><?=$netlbl?> <?=$lstlbl?></h1>
<form method="get" name="list" action="<?=$self?>.php">
<table class="content"><tr class="<?=$modgroup[$self]?>1">
<th width="80"><a href="<?=$self?>.php"><img src="img/32/<?=$selfi?>.png"></a></th>
<th valign="top"><?=$cndlbl?> A<p>
<SELECT size="1" name="ina">
<?
       echo "<option value=\"vrfname\"".( ($ina == 'vrfname')?"selected":"").">Vrf\n";
       echo "<option value=\"network\"".( ($ina == 'network')?"selected":"").">Network\n";
?>
</SELECT>
<SELECT size="1" name="opa">
<? selectbox("oper",$opa);?>
</SELECT>
<p>
<input type="text" name="sta" value="<?=$sta?>" size="20">
</th>
<th valign="top"><?=$dislbl?><p>
<SELECT MULTIPLE name="col[]" size=4>
<?
foreach ($cols as $k => $v){
       echo "<option value=\"$k\"".((in_array($k,$col))?"selected":"").">$v\n";
}
?>
</SELECT>
</th>
<th width="80"><input type="submit" value="<?=$sholbl?>"></th>
</tr></table></form><p>
<?
if ($ina){
?>
<table class="content"><tr class="<?=$modgroup[$self]?>2">
<?
foreach($col as $h){
ColHead($h);
}
echo "</tr>\n";

$link = @DbConnect($dbhost,$dbuser,$dbpass,$dbname);
$query = "SELECT group_concat(distinct vrfname) as vrfname,ifip&mask as network, mask as mask,group_concat(distinct concat(device,' (',ifname,')')) as devices FROM networks GROUP BY inet_ntoa(ifip&mask) ".($ord ? "ORDER BY $ord" : '');
$res = @DbQuery($query,$link);
if($res){
$row = 0;
while( ($m = @DbFetchArray($res)) ){
if ($row % 2){$bg = "txta"; $bi = "imga";}else{$bg = "txtb"; $bi = "imgb";}
$row++;
echo "<tr class=\"$bg\">";
if(in_array("vrfname",$col)){echo "<td>{$m['vrfname']}</td>\n";}
if(in_array("network",$col)){echo "<td>".long2ip($m['network'])."</td>";}
if(in_array("mask",$col)){echo "<td>".long2ip($m['mask'])."</td>";}
if(in_array("devices",$col)){echo "<td>{$m['devices']}</td>";}
if(in_array("population",$col)){echo "<td><a href=\"Reports-Interfaces.php?ina=devip&opa=regexp&sta=".long2ip($m['network'])."%2F".substr_count(decbin($m['mask']),'1')."&rep[]=pop&lim=10&do=Show\"><img src=\"img/16/nods.png\"></a></td>";}
echo "</tr>\n";
}
@DbFreeResult($res);
}else{
print @DbError($link);
}
?>
</table>
<table class="content">
<tr class="<?=$modgroup[$self]?>2"><td><?=$row?> <?=$vallbl?><br> (<?=$query?>)</td></tr>
</table>
<?
}
include_once ("inc/footer.php");
?>