SQL for Disks space

Select v_R_System.name0,

v_R_System.Resource_Domain_OR_Workgr0 as Domain,
v_GS_LOGICAL_DISK.FreeSpace0,
v_GS_LOGICAL_DISK.Size0,
v_GS_LOGICAL_DISK.Caption0,
v_GS_LOGICAL_DISK.DriveType0,
v_R_System.Last_Logon_Timestamp0

from v_R_System

inner Join v_GS_LOGICAL_DISK on v_GS_LOGICAL_DISK.ResourceID = v_R_System.ResourceID

where v_GS_LOGICAL_DISK.DriveType0 = '3'
order by v_R_System.name0