DHCP – Export Machine MAC Addresses via Powershell

Here is a look at DHCP server. A DHCP server is a server which hands out IP addresses to devices. When you have a few machines, it is easy to get the information I.E Mac Address, IP Addresses etc. however, when you have a large amount machines, Powershell is the way. It Is a simple process but when you under pressure can seem much. Open DHCP > Scope Options > Address leases and confirm the list of machines.

Then run Powershell as Administrator.

Run the following command:

Get-DHCPServerv4Lease –Computername <DHCP Server> -ScopeID x.x.x.0

To export to a CSV, run the following command:

Get-DHCPServerv4Lease –Computername <DHCP Server> -ScopeID x.x.x.0 | Export-Csv c:\DHCPcsv.csv

Open the document with Excel, run the Text-to-Columns and you good to go.