Chrome OS Devices Not on the Highest OS Version Audit

Find Outdated Chrome OS Devices

Operating systems of all devices get regular updates to add new features, improve stability, address issues and fix security vulnerabilities. Ensuring that your devices’ operating systems are up-to-date is critical for both the end-user of the devices and the security of your network. The audit below lists all Chrome OS devices like Chromebooks, which are running an operating system version lower than the highest scanned operating system version within your environment. Once one device is updated, all other, outdated devices will be listed. This gives you an overview of all outdated devices which still need the update. By using the email alert feature, you can also get alerted when outdated devices are detected instead of running the audit manually.

Chrome OS Not on highest OS version Query

COPY

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblChromeOs.Status,
  tblChromeOs.OrgUnitPath,
  tblChromeOs.OsVersion,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblChromeOs
  Inner Join tblAssets On tblAssets.AssetID = tblChromeOs.AssetId
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And Replace(tblChromeOs.OsVersion, '.',
  '') Not In (Select Max(Replace(tblChromeOs.OsVersion, '.', ''))
      From tblChromeOs)
Order By tblAssets.AssetName

Show

Hide