I am running the following to get some value on the VM,s Need to get the resource pool to which the VM's belongs too. tried using Resourcepool using select but doesnt seems to working
Get-VM |
Select-Object Name,MemoryGB,NumCPU,ResourcePool
@{Name="CPU Limit";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Limit}},
@{Name="CPU Reservation";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Reservation}},
@{Name="Mem Limit";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Limit}},
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}} | Export-CSV C:\Scripts\VM.csv -NoTypeInformation -UseCulture
Try adding
@{N="ResourcePool";E={Get-ResourcePool -VM $_ | Select -ExpandProperty Name}}
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Hi LucD,
when i tried to execute the script the output shows incomplete.
Get-VM |
Select-Object Name,MemoryGB,NumCPU,ResourcePool
@{Name="CPU Limit";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Limit}},
@{Name="CPU Reservation";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Reservation}},
@{Name="Mem Limit";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Limit}},
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}}
@{N="ResourcePool";E={Get-ResourcePool -VM $_ | Select -ExpandProperty Name}} | Export-CSV C:\temp\VM.csv -NoTypeInformation -UseCulture
Output in csv :-
IsReadOnly | IsFixedSize | IsSynchronized | Keys | Values | SyncRoot | Count |
FALSE | FALSE | FALSE | System.Collections.Hashtable+KeyCollection | System.Collections.Hashtable+ValueCollection | System.Object | 2 |
thanks
vmk2014
I think there is a comma missing at the end of the line before last
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}},
@{N="ResourcePool";E={Get-ResourcePool -VM $_ | Select -ExpandProperty Name}} | Export-CSV C:\temp\VM.csv -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Hi LucD,
Please find the script which i am using
Get-VM |
Select-Object Name,MemoryGB,NumCPU,ResourcePool
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}},
@{Name="CPU Reservation";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Reservation}},
@{Name="Mem Limit";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Limit}},
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}}
@{N="ResourcePool";E={Get-ResourcePool -VM $_ | Select -ExpandProperty Name}} | Export-CSV C:\temp\VM.csv -NoTypeInformation -UseCulture
while running the script its shows in powercli interface but in csv its shows diffrent output which i attached in earlier post also.
Output in csv format is
IsReadOnly | IsFixedSize | IsSynchronized | Keys | Values | SyncRoot | Count |
FALSE | FALSE | FALSE | System.Collections.Hashtable+KeyCollection | System.Collections.Hashtable+ValueCollection | System.Object | 2 |
thanks
vmk2014
Did you already try adding that comma at the end of the 2nd to last line ?
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Hi,
Please find the script which i am using.
Get-VM |
Select-Object Name,MemoryGB,NumCPU,ResourcePool
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}},
@{Name="CPU Reservation";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Reservation}},
@{Name="Mem Limit";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Limit}},
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}},
@{N="ResourcePool";E={Get-ResourcePool -VM $_ | Select -ExpandProperty Name}} | Export-CSV C:\temp\VM.csv -NoTypeInformation -UseCulture
still same output
thanks
vmk2014.
Hello!
Did you find what the error was?
I am trying to do the same script...
Thanks!
This works (ResourcePool is a property on the VirtualMachine object, provided your PowerCLI is recent).
Get-VM |
Select-Object Name,MemoryGB,NumCPU,ResourcePool,
@{Name="Mem Reservation";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Reservation}},
@{Name="CPU Reservation";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Reservation}},
@{Name="Mem Limit";Expression={$_.ExtensionData.ResourceConfig.MemoryAllocation.Limit}},
@{Name="CPU Limit";Expression={$_.ExtensionData.ResourceConfig.CpuAllocation.Limit}} |
Export-CSV C:\temp\VM.csv -NoTypeInformation -UseCulture
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
Thanks a lot LucD, it worked!!