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.