Skip to content
AWS for Query.Farm

aws.iotwireless.get_wireless_device

Example SQL Queries

SELECT * FROM
aws.iotwireless.get_wireless_device
WHERE
"identifier" = 'VALUE'
AND "identifier_type" = 'VALUE';

Description

Gets information about a wireless device.

Table Definition

Column NameColumn Data Type
identifier Required Input Column

The identifier of the wireless device to get.

VARCHAR
identifier_type Required Input Column

The type of identifier used in identifier.

VARCHAR
_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
arn

The Amazon Resource Name of the resource.

VARCHAR
description

The description of the resource.

VARCHAR
destination_name

The name of the destination to which the device is assigned.

VARCHAR
id

The ID of the wireless device.

VARCHAR
lo_ra_wan

Information about the wireless device.

STRUCT(
    "dev_eui" VARCHAR,
    "device_profile_id" VARCHAR,
    "service_profile_id" VARCHAR,
    "otaa_v1_1" STRUCT(
        "app_key" VARCHAR,
        "nwk_key" VARCHAR,
        "join_eui" VARCHAR
    ),
    "otaa_v1_0_x" STRUCT(
        "app_key" VARCHAR,
        "app_eui" VARCHAR,
        "join_eui" VARCHAR,
        "gen_app_key" VARCHAR
    ),
    "abp_v1_1" STRUCT(
        "dev_addr" VARCHAR,
        "session_keys" STRUCT(
            "f_nwk_s_int_key" VARCHAR,
            "s_nwk_s_int_key" VARCHAR,
            "nwk_s_enc_key" VARCHAR,
            "app_s_key" VARCHAR
        ),
        "f_cnt_start" BIGINT
    ),
    "abp_v1_0_x" STRUCT(
        "dev_addr" VARCHAR,
        "session_keys" STRUCT(
            "nwk_s_key" VARCHAR,
            "app_s_key" VARCHAR
        ),
        "f_cnt_start" BIGINT
    ),
    "f_ports" STRUCT(
        "fuota" BIGINT,
        "multicast" BIGINT,
        "clock_sync" BIGINT,
        "positioning" STRUCT(
            "clock_sync" BIGINT,
            "stream" BIGINT,
            "gnss" BIGINT
        ),
        "applications" STRUCT(
            "f_port" BIGINT,
            "type" VARCHAR,
            "destination_name" VARCHAR
        )[]
    )
)
Show child fields
lo_ra_wan.abp_v1_0_x

LoRaWAN object for create APIs

Show child fields
lo_ra_wan.abp_v1_0_x.dev_addr

The DevAddr value.

lo_ra_wan.abp_v1_0_x.f_cnt_start

The FCnt init value.

lo_ra_wan.abp_v1_0_x.session_keys

Session keys for ABP v1.0.x

Show child fields
lo_ra_wan.abp_v1_0_x.session_keys.app_s_key

The AppSKey value.

lo_ra_wan.abp_v1_0_x.session_keys.nwk_s_key

The NwkSKey value.

lo_ra_wan.abp_v1_1

ABP device object for create APIs for v1.1

Show child fields
lo_ra_wan.abp_v1_1.dev_addr

The DevAddr value.

lo_ra_wan.abp_v1_1.f_cnt_start

The FCnt init value.

lo_ra_wan.abp_v1_1.session_keys

Session keys for ABP v1.1

Show child fields
lo_ra_wan.abp_v1_1.session_keys.app_s_key

The AppSKey value.

lo_ra_wan.abp_v1_1.session_keys.f_nwk_s_int_key

The FNwkSIntKey value.

lo_ra_wan.abp_v1_1.session_keys.nwk_s_enc_key

The NwkSEncKey value.

lo_ra_wan.abp_v1_1.session_keys.s_nwk_s_int_key

The SNwkSIntKey value.

lo_ra_wan.dev_eui

The DevEUI value.

lo_ra_wan.device_profile_id

The ID of the device profile for the new wireless device.

