Avatar of Vijay Kanbarkar
Vijay Kanbarkar
Flag 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..!
* VLANDHCP

Avatar of undefined
Last Comment
Patrick Bogers

8/22/2022 - Mon
Patrick Bogers

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
hypercube

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

ASKER
I am using Windows Server 2008 R2 as a DHCP server.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Craig Beck

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Patrick Bogers

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vijay Kanbarkar

ASKER
Thanks you all, I will try your solutions and update you.
Patrick Bogers

No more updates from poster