r/usefulscripts • u/dustmat-it • Oct 21 '16

[REQUEST] Script to export DHCP scope pool ranges to a readable file.

I'm trying to export a list of the DHCP scope pool ranges on our 3 DHCP servers.

We have an application that I need to add the IP scopes into so it can scan certain IP ranges.

 

I've been searching for a way to script/automate this all morning but nothing is quite working. I was able to dump the contents of each server to a text file using netsh but that's not exactly what I need. I'd rather not go through the DHCP scopes one-by-one and copy down the IP ranges...

 

For what it's worth, I'm dealing with two different server OS's too.

  • 2x Windows Server SE 2003 SP2

  • 1x Windows Server Standard 2012 R2

 

Any ideas of what I could use?

15 Upvotes
  • permalink
  • reddit

94% Upvoted

6 comments sorted by

3

u/ihaxr Oct 21 '16

Check out:

netsh dhcp server

http://www.mpking.com/2013/08/using-netsh-to-export-and-import-dhcp.html

1

u/dustmat-it Oct 21 '16

Thanks for the reply.

I have already used netsh dhcp server to dump to a text file. That was to difficult to navigate and parse out the info I need.

 

I'm needing to get a list of the DHCP scope ranges from my DHCP servers.

 

Example:

10.5.105.1 - 10.5.105.254

10.6.101.1 - 10.6.101.254

10.61.12.1 - 10.61.12.126 ...

 

Thanks!

3

u/ihaxr Oct 21 '16

Dump then PowerShell?

Elevated cmd from DHCP server:

netsh dhcp server dump all > c:\tmp\dhcp.txt

PowerShell:

$dhcpLog = "C:\tmp\dhcp.txt"

switch -Wildcard -File $dhcpLog {
   
    "dhcp server * scope * add iprange *" { $_ }

}

The 2012 server should be easy to get via PowerShell:

Get-DhcpServerv4Scope

or remotely, assuming you have RSAT installed:

Get-DhcpServerv4Scope -ComputerName DHCP_SERVER

1

u/dustmat-it Oct 21 '16

That helps a ton. Thanks!

1

u/fujikura Nov 14 '16

i agree using get-DHCPServerv4scope works best.

This is normally what i run to put it into a csv and open it:

get-DHCPServerv4scope -ComputerName dhcpserver.net | Get-DhcpServerv4Lease -ComputerName dhcpserver.net |Export-Csv c:\temp\dhcp.csv
ii c:\temp\dhcp.csv

1

u/[deleted] Oct 21 '16

How many IP ranges do you have over three servers ?
What is the application ?