SCCM Disk space for all servers IN C:

SELECT DISTINCT VFCM.Name,VGL.DeviceID0, VGL.Description0, VGL.VolumeName0,
VGL.FreeSpace0 as [Free(MB)],
VGL.FreeSpace0/1024 as [Free(GB)],
VGL.Size0/1024 as [Total(GB)],
VGL.FreeSpace0*100/VGL.Size0 AS X
FROM[dbo].v_FullCollectionMembership VFCM
JOIN [dbo].v_GS_LOGICAL_DISK VGL on VFCM.ResourceID = VGL.ResourceID
JOIN[dbo].v_R_System VRS ON VFCM.ResourceID = VRS.ResourceID
WHERE
VGL.DriveType0 =3
AND VGL.DeviceID0 = 'C:'
ORDER BY VFCM.Name, VGL.DeviceID0