SELECT
CS.Name0,
LD.DeviceID0,
(LD.Size0 – LD.FreeSpace0) as Used
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_LOGICAL_DISK LD
WHERE
LD.ResourceID = CS.ResourceID
AND LD.DriveType0=3