New DHCP implementation... database import...

[Auger282]

Heres the situation:

We are regulated to have static ips assigned on our network but we were looking for an easy way to update server info to all the users at one time (dns, wins, etc.)..and adding new users.

so we are going to have to build a reserved address database within the DHCP. The question is the only way we can see to put in the reserved address is to manually type in the addresses and the MACs of all of our 250 computers.

You would THINK there would be some form of dragging and dropping feature to move computers into the reserved status but it doesnt look like it.

Windows 2k server DHCP

I do see that there is a database import feature but it will only import microsoft files... I currently have an excel database that can be converted to whatever.. but we were wondering if there are any 3rd party tools that could do a conversion TO the microsoft backup format.. or if there was a 3rd party too that could do this import an easier way then typing it all in..

Thanks a bunch

 

[wchull]

You may be making this too hard. Here is the format of a command:

Dhcp server <DHCP Server IP Addr> Scope <Scope Addr> Add reserverdip <reserved IP addr> <MAC Addr> "<machine fqdn>" "" "BOTH"

For example here is a sample of an entry:

Dhcp Server 10.172.16.97 Scope 10.172.16.0 Add reservedip 10.172.18.112 000bcd0433e2 "TSTWS005.YOURCO.COM" "" "BOTH"

Based on the above format, you create just a regular text file containing all your DHCP reservations. Once the file has been created you can then run the NETSH.EXE program to load them into DHCP. The command would look like this:

NETSH EXEC MyResIP.TXT

where MyResIP.TXT is your text file containing your records.

A good tip.....

When you are all finished, Use NETSH to build you a backup of your DHCP with the following command:

NETSH DHCP SERVER \\[ServerName or IPAddress] DUMP > FILENAME

For example:

NETSH DHCP SERVER \\MYSRV001 DUMP > MYSRV001.DMP

The resulting dump file will contain all your scopes, and both scope and server options, etc, etc, etc, including all of your DHCP reservations.

If you ever loose DHCP entirely and don't have a good backup you can at least rebuld your scopes, and all of your settings and put all your DHCP reservations back in in a few seconds. To do so you just use the dump file as input in the NETSH EXEC commmand shown above.