Solved

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

Posted on 2013-06-06
4
6,169 Views
Last Modified: 2013-06-24
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
0
Comment
Question by:lianne143
4 Comments
 
LVL 13

Assisted Solution

by:rhinoceros
rhinoceros earned 75 total points
ID: 39228108
0
 
LVL 4

Accepted Solution

by:
Satish Auti earned 75 total points
ID: 39228113
dnscmd /enumrecords zonename @ /Type A /additional > c:\filename.csv

additional – Includes all additional information about the records listed.
0
 
LVL 5

Assisted Solution

by:MisterTwelve
MisterTwelve earned 75 total points
ID: 39228567
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
 
LVL 2

Assisted Solution

by:babuse
babuse earned 75 total points
ID: 39228843
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Resolve DNS query failed errors for Exchange
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now