gistfile1.txt

SELECT
    ServerObject.Name,
    storageYesterday.Committed AS committedYesterday,
    storageToday.Committed AS committedToday,
    ROUND((storageToday.Committed - storageYesterday.Committed) / 1073741824) AS DifferenceGB
FROM
    ServerObject
LEFT OUTER JOIN
    StorageUsedByVm AS storageYesterday ON
        storageYesterday.VcenterId = ServerObject.VcenterId
        AND storageYesterday.Date = CURRENT_DATE() - INTERVAL 1 DAY
LEFT OUTER JOIN
    StorageUsedByVm AS storageToday ON
        storageToday.VcenterId = ServerObject.VcenterId
        AND storageToday.Date = CURRENT_DATE()
WHERE
    ServerObject.Disabled = 0
GROUP BY
    ServerObject.VcenterId
ORDER BY
    DifferenceGB DESC
LIMIT
    5