Situation: The client would like to know all their network devices and MAC addresses. We use Windows DHCP export to collect this information for them. Here is how.
1.Login Domain Controller.
2.Open DCHP Server.
3.Navigate to Address Leases.
4. Right click on Address Leases and then Export List.
5. Type the File name and save it
6. Open saved DHCP export list from the Excel and modify it.
Please view this step by step video: