Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblChromeOs.Status,
  tblChromeOs.OrgUnitPath,
  tblChromeOsVolume.VolumeId,
  Cast(Cast(tblChromeOsVolume.StorageFree As BIGINT) / (1024.0 * 1024.0 *
  1024.0) As DECIMAL(10,2)) As [StorageFree (GB)],
  Cast(Cast(tblChromeOsVolume.StorageTotal As BIGINT) / (1024.0 * 1024.0 *
  1024.0) As DECIMAL(10,2)) As [StorageTotal (GB)],
  Cast(Cast(Cast(tblChromeOsVolume.StorageFree As FLOAT) /
  Cast(tblChromeOsVolume.StorageTotal As FLOAT) * 100 As DECIMAL(10,0)) As
  NVARCHAR) + '%' As [StorageFree (%)],
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblChromeOs
  Inner Join tblAssets On tblAssets.AssetID = tblChromeOs.AssetId
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblChromeOsVolume On tblChromeOsVolume.ChromeOsId =
    tblChromeOs.ChromeOsId
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where Cast(Cast(tblChromeOsVolume.StorageFree As FLOAT) /
  Cast(tblChromeOsVolume.StorageTotal As FLOAT) * 100 As DECIMAL(10,0)) < 10 And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName