Ping a list of host names and output the results to a csv in powershell

by

You can use the following code instead (I simply altered the write-host calls to CSV formatting) and execute it with “PowerShell.exe script.ps > output.csv”
Note that you must execute it from the folder that contains hnames.txt, or simply change the “hnames.txt” to a full path.

$names = Get-content "hnames.txt"

foreach ($name in $names){
  if (Test-Connection -ComputerName $name -Count 1 -ErrorAction SilentlyContinue){
    Write-Host "$name,up"
  }
  else{
    Write-Host "$name,down"
  }
}

P.S. You can also use the Out-File Cmdlet to create the CSV file

More Related Contents:

  1. How can I add up two 2d (pitched) arrays using nested for loops?
  2. x86_64 – Assembly – loop conditions and out of order
  3. Loop through files in a folder in matlab
  4. How exactly does the x86 LOOP instruction work?
  5. Register variables in with_items loop in Ansible playbook
  6. Loop through array of variable names in Less
  7. how do I loop through a line from a csv file in powershell
  8. Convert nested JSON array into separate columns in CSV file
  9. How to remove all quotations mark in the csv file using powershell script?
  10. Dynamically create variables in PowerShell
  11. Merging multiple CSV files into one using PowerShell
  12. Looping on a protractor test with parameters
  13. ConvertTo-Csv Output without quotes
  14. How I can stop an animated GIF in JavaFX?
  15. Continuous Looping Page (Not Infinite Scroll)
  16. Why should I use foreach instead of for (int i=0; i
  17. Script runtime execution time limit
  18. How to use powershell to reorder CSV columns?
  19. Add Column to CSV Windows PowerShell
  20. Proper way to release resources with defer in a loop?
  21. Map in order range loop
  22. How to render a tree in Twig
  23. How to iterate or map over tuples?
  24. Using Powershell environmental variables as strings when outputting files
  25. Read a Csv file with powershell and capture corresponding data
  26. Remove last line from file with Powershell
  27. Powershell script to remove double quotes from CSV unless comma exists inside double quotes
  28. Getting “System.Collections.Generic.List`1[System.String]” in CSV File export when data is okay on screen
  29. PS Script is exporting an empty CSVs
  30. Get iteration index from List.map()

Leave a Comment