As Technet Gallery is retiring so moving the code to Git Hub. (click below github download link for this script)
PowerShell – HostName to IP along with Ping in Excel
This script will use list of Host Names , pings them, report if its up or down and fetch the IP address from PING command.
This has been requested by our windows team as they have list of hostnames for hundreds of server and they wanted to note down their IPAddress for inventory/ Documentation.
Download and extract the solution from above.
Update the MachineList.txt file and launch the batch file.(Excel will open & start populating with results)
Note: Excel is required component for this script to work.
Thanks for reading …
Tech Wizard