SQL Output from DHCP database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to get a live output from DHCP that would allow us to have a
SQL database of MAC addresses, IP Addresses and Names - so that we could use
other software (network monitoring software) to be able to display these
three parameters from MAC address information that we have?

We have been doing it manually to track rogue hosts and virus infected
machines through their activity (such as using non-standard ports and high
usage), but we want to do it in a more automated way.

Does anyone know how to get Windows 2003 DHCP to output this information? Or
could we use WINS to provide this data feed?
 
Backing up the DHCP database in Windows Server 2003:

http://www.microsoft.com/resources/...roddocs/en-us/sag_DHCP_und_DatabaseBackup.asp

If you had a Windows 2000 DHCP Server you could use the DHCPEXIM tool to
export the database. In either case, I believe you can export the DHCP
database to a text file, then massage it into a database with your favorite
tool.

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* PLEASE post all messages and replies in the newsgroups
* for the benefit of all. Private mail is usually not replied to.
* My website, such as it is ... http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm
 
Back
Top