How to Export the windows 2008 DHCP data to a CSV file .

Hi

We use windows 2008 as our DC. We have done lot of IP reservation on our DHCP Server.
Is there a way to export the DHCP data to a CSV file .

Thanks
lianne143Asked:
Who is Participating?
 
Satish AutiSenior System AdministratorCommented:
dnscmd /enumrecords zonename @ /Type A /additional > c:\filename.csv

additional – Includes all additional information about the records listed.
0
 
rhinocerosCommented:
0
 
MisterTwelveCommented:
The best option is NETSH command.

http://technet.microsoft.com/en-gb/library/cc787375(v=ws.10).aspx#BKMK_dump

dump
Dumps the configuration of the local DHCP server to the command prompt window when run within the netsh environment.
Syntax
dump
When run at the command prompt or in a batch file, output can be saved in a text file. Used without parameters, this command dumps the configuration of the local server to the command prompt window.
Syntax
netsh dhcp server [ IPAddress ] dump >[PathAndFileName]
0
 
babuseCommented:
Here is a script that would probably do the trick for ya.

Export DHCP scopes and their address pools to a csv file...
http://theadminguy.com/2010/04/15/export-dhcp-scopes-and-their-address-pools-to-a-csv-file/

------------------Sorry.  After posting this. I noticed someone had already made this suggestion
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.