cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Import subnets spreadsheet does not add the IP addresses

Hi,

I understand that when importing a spreadsheet of multiple subnets, the IP addresses are not populated; but, I don't understand why when manually scanning the imported subnets, the IPs are not discovered.

I don's see a situation where somebody wants to have all the subnets in IPAM, but not the IPs within the subnets.

7 Replies
Level 8

I just ran into this as well.  What I did was create a perl script that took in a list of all of the subnets (first 3 octets) and output a list of each subnet with the IPs of that range.  see the script below.  i made it comma delimited and added two columns to include the subnet and the CIDR, but you can add whatever you want. fairly simple and straight forward.

#!/usr/bin/perl

#use strict;

#all subnets in this list are missing the last octet

open (IPS, 'all-vlan-ips.txt');

open (MYFILE, '>>all-vlan-ip-output.csv');

foreach $line (<IPS>)

{

    chomp($line);

  for (my $i=1; $i <= 254; $i++)

  {

        #first column is the subnet by adding .0 as the 4th octet, second column is the CIDR, third column creates each 4th octet to match the range in the for loop.

  print MYFILE ($line . ".0" . ",24" . "," . $line . "." . $i . "\n");

  }

}

close (IPS);

close (MYFILE);

Level 12

I believe this is what you are looking for:

AddIps.zip

I've used this several times and I believe it does exactly what you are looking for.  After you import your subnets, run this little GUI app and it gives you the capability to add all of the IPs in your subnets that you imported.

0 Kudos

This version (of AddIPs) does not seem to work in IPAM 4.1.

0 Kudos

Hi,

by saying "not discovered" I guess you don't see any content of your subnet. You may use the tool described in this post:IP Address Manager tips &amp; tricks to solve the problem you have.

thanks,

michal

0 Kudos

this is correct, I don't see any content of the subnet when imported from a spreadsheet;  however, if manually create the subnet, the content is populated, unless deliberately have the  "Add IP Addresses with the subnet" box checked off.

0 Kudos

Did you ever figure out a solution for this?

0 Kudos

no, apparently cannot.

I chose to import IPs spreadsheets instead.

0 Kudos