Hey guys I see very limited information about quering the SQL DB so I thought I would share.
Here is a SQL Query to find all VMs with Snapshots older than 30 days. Use if you wish, keep the negative comments to yourself.
Thanks!
Select
EN.Name as VM_NAME,
F.NAME AS CLUSTER_NAME,
S.SNAPSHOT_NAME,
S.SNAPSHOT_DESC,
S.CREATE_TIME
From
VPX_ENTITY EN
INNER JOIN VPX_VM V on EN.ID = V.ID
INNER JOIN VPXV_HOSTS H ON V.HOST_ID = H.HOSTID
Inner join VPXV_COMPUTE_RESOURCE F on H.FARMID = F.RESOURCEPOOLID
inner join [VPX_SNAPSHOT] S on S.VM_ID = V.ID
Where create_time < DATEADD (d,-30,getdate())
Order by CREATE_TIME asc