VM and snapshot, how to know if a vm owns a snapshot ?

[zemotard]

Hi, how can I know kickly if a vm owns a snapshot without to click on each vm ?

Regards

[Dave_Mishchenko]

Take a look at this utility: http://www.vmware.com/community/thread.jspa?threadID=101047&messageID=740048#740048

[zemotard]

Thanks, but nothing integreted with VIC ?

[Dave_Mishchenko]

Not sure of anything to plug into the VC interface, but you could query this VC database table:

VPX_SNAPSHOT – Used to store snapshot information for VM’s. This table has 11 columns (id, host snapshot id, vm id, snapshot name, snapshot desc, create time, power state, is quiesced, parent snapshot id, is current snapshot, config) and will have a row for as many snapshots that exist for your VM’s.

[Bastien_P]

I use the snaps.vbs script from Vmware-land. It's simple, fast and to the point. You get the host, the vm, the date that the snapshot was created (very important in my point of view!)...

somehting like this:

ESX Host Name VM Name Create date/time Current? Memory?

\----

---

vmlab01 Oratest 8/27/2007 10:57:03 AM No No

vmlab01 Oratest 8/27/2007 1:21:04 PM No No

vmlab01 Oratest 8/28/2007 3:55:45 PM Yes No

vmlab01 Zen7ServerLab 9/11/2007 1:48:31 PM No No

vmlab01 Zen7ServerLab 9/12/2007 12:40:30 PM No No

vmlab01 Zen7ServerLab 9/12/2007 3:54:17 PM No No

vmlab01 Zen7ServerLab 9/17/2007 9:34:17 AM Yes No

The vbs was kinda a simple to configure.... you simply edit to point to your sql database and give a adminname/pw...

http://vmware-land.com/downloads/Snaps.vbs