Export Foreach-Object Powershell

Question

Hi ,

Need to export the below code to csv

Get-MsolAccountSku | ForEach-Object {
Write-Host "n"$_.AccountSkuId Write-Host "t* SKUId:"$.SkuId
$result = $.ServiceStatus | ForEach-Object {
Write-Host "tt+" $.ServicePlan.ServiceName
Write-Host "tt`t- ServiceType:" $.ServicePlan.ServiceType
select $_.ServicePlan.ServiceName
}
}

$result | export-CSV 'e:\temp\Chart.csv'

Answer 1

Keep in mind that Write-Host does not produce output to the pipeline (it goes to the host only, so there's nothing to export).

Answer 2

What is your main objective, to try and get licence information for each user?

Answer 3

Hi,

There's no object piped to select so the output is null. And the inner for-each loop is unnecessary as each object has only one ServiceStatus property.

$result = Get-MsolAccountSku | ForEach-Object {  
    Write-Host "`n"$_.AccountSkuId   
    Write-Host "`t* SKUId:"$_.SkuId  
    Write-Host "`t`t+" $_.ServiceStatus.ServicePlan.ServiceName  
    Write-Host "`t`t`t- ServiceType:" $_.ServiceStatus.ServicePlan.ServiceType  
    $_.ServiceStatus.ServicePlan.ServiceName  
}   
$result | export-CSV 'e:\temp\Chart.csv'  

Best Regards，
Ian

============================================

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.