Skip to content
AWS for Query.Farm

aws.devicefarm.list_devices

Example SQL Queries

SELECT * FROM
aws.devicefarm.list_devices;

Description

Gets information about unique device types.

Table Definition

Column NameColumn Data Type
arn Input Column

The device's ARN.

VARCHAR
filters Input Column

Used to select a set of devices. A filter is made up of an attribute, an operator, and one or more values.

  • Attribute: The aspect of a device such as platform or model used as the selection criteria in a device filter.

    Allowed values include:

    • ARN: The Amazon Resource Name (ARN) of the device (for example, arn:aws:devicefarm:us-west-2::device:12345Example).

    • PLATFORM: The device platform. Valid values are ANDROID or IOS.

    • OS_VERSION: The operating system version (for example, 10.3.2).

    • MODEL: The device model (for example, iPad 5th Gen).

    • AVAILABILITY: The current availability of the device. Valid values are AVAILABLE, HIGHLY_AVAILABLE, BUSY, or TEMPORARY_NOT_AVAILABLE.

    • FORM_FACTOR: The device form factor. Valid values are PHONE or TABLET.

    • MANUFACTURER: The device manufacturer (for example, Apple).

    • REMOTE_ACCESS_ENABLED: Whether the device is enabled for remote access. Valid values are TRUE or FALSE.

    • REMOTE_DEBUG_ENABLED: Whether the device is enabled for remote debugging. Valid values are TRUE or FALSE. Because remote debugging is no longer supported, this attribute is ignored.

    • INSTANCE_ARN: The Amazon Resource Name (ARN) of the device instance.

    • INSTANCE_LABELS: The label of the device instance.

    • FLEET_TYPE: The fleet type. Valid values are PUBLIC or PRIVATE.

  • Operator: The filter operator.

    • The EQUALS operator is available for every attribute except INSTANCE_LABELS.

    • The CONTAINS operator is available for the INSTANCE_LABELS and MODEL attributes.

    • The IN and NOT_IN operators are available for the ARN, OS_VERSION, MODEL, MANUFACTURER, and INSTANCE_ARN attributes.

    • The LESS_THAN, GREATER_THAN, LESS_THAN_OR_EQUALS, and GREATER_THAN_OR_EQUALS operators are also available for the OS_VERSION attribute.

  • Values: An array of one or more filter values.

    • The IN and NOT_IN operators take a values array that has one or more elements.

    • The other operators require an array with a single element.

    • In a request, the AVAILABILITY attribute takes the following values: AVAILABLE, HIGHLY_AVAILABLE, BUSY, or TEMPORARY_NOT_AVAILABLE.

