Discussions specific to the VMware vSphere hypervisor
Post Reply
EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

vm snapshot removing duration during backup: sql query

Post by EBoucq » Oct 28, 2015 10:28 am

Hello,

I'm asked to list for each vm Veeam backs up, the duration of snapshot removal.
Is this information stored somewhere in the Veeam database so I can run a query ?

Thanks !!!
Eric

P.Tide
Product Manager
Posts: 4943
Liked: 418 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: vm snapshot removing duration during backup: sql query

Post by P.Tide » Oct 28, 2015 3:08 pm

Hi,

There is an alarm in Veeam ONE Monitor under VMware/Virtual Machine folder which is called "Latest snapshot age" which can be configured to serve for informational purpose. Does that fit your needs? Please describe your use case.

Thank you.

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: vm snapshot removing duration during backup: sql query

Post by EBoucq » Oct 28, 2015 3:20 pm

Hi Pavel,

Among 250 VMs, I need to pick the ones with the longest snapshot removing duration to move their snapshot files to SSD drives.

Thanks,
Eric

P.Tide
Product Manager
Posts: 4943
Liked: 418 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: vm snapshot removing duration during backup: sql query

Post by P.Tide » Oct 28, 2015 3:28 pm

Ok, I see. Please check this article - it describes how to obtain snapshot removal routine info via ESXi commandline, might require some scripting. Search for startTime and completeTime parameters.

Thank you.

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: vm snapshot removing duration during backup: sql query

Post by EBoucq » Oct 28, 2015 3:32 pm

Thank you Pavel !!

Post Reply

Who is online

Users browsing this forum: No registered users and 14 guests