Solved

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

Posted on 2013-06-06
4
7,027 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 13

Assisted Solution

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

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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
A hard and fast method for reducing Active Directory Administrators members.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

742 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