Find, Search, Query Windows DHCP

Question

_{Wednesday, December 8, 2010 4:40 PM}

Hello,

We are looking for a way to search/query DHCP for a specific hostname, IP address or MAC address. It doesn't appear that the DHCP admin console provides this functionality. From what I can tell, we either need to export address lease list for each scope and search for the desired info (which is not feasible at all) or use netsh commands called from batch, vbs or powershell. The intent is to provide 1st tier desktop builders the ability to locate a specific MAC, host, IP quickly and easily. Have I missed something? Is scripting netsh commands the only way to do this? If so, anyone have a starter script?;) Alternatively, is their a third party app that would provide the front-end functionlity we are looking for?

Thanks for any help/advice!

p.s. Microsoft - any chance this functionality could be built-in to the mmc console?

All replies (4)

_{Thursday, December 9, 2010 5:42 AM ✅Answered}

For the most part, what you're looking for is somewhat limited. I don't have any starter scripts, nor have I needed to do anything like this, but if you haven't found them already, here are a couple links to get you started:

Use DHCP Command-line Tools
http://technet.microsoft.com/en-us/library/cc736964(WS.10).aspx

Netsh commands for DHCP
http://technet.microsoft.com/en-us/library/cc787375(WS.10).aspx

Otherwise, other than looking at the DHCP server logs, a third party DHCP service, such as MetaIP, may be what you may need.

Analyze DHCP Server Log Files - Oct 16, 2008 ... In Windows Server 2008, DHCP server log files are designed to use audit logging to permit log files to remain enabled for use without ...
http://technet.microsoft.com/en-us/library/dd183591(WS.10).aspx

Meta IP Address Management - Automated IP address and name space management solution, from Check Point Technologies. Product info, white papers.
http://www.metainfo.com/

Ace

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services

This posting is provided AS-IS with no warranties or guarantees and confers no rights.

_{Thursday, December 9, 2010 7:25 AM}

Hi,

Thanks for posting here.

Please take look the utility in the link below ,it may help you to achieve the goal:

DHCP Server Events Tool

http://blogs.technet.com/b/teamdhcp/archive/2009/03/20/tool-to-read-dhcp-server-events-for-windows-server-2008-r2.aspx

Thanks

Tiger Li

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

_{Thursday, December 9, 2010 3:18 PM}

Ace:

Thanks for the reply - I have seen those links. I think I'll have to work on getting a script that calls netsh commands to do the trick.

The reason we need this is b/c we do static reservations (define range, exclude range, then manually add reservations) and need a way for some of IT staff to quickly and easily locate a record by mac, IP, hostname.

Tiger Li:

Thanks to you as well for the reply. I tried out the tool and while it does provide nice view of the logs, it doesn't provide us with the functionality.

_{Thursday, December 9, 2010 10:40 PM}

Sorry we couldn't be very helpful. The only other suggestion was my previous suggestion to look into MetaIP.

Ace

Ace Fekay
MVP, MCT, MCITP EA, MCTS Windows 2008 & Exchange 2007, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services

This posting is provided AS-IS with no warranties or guarantees and confers no rights.