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