Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from stackoverflow.com Nov 27 '11 at 8:18

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer

Yes.

From https://www.microsoft.com/en-us/download/details.aspx?id=24659:

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.