Chrome OS Devices Not Synced in the Last 30 Days Audit

Find Chrome OS Devices with Sync Issues

Chromebooks and other Chrome OS devices regularly sync with the Google admin console for policy settings and more. These syncs ensure that whatever settings you set globally or for specific devices groups, get applied. A failure of devices to sync can also mean that new policies are not being applied. It is therefore important that devices sync regularly, especially after you’ve made changes. The audit below lists all Chromebooks and other Chrome OS devices that have not been synced in the last 30 days. This audit gives you a list of devices that might have sync issues since their last sync was more than a month ago. 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 Synced in the Last 30 Days Query

COPY

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblChromeOs.Status,
  tblChromeOs.OrgUnitPath,
  tblChromeOs.LastSync,
  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 tblChromeOs.LastSync < GetDate() - 30 And tblAssetCustom.State = 1
Order By tblChromeOs.LastSync Desc,
  tblAssets.AssetName

Show

Hide