Solved

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

Posted on 2013-06-06
4
5,939 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
Comment Utility
0
 
LVL 4

Accepted Solution

by:
Satish Auti earned 75 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

762 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

12 Experts available now in Live!

Get 1:1 Help Now