Generate list of Linux & Windows VMs, sort by memory size

[wk0812]

I would like to generate separate list of Windows VM and Linux (non-windows) VM with the following properties:

memory, cpu, total consumed storage size (not provision HDD size but what is being used).

Thank you!

[LucD]

What do you already have?

[wk0812]

Well, I've started with getting the total storage used by windows(or non-windows) VM with this.

((get-vm | Where-object{$_.Guest.OSFullName -like "*Windows*"}).UsedSpaceGB | measure-Object -Sum).Sum

I need to generate a list of VM, sorted by memory and include CPU count and total space used by each VM.

 

thank you!

[wk0812]

Think I put together something close to what I am looking for but need a little tweak.

Get-VM |
Where-object{$_.Guest.OSFullName -like "*Windows*"}|
select @{N='VM';E={$_.Name}},

NumCpu,MemoryGB,

@{N='CapacityGB';E={(Get-HardDisk -VM $_).CapacityGB -join ','}} |

Format-Table -AutoSize

 

1. how can I sort the list by memory size?

2. for disk size, how can this be changed to total consumed?  above shows each disk size and i need actual space used.

 

thank you.

[LucD]

The object returned by Get-VM already has a property named UsedSpaceGB.
But you can also use the Measure-Object cmdlet.

Sorting is just piping the objects to Sort-Object and specifying the property on which to sort.

Get-VM |
Where-object{$_.Guest.OSFullName -like "*Windows*"}|
select @{N='VM';E={$_.Name}},
NumCpu,MemoryGB,
UsedSpaceGB,
@{N='CapacityGB';E={ (Get-HardDisk -VM $_ | Measure-Object -Property CapacityGB -Sum).Sum}} |
Sort-Object -Property MemoryGB |
Format-Table -AutoSize

 

[wk0812]

Thank you LucD!

Is there way to round up (or truncate) decimal output to 2 places for MemoryGB, UsedSpaceGB, CapacityGB

 

[LucD]

Sure, use the Math method Round in a calculated property.
For example

@{N='UsedSpaceGB';E={[math]::Round($_.UsedSpaceGB,2)}},

 

[wk0812]

Perfect.  This is what I needed.  Got rid of the decimals and rounded up to whole number. much cleaner!

Get-VM |
Where-object{$_.Guest.OSFullName -like "*Windows*"}|
select @{N='VM';E={$_.Name}},
NumCpu,
@{N='MemoryGB';E={[math]::Round($_.MemoryGB)}},
@{N='UsedSpaceGB';E={[math]::Round($_.UsedSpaceGB)}},
@{N='CapacityGB';E={[math]::Round((Get-HardDisk -VM $_ | Measure-Object -Property CapacityGB -Sum).Sum)}} |
Sort-Object -Property MemoryGB |
Format-Table -AutoSize

One last question, looking at the VM and verifying the "CapacityGB" and "UsedSpaceGB", I'm noticing that the VM is showing more space available than what the "UsedSpaceGB" output is reporting.  That is, for example, output shows capacity at 50gb and usage close to 50gb. however when I do a visual check on the VM itself, it shows drive only at 35gb used.  Where is the discrepancy coming from?

thank you.

[LucD]

Have a look at Solved: Re: Meaning of usedspaceGB - VMware Technology Network VMTN

That might explain what you are seeing.