Skip to content

aws.medialive.list_input_devices

Example SQL Queries

SELECT * FROM
aws.medialive.list_input_devices;

Description

List input devices

Table Definition

Column NameColumn Data Type
_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 unique ARN of the input device.

VARCHAR
availability_zone

The Availability Zone associated with this input device.

VARCHAR
connection_state

The state of the connection between the input device and AWS.

VARCHAR
device_settings_sync_state

The status of the action to synchronize the device configuration. If you change the configuration of the input device (for example, the maximum bitrate), MediaLive sends the new data to the device. The device might not update itself immediately. SYNCED means the device has updated its configuration. SYNCING means that it has not updated its configuration.

VARCHAR
device_update_status

The status of software on the input device.

VARCHAR
hd_device_settings

Settings that describe an input device that is type HD.

STRUCT(
"active_input" VARCHAR,
"configured_input" VARCHAR,
"device_state" VARCHAR,
"framerate" DOUBLE,
"height" BIGINT,
"max_bitrate" BIGINT,
"scan_type" VARCHAR,
"width" BIGINT,
"latency_ms" BIGINT
)
Show child fields
hd_device_settings.active_input

If you specified Auto as the configured input, specifies which of the sources is currently active (SDI or HDMI).

hd_device_settings.configured_input

The source at the input device that is currently active. You can specify this source.

hd_device_settings.device_state

The state of the input device.

hd_device_settings.framerate

The frame rate of the video source.

hd_device_settings.height

The height of the video source, in pixels.

hd_device_settings.latency_ms

The Link device's buffer size (latency) in milliseconds (ms). You can specify this value.

hd_device_settings.max_bitrate

The current maximum bitrate for ingesting this source, in bits per second. You can specify this maximum.

hd_device_settings.scan_type

The scan type of the video source.

hd_device_settings.width

The width of the video source, in pixels.

id

The unique ID of the input device.

VARCHAR
mac_address

The network MAC address of the input device.

VARCHAR
medialive_input_arns

An array of the ARNs for the MediaLive inputs attached to the device. Returned only if the outputType is MEDIALIVE_INPUT.

VARCHAR[]
Show child fields
medialive_input_arns[]
name

A name that you specify for the input device.

VARCHAR
network_settings

Network settings for the input device.

STRUCT(
"dns_addresses" VARCHAR[],
"gateway" VARCHAR,
"ip_address" VARCHAR,
"ip_scheme" VARCHAR,
"subnet_mask" VARCHAR
)
Show child fields
network_settings.dns_addresses[]
network_settings.gateway

The network gateway IP address.

network_settings.ip_address

The IP address of the input device.

network_settings.ip_scheme

Specifies whether the input device has been configured (outside of MediaLive) to use a dynamic IP address assignment (DHCP) or a static IP address.

network_settings.subnet_mask

The subnet mask of the input device.

output_type

The output attachment type of the input device. Specifies MEDIACONNECT_FLOW if this device is the source for a MediaConnect flow. Specifies MEDIALIVE_INPUT if this device is the source for a MediaLive input.

VARCHAR
serial_number

The unique serial number of the input device.

VARCHAR
tags

A collection of key-value pairs.

MAP(VARCHAR, VARCHAR)
type

The type of the input device.

VARCHAR
uhd_device_settings

Settings that describe an input device that is type UHD.

STRUCT(
"active_input" VARCHAR,
"configured_input" VARCHAR,
"device_state" VARCHAR,
"framerate" DOUBLE,
"height" BIGINT,
"max_bitrate" BIGINT,
"scan_type" VARCHAR,
"width" BIGINT,
"latency_ms" BIGINT,
"codec" VARCHAR,
"mediaconnect_settings" STRUCT(
"flow_arn" VARCHAR,
"role_arn" VARCHAR,
"secret_arn" VARCHAR,
"source_name" VARCHAR
),
"audio_channel_pairs" STRUCT(
"id" BIGINT,
"profile" VARCHAR
)[]
)
Show child fields
uhd_device_settings.active_input

If you specified Auto as the configured input, specifies which of the sources is currently active (SDI or HDMI).

uhd_device_settings.audio_channel_pairs[]
Show child fields
uhd_device_settings.audio_channel_pairs[].id

The ID for one audio pair configuration, a value from 1 to 8.

uhd_device_settings.audio_channel_pairs[].profile

The profile for one audio pair configuration. This property describes one audio configuration in the format (rate control algorithm)-(codec)_(quality)-(bitrate in bytes). For example, CBR-AAC_HQ-192000. Or DISABLED, in which case the device won't produce audio for this pair.

uhd_device_settings.codec

The codec for the video that the device produces.

uhd_device_settings.configured_input

The source at the input device that is currently active. You can specify this source.

uhd_device_settings.device_state

The state of the input device.

uhd_device_settings.framerate

The frame rate of the video source.

uhd_device_settings.height

The height of the video source, in pixels.

uhd_device_settings.latency_ms

The Link device's buffer size (latency) in milliseconds (ms). You can specify this value.

uhd_device_settings.max_bitrate

The current maximum bitrate for ingesting this source, in bits per second. You can specify this maximum.

uhd_device_settings.mediaconnect_settings

Information about the MediaConnect flow attached to the device. Returned only if the outputType is MEDIACONNECT_FLOW.

Show child fields
uhd_device_settings.mediaconnect_settings.flow_arn

The ARN of the MediaConnect flow.

uhd_device_settings.mediaconnect_settings.role_arn

The ARN for the role that MediaLive assumes to access the attached flow and secret.

uhd_device_settings.mediaconnect_settings.secret_arn

The ARN of the secret used to encrypt the stream.

uhd_device_settings.mediaconnect_settings.source_name

The name of the MediaConnect flow source.

uhd_device_settings.scan_type

The scan type of the video source.

uhd_device_settings.width

The width of the video source, in pixels.