Over the years I have written quite a few scripts many of which are still useful today. I’m a big fan of PowerShell as I frequently run into Windows environments.
These Ping and Reverse (DNS) Lookup Scripts have come in handy for me. They will process a list of hostnames or IPs in a text file and then export the outputs to a .csv or a formatted Excel (.xls) workbook. Additional details are in the comments of the code. Enjoy!