$res=@()
$hosts = Get-Content hosts.txt
foreach ($hostname in $hosts){
 $server = New-Object -TypeName psobject
 $server | Add-Member -MemberType NoteProperty -Name hostname -Value $hostname
 $server | Add-Member -MemberType NoteProperty -Name online -Value ""
 $server | Add-Member -MemberType NoteProperty -Name IP -Value ""
 $server | Add-Member -MemberType NoteProperty -Name OS -value ""
 $rtn=test-connection $hostname -Count 2 -BufferSize 16 -erroraction silentlycontinue
 if(!$rtn){
   $server.online=$false
   write-host "$hostname offline" -ForegroundColor red;
 }else{
   $server.online=$true
   $server.IP=(($rtn.properties|? name -eq "ProtocolAddress").value|select -first 1)

   $wmi=get-wmiobject -computer $hostname win32_operatingsystem -ErrorAction SilentlyContinue
   $server.OS=$wmi.caption

   $s=Invoke-Command -cn $hostname -ScriptBlock {
       Get-ItemProperty HKLM:SoftwareMicrosoftWindowsCurrentVersionUninstall*|where {$_.displayname -like "*McAfee*"}|select displayname,displayversion
   }
   $s|foreach{
       $server | Add-Member -MemberType NoteProperty -Name $_.displayname -Value $_.DisplayVersion
   }
 }
 $res+=$server
}
$res
$res|export-csv "versions.csv" -NoTypeInformation
notepad "versions.csv"

hostname     : server1
online       : True
IP           : secretip
OS           : Microsoft Windows Server 2008 R2 Standard
McAfee Agent : 5.0.5.658

hostname                                            : server2
online                                              : True
IP                                                  : secretip
OS                                                  : Microsoft Windows Server 2016 Standard
McAfee Agent                                        : 5.0.5.658
McAfee Endpoint Security Threat Prevention          : 10.5.1
McAfee_EndpointSecurityForServer_10.5.1_0_x64_P0_EN : 10.5.1

hostname     : server3
online       : True
IP           : secretip
OS           : Microsoft Windows Server 2008 R2 Standard
McAfee Agent : 5.0.5.658

hostname     : server4
online       : True
IP           : secretip
OS           : Microsoft Windows Server 2008 R2 Standard
McAfee Agent : 5.0.5.658

hostname : server5
online   : False
IP       :
OS       :

hostname                                            : server6
online                                              : True
IP                                                  : secretip
OS                                                  : Microsoft Windows Server 2012 R2 Standard
McAfee Agent                                        : 5.0.5.658
McAfee Endpoint Security Threat Prevention          : 10.5.1
McAfee_EndpointSecurityForServer_10.5.1_0_x64_P0_EN : 10.5.1

hostname                                   : server7
online                                     : True
IP                                         : secretip
OS                                         : Microsoft Windows Server 2016 Standard
McAfee Agent                               : 5.0.5.658
McAfee Endpoint Security Threat Prevention : 10.5.1
McAfee Endpoint Security Platform          : 10.5.1