Need an SQL Query to pull DHCP assigned IP's, MAC, Client Name etc from IPAM/UDT tables

Hello,

I'd like to pull a custom report from IPAM showing all active DHCP assigned IPv4 addresses along with other data including DHCP Client Name, MAC Address, Vendor, DHCP Reseervation, Last Response, Scope Name etc for a particular DHCP server. i.e. similar to the standard "IP Address View" in the GUI (See attached).

Could someone provide some a sample SQL?

DHCP_Screenshot.png

Find more posts tagged with

Accepted answers

All comments

jm_sysadmin

You should be able to do it without SQL or SWQL, I think everything is available from the new report wizard.

Use the dynamic Query builder, and make sure you select DHCP Scope as the thing you need to report on.

Then just add the columns to the table you need, it should have everything you need. If not tell me what you can't get, and we can figure it out.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of