thanks for this script luc,
the script executed successfully without any errors though it has not created any report in the defined location
I tried eliminating the file path though no luck.
I could also see the key exchange, authentication and session eshtablishment everything during the script execution
but no output
below the is the script which was executed.
$ExportFilePath = "C:\HostInfo.csv"
$PuttyUser = "root"
$PuttyPwd = "*******"
$Plink = "C:\Temp\Plink.exe"
$PlinkOptions = " -v -batch -pw $Puttypwd"
$cmd1 = 'cat /proc/scsi/qla*/*'
$RCommand0 = "ethtool -i "
$cmd2 = 'cat /proc/scsi/qla*/*'
$RCommand1 = '"' + $cmd2 + '"'
$qlR1 = [regex]"QLogic.+for\s(\w+):"
$qlR2 = [regex]"Firmware version ([\d|\.]+).+Driver version ([\d|\.]+)"
$ESXHosts = Get-cluster XLP-XLP-XLP | Get-Vmhost
$Report = @()
ForEach ($ESXHost in $ESXHosts) {
$row = "" | Select Hostname,ESXVersion,BiosVersion,BIOSDate
$row.HostName = $ESXHost.Name
$row.ESXVersion = $ESXHost.Version
$row.BiosVersion = $ESXHost.ExtensionData.hardware.biosinfo.biosversion
$row.BiosDate = $ESXHost.ExtensionData.hardware.biosinfo.releasedate
$pNics = $ESXHost | Get-VMHostNetworkAdapter -physical
$i = 1
ForEach ($pNic in $pNics) {
$command = $Plink + " " + $PlinkOptions + " " + $PuttyUser + "@" + $ESXHost.Name + " " + $RCommand0 + " " + $pNic.Name
$Message = Invoke-Expression -command $command
$row | Add-Member -Name pNICName$i -Value $pNic.Name -MemberType NoteProperty
$row | Add-Member -Name DriverName$i -Value ($Message[0] -split "driver: ")[1] -MemberType NoteProperty
$row | Add-Member -Name DriverVersion$i -Value ($Message[1] -split "version: ")[1] -MemberType NoteProperty
$row | Add-Member -Name DriverFirmware$i -Value ($Message[2] -split "firmware-version: ")[1] -MemberType NoteProperty
$i++ }
$command = $Plink + " " + $PlinkOptions + " " + $PuttyUser + "@" + $ESXHost.Name + " " + $RCommand1
$msg = Invoke-Expression -command $command
$i = 1
$msg | % {
if($_ -match $qlR1){
$row | Add-Member -Name HBAtype$i -Value $qlR1.Match($_).Groups[1].Value -MemberType NoteProperty
}
if($_ -match $qlR2){
$matches = $qlR2.Match($_)
$row | Add-Member -Name HBAfirmware$i -Value $matches.Groups[1].Value -MemberType NoteProperty
$row | Add-Member -Name HBAdriver$i -Value $matches.Groups[2].Value -MemberType NoteProperty
$i++
}
}
$report += $row}
IF ($Report -ne "") {
$Report |
Sort-Object -Descending -Property {$_ | Get-Member -MemberType NoteProperty |
Measure-Object | Select -ExpandProperty Count} | Export-Csv $ExportFilePath -NoTypeInformation -UseCulture
Invoke-Item $ExportFilePath}
