Powershell - Change format of output

Question

How can I change the presenation of the output my code produces:

$apps = Import-CSV apps.csv
$computers = Import-CSV compobj.csv
foreach($computer in $computers) {    
    $computerLob = $computer.lob
    $lobApps = $apps | ? {$_.lob -eq $computerLob }
    foreach($app in $lobApps){
       $computerHostname = $computer.hostname
       $appLocation = $app.location
       $installed=Test-Path "\\$computerHostname\$appLocation"      
       New-Object PSObject @{Computer=$computer.hostname;App=$app.appname;Installed=$installed} 
    }
}

I would like for the presentation of the code to be changed. This is how it looks like:

Name                         Value                                                                                                            
----                         -----                                                                                                            
Installed                    True                                                                                                             
App                          App1                                                                 
Computer                     171.159.192.10
Installed                    True                                                                                                             
App                          App2                                                                         
Computer                     171.159.192.10

I'd like for it to look like this:

Computer                 App1    App2
-----------              ------    -----
171.159.192.10           True     True

Joey · Accepted Answer · 2013-10-27 22:20:39Z

2

You're passing the hashtable to New-Object as its ctor argument instead of a property set. Change it to:

New-Object PSObject -Property @{
  Computer=$computer.hostname
  App=$app.appname
  Installed=$installed
}

answered Oct 27, 2013 at 22:20

Joey

357k88 gold badges705 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

theshizy Over a year ago

Thanks a lot. Having the same issue as above. I'm getting the columns in the following order Installed,App,Computer - can I have it in the following order: Computer,App,Installed.

Victor Zakharov Over a year ago

@Antoine-LaurentLavoisier: Can't you pick any order with select statement in Powershell?

theshizy Over a year ago

@Neolisk - can you show me a quick example please. Not sure how it works when you create an new object. I've been trying to switch the order in -Property @{...}

Victor Zakharov Over a year ago

@Antoine-LaurentLavoisier: Whichever is not captured, is delivered onto a pipeline. Wrap your code into a function, call this function from your main code, then add a | select Computer,App,Installed to that. Does it make sense to you?

theshizy Over a year ago

@Neolisk Unfortunately not :(. I'm fairly new to all this. Can you show me what you mean?

Keith Hill · Accepted Answer · 2013-10-28 03:30:56Z

1

If you are on PowerShell V3, rather than use new-object you can do this:

[pscustomobject]@{Computer=$computer.hostname;App=$app.appname;Installed=$installed}

On V2, don't forget to use the -Property parameter e.g.:

new-object psobject -property @{Computer=$computer.hostname;App=$app.appname;Installed=$installed}

And to force the output order you can use Format-Table:

$obj = new-object psobject -property @{Computer=$computer.hostname;App=$app.appname;Installed=$installed} 
$obj | Format-Table Computer,App,Installed

edited Oct 28, 2013 at 3:30

answered Oct 27, 2013 at 22:20

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

2 Comments

theshizy Over a year ago

This works great! But I'm getting the columns in the following order Installed,App,Computer - can I have it in the following order: Computer,App,Installed. Tried playing around with the order of everything but it doesn't seem to work!

Keith Hill Over a year ago

Interesting, I get the properties in that order on my system with PowerShell v4 now. You can always use Format-Table to select the specific order you want new-object ... | Format-Table Computer,App,Installed.

Victor Zakharov · Accepted Answer · 2013-10-28 00:11:53Z

Here is what I mean (a follow-up to OP's question asked in comments, too big to fit there):

function MyFunction(){
  $apps = Import-CSV apps.csv
  $computers = Import-CSV compobj.csv
  foreach($computer in $computers) {    
    $computerLob = $computer.lob
    $lobApps = $apps | ? {$_.lob -eq $computerLob }
    foreach($app in $lobApps){
      $computerHostname = $computer.hostname
      $appLocation = $app.location
      $installed=Test-Path "\\$computerHostname\$appLocation"      
      New-Object PSObject @{Computer=$computer.hostname;App=$app.appname;Installed=$installed} 
    }
  }
}

MyFunction | select Computer,App,Installed

A reduced test case to prove the above should work:

function MyFunction(){
  New-Object PSObject -Property @{
    Computer="computer"
    App="app"
    Installed="installed"
  }
}

MyFunction | select Computer,App,Installed

Collectives™ on Stack Overflow

Powershell - Change format of output

3 Answers 3

5 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related