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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CustomerId | String |
Id of the customer |