‎10-11-2017 09:17 PM
Solved! Go to Solution.
‎10-12-2017 07:17 PM
Where
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) < 1024
Where
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <(20 * 1024)
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As free
‎10-12-2017 07:17 PM
Where
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) < 1024
Where
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <(20 * 1024)
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As free
‎10-12-2017 02:36 PM
‎10-11-2017 11:37 PM
Where
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) < 1024
And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0
And tblComputersystem.Domainrole > 1
And tblDiskdrives.DriveType = 3
And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now