How to use -ExpandProperty for multiple properties?

PowerShell Help
1

Hi,
Could some one tell me how I can expand properties for several at a time in “| Select-Object” cmdlet.

2

You can’t. That wouldn’t actually make sense, as the point of the parameter is to return a single property into the pipeline. Were you to expand multiple properties, there’d be no way to separate the data in the pipeline.

3

What are you trying to do? Can you provide a scenario?

4

Actually I am writing a production script where I must even log each end every thing. For this I am adding my own results and any other command’s results to a PSObject and finally I want to export the content of this PSObject the log file. If I just (for ex: $Output | Export-CSV log.csv) then it will just export the view of $output but it won’t expand the properties and then export. The below is the sample which is very ideal to my script.

$temp = Get-Service dns*
$temp1 = Get-Process | select -First 5
If($temp.Status -match 'Stop')
{
   $Ouput | Add-Member -MemberType NoteProperty -Name DNSService -Value 'Fail'
}
Else
{
      $Ouput | Add-Member -MemberType NoteProperty -Name DNSService -Value 'Pass'
}
$Ouput | Add-Member -MemberType NoteProperty -Name 'ActualDNSServiceOutput' -Value $temp
$Ouput | Add-Member -MemberType NoteProperty -Name Process -Value $temp1

[attachment file=“Capture.PNG”]

5

Keep in mind you’ve never written $output to the pipeline of your script.

Write-Output $output

If you do that, then you should be able to pipe the script output to Export-CSV and have it work fine. This isn’t “expanding properties.” -ExpandProperty is a completely different thing.

$temp can contain more than one object, potentially; if it does, your if() construct won’t work as expected.

Is $output just a blank PSObject to begin with? I don’t see where you create it.

But your screenshot is something else. That shows your object having a Service property, which is a collection of Process objects, which in turn have their own properties. That’s a hierarchy; there’s no way for a CSV file to represent that. A CSV is a flat file - it doesn’t support a hierarchy of information, which is what you’ve created. There’s no way to make a CSV file work with hierarchical data - that isn’t what it’s for.