Here is a sample report:

Free Space - Offline Defrag Candidates

Freespace is less than 12% and WhiteSpace is greater than 8GB.

 Code:
Select Distinct vol.SystemName0, vol.Label0 [Volume Label], 
   Cast(vol.Capacity0 as money) / 1024 / 1024 [Capacity (GB)], 
   Cast(vol.FreeSpace0 as money) / 1024 / 1024 [FreeSpace (GB)], 
   Cast(wht.FreeSpace0 as money) / 1024 [WhiteSpace (GB)],
   Convert(money,100.0 * vol.FreeSpace0 / vol.Capacity0) [% FreeSpace]
From v_GS_Volume vol
Left Join v_GS_WhiteSpace wht on wht.Label0 = vol.Label0
Where SystemName0 like '%ML%'
   and (vol.Label0 is not null or vol.DriveLetter0 = 'C:')
   and (Convert(float,100.0 * vol.FreeSpace0 / vol.Capacity0)) < 12
   and wht.FreeSpace0 /1024 > 8
Order by vol.SystemName0, vol.Label0