How to get only values for each server rather than the property names for every server

Question

$servers = Get-Content -path C:\temp\fileshares.txt

foreach ($server in $servers) {
    Write-Host "Getting file shares from $server..."
    $fileshare = Get-WmiObject -Class Win32_Share -ComputerName $server | 
    Where-Object {$_.Name -like "*$"} | 
    Select-Object @{n="Server";e={$server}}, Name, Path, @{n="Owner";e={(Get-Acl $_.Path).Owner}}
    $fileshare | out-file C:\temp\result.csv -Append
} 

output is showing in single column in excel and also column names is showing for every server. please help to get column names only once and data for all servers

Answer 1

Hi,

You can store all the results in one array.

$servers = Get-Content -path C:\temp\fileshares.txt

$fileshare = @()
foreach ($server in $servers) {
    Write-Host "Getting file shares from $server..."
    $fileshare += Get-WmiObject -Class Win32_Share -ComputerName $server | 
    Where-Object {$_.Name -like "*$"} | 
    Select-Object @{n="Server";e={$server}}, Name, Path, @{n="Owner";e={(Get-Acl $_.Path).Owner}}

} 
$fileshare | out-file C:\temp\result.csv 

Best Regards,

Ian Xue

---

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Double post