JSI Tip 1817. How do I export a DHCP database to a text file?

To export the contents of a DHCP database to a delineated text file, use Dhcpcmd.exe.

Logon to the DHCP server with Administrative priviledges and type the following at a CMD prompt:

dhcpcmd <IPAddress> enumclients <ScopeNetAddress> -<option> > <Path\outfile.txt>

where:

<IPAddress> is the IP Address of the DHCP server.

<ScopeNetAddress> is the network address of the DHCP scope.

<option> is v for detailed lease information or h for lease / hardware information.

<Path\outfile.txt> is the output file, which can be imported into Excel, Access, Word, etc....

Example:

dhcpcmd 192.168.1.10 enumclients 11.101.0.0 -h > dhcpout.txt

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish