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% 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
