PowerShell – HostName to IP along with Ping in Excel

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.

Capture

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

https://techwizard.cloud

https://www.syscloudpro.com/

PowerShell Cheat Book

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s