SELECT DISTINCT
 v_GS_COMPUTER_SYSTEM.Name0 AS ‘PC Name’,
 Sum(v_GS_LOGICAL_DISK.Size0) as ‘HD Space’,
 Sum(v_GS_LOGICAL_DISK.FreeSpace0) as ‘HD Free Space’,
 v_GS_COMPUTER_SYSTEM.UserName0 AS ‘Last Logon User’
FROM
 v_GS_SYSTEM left join v_GS_LOGICAL_DISK on v_GS_SYSTEM.resourceid=v_GS_LOGICAL_DISK.resourceid
 LEFT OUTER JOIN v_GS_COMPUTER_SYSTEM ON v_GS_SYSTEM.resourceid = v_GS_COMPUTER_SYSTEM.ResourceID
Group By
 v_GS_COMPUTER_SYSTEM.Name0,
 v_GS_COMPUTER_SYSTEM.UserName0
ORDER BY
 v_GS_COMPUTER_SYSTEM.Name0