PowerShell CSV Test-NetConnection Script

targets.csv

tnc.ps1

$Targets = Import-Csv $PSScriptRoot\targets.csv

if (!(Test-Path "$PSScriptRoot\logs\")) {
	New-Item "$PSScriptRoot\logs\" -ItemType directory | Out-Null
}

if (!(Test-Path "$PSScriptRoot\results\")) {
	New-Item "$PSScriptRoot\results\" -ItemType directory | Out-Null
}

$Date = Get-Date -Format "dd-MM-yyyy--HH-mm-ss"
$LogFilePath = "$PSScriptRoot\logs\log-$Date.log"
$ResultFilePath = "$PSScriptRoot\results\result-$Date.csv"

$ResultsTable = New-Object System.Data.DataTable
$ResultsColumnFQDN = New-Object System.Data.DataColumn FQDN, ([string])
$ResultsColumnTCPPort = New-Object System.Data.DataColumn TCPPort, ([string])
$ResultsColumnSuccessful = New-Object System.Data.DataColumn Successful, ([bool])

$ResultsTable.Columns.Add($ResultsColumnFQDN)
$ResultsTable.Columns.Add($ResultsColumnTCPPort)
$ResultsTable.Columns.Add($ResultsColumnSuccessful)

Write-Host "Logging to $LogFilePath"
Start-Transcript -Path $LogFilePath

ForEach ($Target in $Targets) {
	$ResultRow = $ResultsTable.NewRow()
	$ResultRow.FQDN = $Target.FQDN
	$ResultRow.TCPPort = $Target.TCPPort

	Write-Host "[$($Target.FQDN):$($Target.TCPPort)] Testing " 
	$Result = Test-NetConnection -computername $Target.FQDN -Port $Target.TCPPort
	
	If ($Result.TcpTestSucceeded -eq $true) {
		Write-Host "[$($Target.FQDN):$($Target.TCPPort)] Success"
		$ResultRow.Successful = $true
	}
 Else {
		Write-Host "[$($Target.FQDN):$($Target.TCPPort)] Failure"
		$ResultRow.Successful = $false
	}

	$ResultsTable.Rows.Add($ResultRow)
}

Stop-Transcript
$ResultsTable | Format-Table

Write-Host "Exporting to $ResultFilePath"
$ResultsTable | Export-Csv -Path $ResultFilePath -NoTypeInformation
Write-Host "Exported successfully"