By: Gordon Rankine
Published: 24 Apr 2014 22:45
This is a simple MSSQL script to list all snapshots in your VMWare environment. Just copy the code below into SQL Server Management Studio (SSMS) and run against your VMware virtual infrastructure database.
INNER JOIN vpx_entity
ORDER BY name, snapshot_name
The column is_current_snapshot will either have a value of 1 (current snapshot) or 0 (not the current snapshot).
Please note: This has only been tested against vSphere version 4. Other versions may be different.
The results will look similar to the screenshot below:
Disclaimer: This script is provided as is without any warranty. You are responsible for running this script and I will not be held accountable for any data loss or issues arising from this script.
Share This Post
TagsBack to Technology