The DHCP MMC Console provides this information. However, almost every
environment I have worked in has multiple DHCP servers with multiple
subnets. The manual process that I'm currently performing is to pull this
data into a single "view" is to connect to each server using the DHCP MMC
Console and drill down into each subnet's | Address Leases and then do an
"export list" (standard MMC console feature thank goodness...). I save
these 36 csv files to the same folder with the same file name. I have an
Access database that I then open that has links to these csv files. The
Access database has only 1 local table. I run a Macro that runs a single
Delete query to empty out all of the old records from this table, then runs
36 Append queries (one for each linked csv file...), and then runs a Report
at the end that breaks down the information as it's correlated with data
from SMS, Domain Controllers, etc. What I'm trying to do is avoid the big
manual process of the MMC console "Export List" routine and the Access
database. I am trying to write a single VB .NET app that pulls the
information from the various places and generates a Crystal report. I can
pull off all of the data requests using ADO and ADSI except the DHCP Address
Leases. I have possibly found a C API call that can do his (there is of
course some way to access the data if the MMC console can do it, right!?).
However, I already have almost all of the app written in VB .NET and I'm not
a C expert. Any ideas?
-Rick Ford.
"Patrick Steele [MVP]" <pa*****@mvps.o rg> wrote in message
news:MP******** *************** *@msnews.micros oft.com...
In article <#S************ **@TK2MSFTNGP12 .phx.gbl>, ri*******@dyncf g.com
says... Any ideas other than using C# or C++?
Sorry -- no. Never worked at the server-side of DHCP stuff. Your DHCP
server doesn't have any built-in reports that give you lease
information?
--
Patrick Steele
Microsoft .NET MVP
http://weblogs.asp.net/psteele
