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
