DHCP address leases to SQL Server database

dhcpsql-server-2005

Is it possible to store the DHCP address leases in Windows 2003 to SQL Server database??

Best Answer

No. Point.DHCP is independant of SQL Server and there is no provvision. You can always use the DNS api to retrieve the DNS entries or the server management API to retrieve the assignments, but you must code this bridge yourself.

Related Solutions

Query 2003 dhcp leases

For a windows 2003 server query:

netsh dhcp server <type.srvIP.here> scope s.s.s.s show client | find "clientIP"
netsh dhcp server <type.srvIP.here> scope s.s.s.s show client | find "MACAddress"

You'll need to know the scope (s.s.s.s) in which this client is on, to show scopes:

netsh dhcp server <type.srvIP.here> show scope

Why not just query your network switch for it though?:

arp -a "clientIP"
arp -a | find "MACAddress"

Cisco – logging dhcp leases to syslog server on cisco router

debug ip dhcp server events
logging trap debugging

oughta do it.

yes, there may be unintended consequences if you enable other debugging while troubleshooting some other problem (for instance).

Best Answer

Related Solutions

Query 2003 dhcp leases

Cisco – logging dhcp leases to syslog server on cisco router

Related Topic