SMS Client Machines With Less Than 300 MB Free Disk Space On Their Primary Partition

This SQL script will return all of the SMS client machine names and their last logged on user name where their primary C: partition has less than 300 MB of remaining free disk space.

SQL Script:

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 < 300

And SD.Client0 = 1