Percentage free space

SELECT LD.SystemName0,
Sum((LD.FreeSpace0+1)*100)/ sum(LD.Size0) ‘Percentage free space’
FROM v_GS_LOGICAL_DISK LD
WHERE LD.DriveType0=3
Group by LD.SystemName0

Leave a Reply

Your email address will not be published. Required fields are marked *