topic Re: List snapshots older than and only powered on VM in VMware PowerCLI Discussions

List snapshots older than and only powered on VM

fborges555 — Tue, 27 Jul 2021 13:11:17 GMT

Hi gurus

I want a list of all powered ON vm with snapshot older than 5 days, I have the following but as you can tell still curving some learning

$PowONvm = Get-VM |where {$_.powerstate -eq "PoweredOn"}| Get-Snapshot | Where {$_.Created -lt (Get-Date).AddDays(-5)} |select vm,name,powerstate

This bring powered off and on vm , can someone help on where I went wrong.

Thanks

Re: List snapshots older than and only powered on VM

LucD — Tue, 27 Jul 2021 13:22:17 GMT

The object returned by Get-Snapshot contains a property named VM, under which you find the same object that is returned by Get-VM.
So you could do

Get-VM | Get-Snapshot | where {$_.VM.powerstate -eq "PoweredOn" -and $_.Created -lt (Get-Date).AddDays(-5)} | select vm,name,powerstate

Re: List snapshots older than and only powered on VM

fborges555 — Tue, 27 Jul 2021 13:35:50 GMT

for some reason it bring the off and on VM

Thanks

Re: List snapshots older than and only powered on VM

LucD — Tue, 27 Jul 2021 13:50:59 GMT

That PowerState is the state the VM was in when the snapshot was taken.
When you want to see the current powerstate you can do

Get-VM | Get-Snapshot | where {$_.VM.powerstate -eq "PoweredOn" -and $_.Created -lt (Get-Date).AddDays(-5)} | select @{N='VM';E={$_.VM.Name}},Name,@{N='PowerState';E={$_.VM.PowerState}}

Re: List snapshots older than and only powered on VM

rictusempra — Mon, 25 Jul 2022 11:10:35 GMT

Hi LucD,

can you help me out on how to use this query for the current powerstate in this script?

Re: List snapshots older than and only powered on VM

LucD — Mon, 25 Jul 2022 11:36:29 GMT

You could do something like this

Get-VM | Get-Snapshot | select @{N='VM';E={$_.VM.Name}}, @{N='Current PowerState';E={$_.VM.PowerState}}, Name, @{N='PowerState';E={$_.VM.PowerState}}