Chrome OS Devices Enrolled in the Last 30 Days

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

COPY

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

Show

Hide