This SQL server script will display machines with a specified percentage of free local disk free space available.
Select
SD.Name0 'Machine Name',
LD.DeviceID0 Drive,
LD.FileSystem0 'File System',
LD.Size0 'Total Drive Size',
LD.FreeSpace0 'Total Free Space',
LD.FreeSpace0 *100/ LD.Size0 'Percent Free'
From System_Disc SD, Logical_Disk_Data LD
Where SD.ItemKey = LD.MachineId
And LD.Description0 = 'Local Fixed Disk'
/* Change <xx Below To The Percentage Of Free Disk Space You Wish To Find.
Examples: <05 Will Return 5% Free And <10 Will Display 10% Free. */
And LD.FreeSpace0 *100/ LD.Size0 <20
Order By SD.Name0 Asc
No Comments