We are trying to generate a custom query report in SDP v7 and we can get all the info we want except the drive info (disk space used). We used the following query for drive info:
select SystemInfo.WORKSTATIONID, DriveInfo.FREESPACE from DriveInfo, SystemInfo where SystemInfo.WORKSTATIONID=DriveInfo.WORKSTATIONID