STRUCT(
    "attribute" VARCHAR,
    "operator" VARCHAR,
    "values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].attribute

The aspect of a device such as platform or model used as the selection criteria in a device filter.

The supported operators for each attribute are provided in the following list.

ARN

The Amazon Resource Name (ARN) of the device (for example, arn:aws:devicefarm:us-west-2::device:12345Example).

Supported operators: EQUALS, IN, NOT_IN

PLATFORM

The device platform. Valid values are ANDROID or IOS.

Supported operators: EQUALS

OS_VERSION

The operating system version (for example, 10.3.2).

Supported operators: EQUALS, GREATER_THAN, GREATER_THAN_OR_EQUALS, IN, LESS_THAN, LESS_THAN_OR_EQUALS, NOT_IN

MODEL

The device model (for example, iPad 5th Gen).

Supported operators: CONTAINS, EQUALS, IN, NOT_IN

AVAILABILITY

The current availability of the device. Valid values are AVAILABLE, HIGHLY_AVAILABLE, BUSY, or TEMPORARY_NOT_AVAILABLE.

Supported operators: EQUALS

FORM_FACTOR

The device form factor. Valid values are PHONE or TABLET.

Supported operators: EQUALS

MANUFACTURER

The device manufacturer (for example, Apple).

Supported operators: EQUALS, IN, NOT_IN

REMOTE_ACCESS_ENABLED

Whether the device is enabled for remote access. Valid values are TRUE or FALSE.

Supported operators: EQUALS

REMOTE_DEBUG_ENABLED

Whether the device is enabled for remote debugging. Valid values are TRUE or FALSE.

Supported operators: EQUALS

Because remote debugging is no longer supported, this filter is ignored.

INSTANCE_ARN

The Amazon Resource Name (ARN) of the device instance.

Supported operators: EQUALS, IN, NOT_IN

INSTANCE_LABELS

The label of the device instance.

Supported operators: CONTAINS

FLEET_TYPE

The fleet type. Valid values are PUBLIC or PRIVATE.

Supported operators: EQUALS

filters[].operator

Specifies how Device Farm compares the filter's attribute to the value. See the attribute descriptions.

filters[].values[]
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
availability

Indicates how likely a device is available for a test run. Currently available in the ListDevices and GetDevice API methods.

VARCHAR
carrier

The device's carrier.

VARCHAR
cpu

Information about the device's CPU.

STRUCT(
    "frequency" VARCHAR,
    "architecture" VARCHAR,
    "clock" DOUBLE
)
Show child fields
cpu.architecture

The CPU's architecture (for example, x86 or ARM).

cpu.clock

The clock speed of the device's CPU, expressed in hertz (Hz). For example, a 1.2 GHz CPU is expressed as 1200000000.

cpu.frequency

The CPU's frequency.

fleet_name

The name of the fleet to which this device belongs.

VARCHAR
fleet_type

The type of fleet to which this device belongs. Possible values are PRIVATE and PUBLIC.

VARCHAR
form_factor

The device's form factor.

Allowed values include:

  • PHONE

  • TABLET

VARCHAR
heap_size

The device's heap size, expressed in bytes.

BIGINT
image

The device's image name.

VARCHAR
instances

The instances that belong to this device.

STRUCT(
    "arn" VARCHAR,
    "device_arn" VARCHAR,
    "labels" VARCHAR[],
    "status" VARCHAR,
    "udid" VARCHAR,
    "instance_profile" STRUCT(
        "arn" VARCHAR,
        "package_cleanup" BOOLEAN,
        "exclude_app_packages_from_cleanup" VARCHAR[],
        "reboot_after_use" BOOLEAN,
        "name" VARCHAR,
        "description" VARCHAR
    )
)[]
Show child fields
instances[]
Show child fields
instances[].arn

The Amazon Resource Name (ARN) of the device instance.

instances[].device_arn

The ARN of the device.

instances[].instance_profile

A object that contains information about the instance profile.

Show child fields
instances[].instance_profile.arn

The Amazon Resource Name (ARN) of the instance profile.

instances[].instance_profile.description

The description of the instance profile.

instances[].instance_profile.exclude_app_packages_from_cleanup[]
instances[].instance_profile.name

The name of the instance profile.

instances[].instance_profile.package_cleanup

When set to true, Device Farm removes app packages after a test run. The default value is false for private devices.

instances[].instance_profile.reboot_after_use

When set to true, Device Farm reboots the instance after a test run. The default value is true.

instances[].labels[]
instances[].status

The status of the device instance. Valid values are listed here.

instances[].udid

Unique device identifier for the device instance.

manufacturer

The device's manufacturer name.

VARCHAR
memory

The device's total memory size, expressed in bytes.

BIGINT
model

The device's model name.

VARCHAR
model_id

The device's model ID.

VARCHAR
name

The device's display name.

VARCHAR
os

The device's operating system type.

VARCHAR
platform

The device's platform.

Allowed values include:

  • ANDROID

  • IOS

VARCHAR
radio

The device's radio.

VARCHAR
remote_access_enabled

Specifies whether remote access has been enabled for the specified device.

BOOLEAN
remote_debug_enabled

This flag is set to true if remote debugging is enabled for the device.

Remote debugging is no longer supported.

BOOLEAN
resolution

The resolution of the device.

STRUCT(
    "width" BIGINT,
    "height" BIGINT
)
Show child fields
resolution.height

The screen resolution's height, expressed in pixels.

resolution.width

The screen resolution's width, expressed in pixels.