SCCM Report to get Primary partition less than 1GB on C: drive

SQL Query :


Select
SD.Name0 'Machine Name',
SD.User_Name0 'User Name',
LD.FreeSpace0 'Free Space'
From v_R_System SD
Join v_Gs_Logical_Disk LD on SD.ResourceId = LD.ResourceId
Where LD.DeviceId0 = 'C:'
And LD.FreeSpace0 < 1024
And SD.Client0 = 1

Tag : Web Report