Skip to content

aws.privatenetworks.list_network_resources

Example SQL Queries

SELECT * FROM
aws.privatenetworks.list_network_resources
WHERE
"network_arn" = 'VALUE';

Description

Lists network resources. Add filters to your request to return a more specific list of results. Use filters to match the Amazon Resource Name (ARN) of an order or the status of network resources.

If you specify multiple filters, filters are joined with an OR, and the request returns results that match all of the specified filters.

Table Definition

Column NameColumn Data Type
network_arn Required Input Column

The Amazon Resource Name (ARN) of the network on which this network resource appears.

VARCHAR
filters Input Column

The filters.

  • ORDER - The Amazon Resource Name (ARN) of the order.

  • STATUS - The status (AVAILABLE | DELETED | DELETING | PENDING | PENDING_RETURN | PROVISIONING | SHIPPED).

Filter values are case sensitive. If you specify multiple values for a filter, the values are joined with an OR, and the request returns all results that match any of the specified values.

MAP(VARCHAR, 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.

attributes

The attributes of the network resource.

STRUCT(
"name" VARCHAR,
"value" VARCHAR
)[]
Show child fields
attributes[]
Show child fields
attributes[].name

The name of the pair.

attributes[].value

The value of the pair.

commitment_information

Information about the commitment period for the radio unit. Shows the duration, the date and time that the contract started and ends, and the renewal status of the commitment period.

STRUCT(
"commitment_configuration" STRUCT(
"automatic_renewal" BOOLEAN,
"commitment_length" VARCHAR
),
"expires_on" TIMESTAMP_S,
"start_at" TIMESTAMP_S
)
Show child fields
commitment_information.commitment_configuration

The duration and renewal status of the commitment period for the radio unit.

Show child fields
commitment_information.commitment_configuration.automatic_renewal

Determines whether the commitment period for a radio unit is set to automatically renew for an additional 1 year after your current commitment period expires.

Set to True, if you want your commitment period to automatically renew. Set to False if you do not want your commitment to automatically renew.

You can do the following:

  • Set a 1-year commitment to automatically renew for an additional 1 year. The hourly rate for the additional year will continue to be the same as your existing 1-year rate.

  • Set a 3-year commitment to automatically renew for an additional 1 year. The hourly rate for the additional year will continue to be the same as your existing 3-year rate.

  • Turn off a previously-enabled automatic renewal on a 1-year or 3-year commitment.

You cannot use the automatic-renewal option for a 60-day commitment.

commitment_information.commitment_configuration.commitment_length

The duration of the commitment period for the radio unit. You can choose a 60-day, 1-year, or 3-year period.

commitment_information.expires_on

The date and time that the commitment period ends. If you do not cancel or renew the commitment before the expiration date, you will be billed at the 60-day-commitment rate.

commitment_information.start_at

The date and time that the commitment period started.

created_at

The creation time of the network resource.

TIMESTAMP_S
description

The description of the network resource.

VARCHAR
health

The health of the network resource.

VARCHAR
model

The model of the network resource.

VARCHAR
network_resource_arn

The Amazon Resource Name (ARN) of the network resource.

VARCHAR
network_site_arn

The Amazon Resource Name (ARN) of the network site on which this network resource appears.

VARCHAR
order_arn

The Amazon Resource Name (ARN) of the order used to purchase this network resource.

VARCHAR
position

The position of the network resource.

STRUCT(
"elevation" DOUBLE,
"elevation_reference" VARCHAR,
"elevation_unit" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE
)
Show child fields
position.elevation

The elevation of the equipment at this position.

position.elevation_reference

The reference point from which elevation is reported.

position.elevation_unit

The units used to measure the elevation of the position.

position.latitude

The latitude of the position.

position.longitude

The longitude of the position.

return_information

Information about a request to return the network resource.

STRUCT(
"replacement_order_arn" VARCHAR,
"return_reason" VARCHAR,
"shipping_address" STRUCT(
"city" VARCHAR,
"company" VARCHAR,
"country" VARCHAR,
"email_address" VARCHAR,
"name" VARCHAR,
"phone_number" VARCHAR,
"postal_code" VARCHAR,
"state_or_province" VARCHAR,
"street1" VARCHAR,
"street2" VARCHAR,
"street3" VARCHAR
),
"shipping_label" VARCHAR
)
Show child fields
return_information.replacement_order_arn

The Amazon Resource Name (ARN) of the replacement order.

return_information.return_reason

The reason for the return. If the return request did not include a reason for the return, this value is null.

return_information.shipping_address

The shipping address.

Show child fields
return_information.shipping_address.city

The city for this address.

return_information.shipping_address.company

The company name for this address.

return_information.shipping_address.country

The country for this address.

return_information.shipping_address.email_address

The recipient's email address.

return_information.shipping_address.name

The recipient's name for this address.

return_information.shipping_address.phone_number

The recipient's phone number.

return_information.shipping_address.postal_code

The postal code for this address.

return_information.shipping_address.state_or_province

The state or province for this address.

return_information.shipping_address.street1

The first line of the street address.

return_information.shipping_address.street2

The second line of the street address.

return_information.shipping_address.street3

The third line of the street address.

return_information.shipping_label

The URL of the shipping label. The shipping label is available for download only if the status of the network resource is PENDING_RETURN. For more information, see Return a radio unit.

serial_number

The serial number of the network resource.

VARCHAR
status

The status of the network resource.

VARCHAR
status_reason

The status reason of the network resource.

VARCHAR
type

The type of the network resource.

VARCHAR
vendor

The vendor of the network resource.

VARCHAR