ChromeOsDevices
Retrieve all Chrome devices for an account.
Table Specific Information
Select
To get a list of all Chrome devices for an account, the CustomerId column is required. It can be set in the connection string or in the WHERE clause condition. If not specified, the CustomerId of the current account will be used.
For example, the following query is processed server side by the Google Directory APIs:
SELECT * FROM ChromeOsDevices
INSERT
INSERTs are not supported for this table.
Update
Updates a device's annotatedUser, annotatedLocation, or notes properties. To update a notification, the following columns are required: CustomerId and Id. If not specified, the CustomerId of the current account will be used.
UPDATE ChromeOsDevices SET AnnotatedUser = 'User_2' WHERE Id = '12345' AND CustomerId = '1234'.
Delete
Deletes are not supported for this table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique ID of the Chrome device. |
| SerialNumber | String | True |
The Chrome device serial number entered when the device was enabled. This value is the same as the Admin console's Serial Number in the Chrome OS Devices tab. |
| Model | String | True |
The device's model information. If the device does not have this information, this property is not included in the response. |
| MEID | String | True |
The Mobile Equipment Identifier (MEID) for the 3G mobile card in a mobile device. A MEID is typically used when adding a device to a wireless carrier's post-pay service plan. If the device does not have this information, this property is not included in the response. |
| LastSync | Datetime | True |
The date and time the device was last enrolled. |
| AnnotatedUser | String | False |
The user of the device as noted by the administrator. Maximum length is 100 characters. Empty values are allowed. |
| AnnotatedLocation | String | False |
The address or location of the device as noted by the administrator. Maximum length is 200 characters. Empty values are allowed. |
| AnnotatedAssetId | String | False |
The asset identifier as noted by an administrator or specified during enrollment. |
| Notes | String | False |
Notes about this device added by the administrator. This property can be searched with the list method's query parameter. Maximum length is 500 characters. Empty values are allowed. |
| OrgUnitPath | String | False |
The full parent path with the organizational unit's name associated with the device. Path names are case insensitive. If the parent organizational unit is the top-level organization, it is represented as a forward slash, /. This property can be updated using the API |
| OrderNumber | String | True |
The device's order number. Only devices directly purchased from Google have an order number. |
| MacAddress | String | True |
The device's wireless MAC address. If the device does not have this information, it is not included in the response. |
| WillAutoRenew | Boolean | True |
Determines if the device will auto renew its support after the support end date. This is a read-only property. |
| OsVersion | String | True |
The Chrome device's operating system version. |
| PlatformVersion | String | True |
The Chrome device's platform version. |
| FirmwareVersion | String | True |
The Chrome device's firmware version. |
| BootMode | String | True |
The boot mode for the device. |
| LastEnrollmentTime | String | True |
The date and time the device was last enrolled. |
| TmpVersionInfoAggr | String | True |
Trusted Platform Module (TPM). |
| ActiveTimeRangesAggr | String | True |
List of active time ranges. |
| RecentUsersAggr | String | True |
List of recent device users, in descending order, by last login time. |
| DeviceFilesAggr | String | True |
List of device files to download. |
| ETag | String | True |
ETag of the resource. |
| Status | String | True |
The status of the device. |
| SupportEndDate | Datetime | True |
The final date the device will be supported. This is applicable only for devices purchased directly from Google. The value is in ISO 8601 date format. |
| Kind | String | True |
The type of the API resource. |
| EthernetMacAddress | String | True |
The MAC address on the ethernet network interface. |
| DiskVolumeReports | String | True |
Reports of disk space and other info about mounted/connected volumes. |
| SystemRamTotal | String | True |
Total RAM on the device in bytes. |
| CpuStatusReports | String | True |
Reports of CPU utilization and temperature. |
| CpuInfo | String | True |
Information regarding CPU specs in the device. |
| SystemRamFreeReports | String | True |
Reports of amounts of available RAM memory. |
| LastKnownNetwork | String | True |
Contains last known network information. |
| EthernetMacAddress0 | String | True |
The MAC address used by the Chromebook's internal ethernet port. The format is twelve hexadecimal digits without any delimiter, using uppercase letters. |
| DockMacAddress | String | True |
Built-in MAC address for the docking station that the device connected to. The format is twelve hexadecimal digits without any delimiter, using uppercase letters. |
| ManufactureDate | Date | True |
The date the device was manufactured in yyyy-mm-dd format. |
| ScreenshotFiles | String | True |
List of screenshot files to download. |
| OrgUnitId | String | True |
The unique ID of the organizational unit. |
| OsUpdateStatusState | String | True |
The update state of an OS update. |
| OsUpdateStatusTargetOsVersion | String | True |
New platform version of the OS image being downloaded and applied. It is only set when update status is UPDATE_STATUS_DOWNLOAD_IN_PROGRESS or UPDATE_STATUS_NEED_REBOOT. |
| OsUpdateStatusTargetKioskAppVersion | String | True |
New required platform version from the pending updated kiosk app. |
| OsUpdateStatusUpdateTime | String | True |
Date and time of the last successful OS update. |
| OsUpdateStatusUpdateCheckTime | String | True |
Date and time of the last update check. |
| OsUpdateStatusRebootTime | String | True |
Date and time of the last reboot. |
| FirstEnrollmentTime | String | True |
Date and time for the first time the device was enrolled. |
| LastDeprovisionTimestamp | String | True |
Date and time for the last deprovision of the device. |
| DeprovisionReason | String | True |
The deprovision reason of the device. |
| DeviceLicenseType | String | True |
Device license type. |
| BacklightInfo | String | True |
Contains backlight information for the device. |
| AutoUpdateThrough | String | True |
The timestamp after which the device will stop receiving Chrome updates or support. |
| ExtendedSupportEligible | Boolean | True |
Whether or not the device requires the extended support opt in. |
| ExtendedSupportStart | String | True |
Date of the device when extended support policy for automatic updates starts. |
| ExtendedSupportEnabled | Boolean | True |
Whether extended support policy is enabled on the device. |
| FanInfo | String | True |
Fan information for the device. |
| ChromeOsType | String | True |
Chrome OS type of the device. |
| DiskSpaceUsageCapacityBytes | String | True |
The total capacity value, in bytes. |
| DiskSpaceUsageUsedBytes | String | True |
The current usage value, in bytes. |
| OsVersionCompliance | String | True |
Device policy compliance status of the OS version. |
| BluetoothAdapterInfo | String | True |
Information about Bluetooth adapters of the device. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| CustomerId | String |
Id of the customer. |