Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > IP Address Manager (IPAM) > IP Address Manager (IPAM) Documentation > IPAM Administrator Guide > IP Address Monitoring with IPAM > Import IP addresses and subnets into IPAM

Import IP addresses and subnets into IPAM

Created by Nanette.Neal, last modified by Nanette.Neal on Apr 21, 2017

Views: 2,659 Votes: 1 Revisions: 5

Import wizard

The Import wizard guides you through importing IP addresses and subnets. 

You can complete the following tasks with the Import wizard:

  • Determine where IP address information is imported to.
  • Distribute date in existing IP addresses across the subnet tree.
  • Automatically create subnets upon import.
  • Import IP4 & IP6 Groups, Supernets, and IPV6 Global prefixes, including a subnet tree hierarchy.
  • Maintain user delegation permissions for imported data.

Only a .csv, .xls or .xlsx file can be imported. For an example of spreadsheets, click Download an example spreadsheet for IP addresses or subnets.


Import IP addresses and subnets

If you are importing into existing Addresses see Importing IP Address into Existing Addresses.

  1. Click IP Address Manager in the menu bar.
  2. Click Import > Import Spreadsheet.
  3. Click Next.
  4. Click Browse.
  5. Select the content of the file included in the import.
  6. For each Database Column from the import file, select a corresponding Spreadsheet Column name to use in the IPAM table of your database.
  7. Click Next.
  8. Select which optional columns you want to import.
  9. Select the option which tells IPAM how to handle the imported content, and click Next.
  10. If the imported spreadsheet columns contain custom fields, click Add custom field and select imports.
  11. Click Save to add the custom field.
  12. Click Next.
  13. Confirm the selections for import, and click Confirm.
  14. Click Done.
Last modified