Query DHCP database?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jack Black (jackisback_at_hotmail.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 16:19:03 -0700

Any relatively painless way to query the domain DHCP server(s) to get
a list of current leases by IP and machine name?

Mucho thanks,
Jack

Relevant Pages

  • Re: problem getting a query to recognize "Not" and "<>" in a value list combo box
    ... Source was the one to display all records, so column 1 had a value of "*", ... and column 2 had a value of "All Leases". ... After reading your first suggestion, I modified those two components of the ... This query is based on one table, ...
    (microsoft.public.access.forms)
  • Re: dates between
    ... that have no record where today is between the Arrive and Depart dates. ... Create a query based on the Leases table. ... but even this does not show me at a glance which dates are ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Confusing Query based on Dates
    ... subqueries to get the desired count from your Leases table: ... FROM Leases ... FROM tblDate ... Now I want to query the LEASE table ...
    (microsoft.public.access.queries)
  • Re: Need help with a Group Count query
    ... FROM Leases ... Save the above query and then create a new select query based on your union ... Once the union query is displayed in the top panel of your new query, ... In the Crosstab property for YrMth, ...
    (microsoft.public.access.queries)
  • Re: Comparing next in a sequence
    ... I was able to get the query to run and work but I did have to ... the first lease signed for a property does not have the first Lease Begins ... two tables - Properties and Leases. ... FROM Leases As T LEFT JOIN Leases As P ...
    (microsoft.public.access.queries)