The IP Address Management (IPAM) client in Server Manager allows you to manually add and edit IP addresses, but if you have been recording IP address utilization in a spreadsheet, you will probably want to try and import that data into IPAM. In this article, I’ll show you how to format IP address information in a file correctly to import bulk IP addresses into Windows Server 2012 using IPAM.
IPAM is poorly documented in my opinion, making a useful feature harder to use and understand than it should be. Importing data into IPAM is very simple once you know how. Let’s start by looking at what information about IP addresses we can actually import. To do this, log on to your IPAM server and open Server Manager:
If you want to import IP Address and Assignment Type information, you need to add these fields to the first line of your import file, without spaces, as shown below:
Alternatively, you can keep the spaces in the field names and enclose with quotation marks, for example, “IP Address” and “IP Address State”. The actual IP address data should then follow, comma delimited in the same order that you specified the fields as shown above.
Some fields, such as IP Address State, will require you to look and see what the valid input options are. To find out what the possible options are:
Once you’ve decided what information to import and formatted it correctly in a comma delimited file (.csv), you’re ready to import the IP addresses into IPAM:
Once the IP addresses have been imported, they should appear in the main window if the current view is set to IP Addresses.