VMAN - VMs by Snapshot Disk Usage

Hi All,

Using SWQL to get the snapshots disk usage.  This has the same as in built-in widget, but can be customized to include or exclude additional information.

SELECT top 10
[Name]
,[PowerState]
,case when SnapshotStorageSize/1024/1024/1024>1 then concat(SnapshotStorageSize/1024/1024/1024,' GB')
when SnapshotStorageSize/1024/1024>1 then concat(SnapshotStorageSize/1024/1024,' MB')
when SnapshotStorageSize/1024>1 then concat(SnapshotStorageSize/1024,' KB')
else concat(SnapshotStorageSize,' B') end as [Size]
,[SnapshotSummaryCount] as [NumofSnapshots]
FROM [VIM_VirtualMachines]
where SnapshotSummaryCount>0
order by SnapshotStorageSize desc

Thank you,

Amit

Loop1 Systems