Jetzt Ausprobieren

Chrome OS Devices with Less Than 10% Free Disk Space Audit

Hardware Hardware Components

Discover All Chrome OS Devices with Low Free Disk Space

Regardless of the type of device you have, ensuring that they have sufficient free disk space is always required. Applications and users rely on having enough disk space to store data and files and a lack of disk space can cause applications to stop working, give errors and ultimately cause users to either waste time clearing up space or asking someone else to do it for them. To prevent these issues, this audit lists all Chrome OS devices which have less than 10% free disk space. You can identify which devices are low on free disk space and need to be looked at. With the use of email alerts, you can even get notified when Chrome OS devices run low on free disk space instead of having to run the audit manually. Chrome OS less than 10 percent disk space

Chrome OS Less than 10% free Query

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

Show

Hide