Export DHCP Reservations with Mac addresses:
I had difficulty recently with our DHCP reservations, namely i coudnt export the MAC addresses included in the reservation and the mmc was only allowing very limited as I could only export the ip address and the FQDN of the computer owner.
After a bit of rummaging i found an entry for DCHP in netsh. I found that you could dump the DHCP server settings to a text file. This included every server setting aswell as the reservations. I then filtered the exported file for “Add reservedip” using the find command to export a csv file with just the reservations.
Once i had the file in csv, i simply imported it into an excel sheet using spaces as the delimiter and hey presto a lovely little reservation report:
Same rules as always, dont run it from a UNC path, copy it local to the DHCP server and run it there.
netsh dhcp server dump >> reservationdump.txt
find “Add reservedip” reservationdump.txt >> reservations.csv
You can download the script as is here:
Spuggy said,
June 17, 2008 at 12:40 pm
Cheers for that mate worked a treat and speeded up what would have been very boring task
Michael said,
July 22, 2008 at 2:03 am
awesome mate thanks alot, worked perfectly.
Todd said,
October 28, 2008 at 3:35 pm
Your download doesn’t work anymore, just so you know.
Andrew Morgan said,
October 28, 2008 at 4:06 pm
Hi Todd,
I’ve updated the download link as per your notice, seems 4shared don’t allow .bat downloads anymore