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