lo_ra_wan.f_ports

List of FPort assigned for different LoRaWAN application packages to use

Show child fields
lo_ra_wan.f_ports.applications[]
Show child fields
lo_ra_wan.f_ports.applications[].destination_name

The name of the position data destination that describes the AWS IoT rule that processes the device's position data for use by AWS IoT Core for LoRaWAN.

lo_ra_wan.f_ports.applications[].f_port

The Fport value.

lo_ra_wan.f_ports.applications[].type

Application type, which can be specified to obtain real-time position information of your LoRaWAN device.

lo_ra_wan.f_ports.clock_sync

The Fport value.

lo_ra_wan.f_ports.fuota

The Fport value.

lo_ra_wan.f_ports.multicast

The Fport value.

lo_ra_wan.f_ports.positioning

FPort values for the GNSS, stream, and ClockSync functions of the positioning information.

Show child fields
lo_ra_wan.f_ports.positioning.clock_sync

The Fport value.

lo_ra_wan.f_ports.positioning.gnss

The Fport value.

lo_ra_wan.f_ports.positioning.stream

The Fport value.

lo_ra_wan.otaa_v1_0_x

OTAA device object for create APIs for v1.0.x

Show child fields
lo_ra_wan.otaa_v1_0_x.app_eui

The AppEUI value. You specify this value when using LoRaWAN versions v1.0.2 or v1.0.3.

lo_ra_wan.otaa_v1_0_x.app_key

The AppKey value.

lo_ra_wan.otaa_v1_0_x.gen_app_key

The GenAppKey value.

lo_ra_wan.otaa_v1_0_x.join_eui

The JoinEUI value. You specify this value instead of the AppEUI when using LoRaWAN version v1.0.4.

lo_ra_wan.otaa_v1_1

OTAA device object for v1.1 for create APIs

Show child fields
lo_ra_wan.otaa_v1_1.app_key

The AppKey value.

lo_ra_wan.otaa_v1_1.join_eui

The JoinEUI value.

lo_ra_wan.otaa_v1_1.nwk_key

The NwkKey value.

lo_ra_wan.service_profile_id

The ID of the service profile.

name

The name of the resource.

VARCHAR
positioning

FPort values for the GNSS, stream, and ClockSync functions of the positioning information.

VARCHAR
sidewalk

Sidewalk device object.

STRUCT(
    "amazon_id" VARCHAR,
    "sidewalk_id" VARCHAR,
    "sidewalk_manufacturing_sn" VARCHAR,
    "device_certificates" STRUCT(
        "signing_alg" VARCHAR,
        "value" VARCHAR
    )[],
    "private_keys" STRUCT(
        "signing_alg" VARCHAR,
        "value" VARCHAR
    )[],
    "device_profile_id" VARCHAR,
    "certificate_id" VARCHAR,
    "status" VARCHAR
)
Show child fields
sidewalk.amazon_id

The Sidewalk Amazon ID.

sidewalk.certificate_id

The ID of the Sidewalk device profile.

sidewalk.device_certificates[]
Show child fields
sidewalk.device_certificates[].signing_alg

The certificate chain algorithm provided by sidewalk.

sidewalk.device_certificates[].value

The value of the chosen sidewalk certificate.

sidewalk.device_profile_id

The ID of the Sidewalk device profile.

sidewalk.private_keys[]
Show child fields
sidewalk.private_keys[].signing_alg

The certificate chain algorithm provided by sidewalk.

sidewalk.private_keys[].value

The value of the chosen sidewalk certificate.

sidewalk.sidewalk_id

The sidewalk device identification.

sidewalk.sidewalk_manufacturing_sn

The Sidewalk manufacturing series number.

sidewalk.status

The Sidewalk device status, such as provisioned or registered.

thing_arn

The ARN of the thing associated with the wireless device.

VARCHAR
thing_name

The name of the thing associated with the wireless device. The value is empty if a thing isn't associated with the device.

VARCHAR
type

The wireless device type.

VARCHAR