Skip to content
AWS for Query.Farm

aws.iotwireless.get_wireless_device_statistics

Example SQL Queries

SELECT * FROM
aws.iotwireless.get_wireless_device_statistics
WHERE
"wireless_device_id" = 'VALUE';

Description

Gets operating information about a wireless device.

Table Definition

Column NameColumn Data Type
wireless_device_id Required Input Column

The ID of the wireless device.

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
last_uplink_received_at

The date and time when the most recent uplink was received.

This value is only valid for 3 months.

VARCHAR
lo_ra_wan

Information about the wireless device's operations.

STRUCT(
    "dev_eui" VARCHAR,
    "f_port" BIGINT,
    "data_rate" BIGINT,
    "frequency" BIGINT,
    "timestamp" VARCHAR,
    "gateways" STRUCT(
        "gateway_eui" VARCHAR,
        "snr" DOUBLE,
        "rssi" DOUBLE
    )[],
    "public_gateways" STRUCT(
        "provider_net_id" VARCHAR,
        "id" VARCHAR,
        "rssi" DOUBLE,
        "snr" DOUBLE,
        "rf_region" VARCHAR,
        "dl_allowed" BOOLEAN
    )[]
)
Show child fields
lo_ra_wan.data_rate

The DataRate value.

lo_ra_wan.dev_eui

The DevEUI value.

lo_ra_wan.f_port

The FPort value.

lo_ra_wan.frequency

The device's channel frequency in Hz.

lo_ra_wan.gateways[]
Show child fields
lo_ra_wan.gateways[].gateway_eui

The gateway's EUI value.

lo_ra_wan.gateways[].rssi

The RSSI value.

lo_ra_wan.gateways[].snr

The SNR value.

lo_ra_wan.public_gateways[]
Show child fields
lo_ra_wan.public_gateways[].dl_allowed

Boolean that indicates whether downlink is allowed using the network.

lo_ra_wan.public_gateways[].id

The ID of the gateways that are operated by the network provider.

lo_ra_wan.public_gateways[].provider_net_id

The ID of the LoRaWAN public network provider.

lo_ra_wan.public_gateways[].rf_region

The frequency band (RFRegion) value.

lo_ra_wan.public_gateways[].rssi

The RSSI (received signal strength indicator) value.

lo_ra_wan.public_gateways[].snr

The SNR (signal to noise ratio) value.

lo_ra_wan.timestamp

The date and time of the metadata.

sidewalk

MetaData for Sidewalk device.

STRUCT(
    "rssi" BIGINT,
    "battery_level" VARCHAR,
    "event" VARCHAR,
    "device_state" VARCHAR
)
Show child fields
sidewalk.battery_level

Sidewalk device battery level.

sidewalk.device_state

Device state defines the device status of sidewalk device.

sidewalk.event

Sidewalk device status notification.

sidewalk.rssi

The RSSI value.