Link to home
Start Free TrialLog in
Avatar of Vijay Kanbarkar
Vijay KanbarkarFlag for India

asked on

Import DHCP reservations from a file

Hi,
We have multiple VLANs on our network. We want to move more than 150 computers from one VLAN to another VLAN. We are using single DHCP server for both the VLANs. I have exported IP address, Host name, MAC address and descriptions to CSV file. I have changed IP address in the CSV file with the IPs of other DHCP scope. How do I import that CSV file into other DHCP scope of the same DHCP server.
Import will be helpful because we have planned to move more computers in couple of weeks.

If anyone has idea kindly help.

Thanks in advance..!
Avatar of Patrick Bogers
Patrick Bogers
Flag of Netherlands image

Hi
Assuming you are using server 2012 or above...
That is something powershell is able to do with
Import-Csv Reservations.csv | Add-DhcpServerv4Reservation

All requirements about the csv structure can be read in this MS TechNet page

Cheers
And, if you're not using Server 2012 or above then you'd have to say which device / model is the DHCP server.
Avatar of Vijay Kanbarkar

ASKER

I am using Windows Server 2008 R2 as a DHCP server.
ASKER CERTIFIED SOLUTION
Avatar of Craig Beck
Craig Beck
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks you all, I will try your solutions and update you.
No more updates from poster