JDBC Driver for Google Directory

Build 22.0.8462

MobileDevices

Lists mobile devices for an account.

Table Specific Information

Select

To get a list of all mobile 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. The driver processes other queries client-side in memory.

For example, the following query is processed server side by the Google Directory APIs:

SELECT * FROM MobileDevices

Columns

Name Type Description
Id [KEY] String The serial number for a Google Sync mobile device. For Android and iOS devices, this is a software generated unique identifier.
ResourceId String The unique ID the API service uses to identify the mobile device.
Name String List of the owner's usernames.
AccountsList String List of accounts added on device.
Email String List of the owner's emails.
Model String The mobile device's model name.
OS String The mobile device's operating system
Type String The type of mobile device.
Status String The device's status.
HardwareId String The IMEI/MEID unique identifier for Android hardware.
FirstSyncDate Datetime The date and time the device was initially synchronized with the policy settings in the Admin console.
LastSyncDate Datetime The date and time the device was last synchronized with the policy settings in the Admin console.
UserAgent String Gives information about the device such as os version.
SerialNumber String The device's serial number.
IMEI String The device's IMEI number.
MEID String The device's MEID number.
WiFiMacAddress String The device's MAC address on Wi-Fi networks.
NetworkOperator String Mobile Device mobile or network operator.
DefaultLanguage String The default langauge used on the device.
DeviceCompromisedStatus String The compromised device status.
BuildNumber String The device's operating system build number.
KernelVersion String The device's kernel version.
BasebandVersion String The device's baseband version.
Manufacturer String The device's manufacturer.
ReleaseVersion String Mobile Device release version version.
SecurityPatchLevel String The device's security patch level.
Brand String The device's brand.
BootloaderVersion String The device's bootloader version.
Hardware String The device's hardware.
EncryptionStatus String The device's encryption status.
DevicePasswordStatus String The device's password status
Privilege String DMAgentPermission.
UnknownSourcesStatus Boolean Indicates if unknown sources are enabled or disabled on device
AdbStatus Boolean Indicates if adb(USB debugging) is enabled or disabled on device
IsOnOwnerProfile Boolean Indicates if this account is on owner/primary profile or not.
SupportsWorkProfile Boolean Indicates if work profile is supported on device.
Etag String Etag of the resource

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CustomerId String The Id of the customer

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462