List Enrolled Chrome OS Devices in the Last Month
To manage Chromebooks and other Chrome OS devices within your environment using the Google admin console, they must first be enrolled. This can be either done by admins or by the user themselves. Once a Chromebook or Chrome OS devices has been listed, device policies can also start taking effect. This overview lists all Chromebooks and other Chrome OS devices that have been listed in the last 30 days. This gives you a list of all new Chrome OS devices in the last month and gives you access to all their scanned details.
By using the email alert feature, you can also get an alert every month with the overview instead of running the audit manually.
Chrome OS Not Synced in the Last 30 Days Query
Select Top 1000000 tblAssets.AssetID, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetName, tblChromeOs.Status, tblChromeOs.OrgUnitPath, tblChromeOs.LastEnrollmentTime, 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.LastEnrollmentTime > GetDate() - 30 And tblAssetCustom.State = 1 Order By tblChromeOs.LastEnrollmentTime Desc, tblAssets.AssetName