Help on creating report query

Hi guys,

I have no experiece in creating query hence I would like to seek your help in doing so.

I have created a report to show me the computer name, model, etc etc but i can't find the hard disk capacity and the freespace.

Here is the query and can some one please add in the two columns for me

SELECT MAX(workstation.WORKSTATIONNAME) "Workstation",MAX(workstation.MANUFACTURER) "Manufacturer",MAX(workstation.MODEL) "Model",MAX(workstation.SERVICETAG) "Service Tag",MAX(memInfo.TOTALMEMORY) "Total Memory",MAX(memInfo.VIRTUALMEMORY) "Virtual Memory" FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN MemoryInfo memInfo ON workstation.WORKSTATIONID=memInfo.WORKSTATIONID WHERE (aaov.NAME = N'DNMY' COLLATE SQL_Latin1_General_CP1_CI_AS) AND ISSERVER=1 GROUP BY workstation.WORKSTATIONID

Thanks a lot