Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > IP Address Manager (IPAM) > Import subnets in IPAM

Import subnets in IPAM

Table of contents
Created by Daniel Phillipps, last modified by Steven Bansil_ret on Aug 02, 2016

Views: 233 Votes: 2 Revisions: 10

Overview

This article provides steps on how to format your spreadsheet and how to technically calculate the subnet values that should be used.

Environment

IPAM version 4.x

Steps

  1. Go to the Manage Subnets and IP Addresses page.
  2. Click Import a spreadsheet.
  3. If you have not selected to hide it, you will be shown the help screen for Preparing to import a spreadsheet. This screen will provide basic information on what types of spreadsheet are supported (.csv, .xls or .xlsx only) as well as provide you sample sheets you can use to import. You can find the sample import spreadsheets located on your primary poller within this directory: inetpub\SolarWinds\Orion\IPAM\res\samples.
  4. Select the spreadsheet you wish to import from.
  5. Select whether this is a list of IP addresses to import or whether it is a group, supernet or subnet to import, then click Next. Note that importing a spreadsheet with a list of IP addresses will import all the IP information specifically. Importing a group, supernet and subnet will import everything specifically to those only.
  6. Match the columns from IPAM to the columns within the spreadsheet via dropdown button.
  7. Determine whether you wish for IPAM to make the hierarchy or choose to do so at a later date.
  8. Match any Custom fields in IPAM to columns within the spreadsheet.
  9. At this point, it should determine whether the information is clear enough in the spreadsheet to accurately import into IPAM. If in the event that it fails, it will indicate which columns or portions are incorrect. To determine the cause of failure, export the results to spreadsheet to check. The results will be placed in a separate spreadsheet that you will be tasked to save to a location. When you open the spreadsheet, it will have added a Comment inserted into the affected column cells that will indicate why it failed. Make adjustments as needed and re-import.
  10. Import the results into IPAM.

    You can use the subnet calculator to verify if they are correct. If any of them are incorrect, then the entire import will fail. See the link below to use the subnet calculator: http://mxtoolbox.com/subnetcalculator.aspx

 

Last modified

Tags

Classifications

Public