How to write the query for Hard disk space for all SCCM Workstations in SCCM 2007 console

Can you pls help me out for this

Thanx!

this will get you started.

http://smsug.ca/blogs/garth_jones/archive/2007/02/14/159.aspx

http://smsug.ca/blogs/garth_jones/archive/2007/02/15/160.aspx

Display Machines With A Specified Percentage Of Free Local Disk Space

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

For more info, you can check below link

https://vasanthsccm.wordpress.com/2012/02/10/sql-queries-for-sccm/