export to csv issue

hello,  when run script below, i'm having issues processor query.  when runs on computer more 1 cpu can't right csv file.  i'm thinking has putting 2 results in 1 cell.  there way fix this?

 

$servers = get-content "c:\list.txt"     function get-computerinfo { foreach($server in $servers) {  $result = "" | select-object name, 'operating system', 'service pack', disks, manufacturer, model, memory, cpu $cs = gwmi win32_computersystem -computername $server | select name, manufacturer, model, totalphysicalmemory $os = gwmi win32_operatingsystem -computername $server | select caption, csdversion $cp = gwmi win32_processor -computername $server | select name, numberofcores, maxclockspeed  $lastbootuptime = $wmi.converttodatetime($wmi.lastbootuptime)  $result.name = $cs.name $result.manufacturer = $cs.manufacturer $result.model = $cs.model $result.memory = $cs.totalphysicalmemory/1gb $result.'operating system' = $os.caption $result.'service pack' = $os.csdversion $result.cpu = $cp.name   $result }  } get-computerinfo | export-csv report.csv –notype    

 

 

i don't have single cpu box available @ moment, try this..

$cp = @(gwmi win32_processor -computername $server | select name, numberofcores, maxclockspeed ) ###force array
$result.physicalcpu = $cp.count
$result.cpu = $cp[0].name

so, im doing im forcing wmi call return array.. safe assume cpu's same.. can count of array show how many physical cpu's have , print data first element in array name, speed , cores since odds of cpus being same likely..

Windows Server  >  Windows PowerShell