Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
Lists the 10 Windows server disk drives with the least free disk space percentage.

Select Top 10 tblAssets.AssetName + ' ' + tblDiskdrives.Caption As Drive,
Ceiling(Max(tblDiskdrives.Freespace) / Max(tblDiskdrives.Size) *
100) As number
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3 And tblDiskdrives.Size Is Not Null And
tblDiskdrives.Size Is Not Null
Group By tblAssets.AssetName + ' ' + tblDiskdrives.Caption
Order By number

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now