ODBC Driver for Google Directory

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062