DNS Bulk host Import

Last week I was with a customer that had multiple clients not added to the DNS server. Because we added these hosts to the new SCOM 2012 R2 environment we had only the IP address to work with. This is not user friendly and the host name of the device gives us insight of the location of the device.

So I needed a quick way to add around 250 devices directly to the DNS server.. I already had a sheet in a CMDB with the HostNames and IP adresses..

I exported these hosts and IP adresses in to a CVS file format,

now save your file as a CSV file in the format as above.
the following PowerShell Script I used to add these hosts to my DNS server..

Run the Script with DNS add premissions and al the host names will be added to your preferd zone.