Networking Forums

Networking Forums > Computer Networking > Windows Networking > Output DHCP database to SQL database?

Reply
Thread Tools Display Modes

Output DHCP database to SQL database?

 
 
=?Utf-8?B?Q2hyaXN0aWFuV2lja2hhbQ==?=
Guest
Posts: n/a

 
      01-06-2005, 11:21 PM
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?
 
Reply With Quote
 
 
 
 
Achint Setia[MSFT]
Guest
Posts: n/a

 
      01-26-2005, 01:32 PM
Hi,

You can use the "callout dll" feature provided by the Win2003 DHCP Server:-
http://msdn.microsoft.com/library/de...server_api.asp

You can write your own callout functions (DhcpAddressOfferHook and
DhcpDeleteClientHook)and hook them into the DHCP server service.

Whenever a new client lease is created or an existed one deleted, your
application will be notified and you can update the SQL database.

Hope this helps!

--
Thanks,
Achint Setia
(E-Mail Removed)
-------------------------------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
-------------------------------------------------------------------------------------------------------------------
"ChristianWickham" <(E-Mail Removed)> wrote in
message news:2AEE1841-EF2B-4F7C-BE15-(E-Mail Removed)...
> 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?



 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
move DHCP database Sawyer Windows Networking 2 07-21-2009 06:24 PM
Can't restore DHCP database Bob Windows Networking 5 07-30-2008 01:15 AM
DHCP database question Brendon B Windows Networking 0 04-02-2008 11:28 AM
DHCP Database-How to read? Kam Windows Networking 5 05-02-2007 10:37 AM
Queries DHCP database Kam Windows Networking 0 04-11-2007 11:22 PM



1 2 3 4 5 6 7 8 9 10 11