VCD 8.2 VM & vAPP Owner Report

[BG_ESET]

Hi All, Anyone have an updated version of this script? Appreciate the help!

$CIvApp = get-CIvApp

$CIvms = $CIvApp | get-CIvm 

$report = @() 

foreach($vm in $CIvms){ 

$row = "" | Select "Name", "CIVApp", "Org", "Status", "Operating System", "CpuCount", "Memory (GB)", "Owner" 

   $row."Name" = $vm.Name 

   $row."CIvapp" = $CIVapp.Name 

   $row."Org" = $CIVapp.Org.Name 

   $row."Status" = $CIVapp.Status 

   $row."Operating System" = $vm.GuestOSFullName 

   $row."CpuCount" = $vm.CpuCount 

   $row."Memory (GB)" = ($vm | Measure-Object -Property MemoryMB -Sum).Sum/1024 

   $row."Owner" = $CIvapp.Owner.Name 

   $report += $row 

} 

$report | export-csv C:\tmp\VcloudVMsNEW.csv

[BG_ESET]

The results come out as below with System.Object and do not pull the details..

Name	CIVApp	Org	Status	Operating System	CpuCount	Memory (GB)	Owner
svr2012r2	System.Object[]	System.Object[]	System.Object[]	Microsoft Windows Server 2012 (64-bit)	2	4	System.Object[]
svr2012r2	System.Object[]	System.Object[]	System.Object[]	Microsoft Windows Server 2012 (64-bit)	2	4	System.Object[]
svr2012r2	System.Object[]	System.Object[]	System.Object[]	Microsoft Windows Server 2012 (64-bit)	2	4	System.Object[]
Server_2012_R2_Update_x64	System.Object[]	System.Object[]	System.Object[]	Microsoft Windows Server 2012 (64-bit)	2	4	System.Object[]

[LucD]

The Export-Csv cmdlet can't handle properties that are arrays (multiple values).

Try like this

$CIvApp = get-CIvApp

$CIvms = $CIvApp | get-CIvm

$report = @()

foreach($vm in $CIvms){

   $row = "" | Select "Name", "CIVApp", "Org", "Status", "Operating System", "CpuCount", "Memory (GB)", "Owner"

   $row."Name" = $vm.Name

   $row."CIvapp" = $CIVapp.Name -join '|'

   $row."Org" = $CIVapp.Org.Name -join '|'

   $row."Status" = $CIVapp.Status -join '|'

   $row."Operating System" = $vm.GuestOSFullName

   $row."CpuCount" = $vm.CpuCount

   $row."Memory (GB)" = ($vm | Measure-Object -Property MemoryMB -Sum).Sum/1024

   $row."Owner" = $CIvapp.Owner.Name

   $report += $row

}

$report | export-csv C:\tmp\VcloudVMsNEW.csv

[BG_ESET]

Thank you Luc!! Appreciate the quick response.

Know of a way to get the vAPP Owner Property come through the report?

Im still getting a System.Object[] value come through on the report..

Thanks Again!

[LucD · Accepted solution]

You can do the same

$row."Owner" = $CIvapp.Owner.Name -join '|'

[BG_ESET]

Thanks Luc!! As always, you nailed it.