Skip to content
AWS for Query.Farm

aws.storagegateway.describe_vtl_devices

Example SQL Queries

SELECT * FROM
aws.storagegateway.describe_vtl_devices
WHERE
"gateway_arn" = 'VALUE';

Description

Returns a description of virtual tape library (VTL) devices for the specified tape gateway. In the response, Storage Gateway returns VTL device information.

This operation is only supported in the tape gateway type.

Table Definition

Column NameColumn Data Type
gateway_arn Required Input Column

The Amazon Resource Name (ARN) of the gateway. Use the ListGateways operation to return a list of gateways for your account and Amazon Web Services Region.

VARCHAR
vtl_device_ar_ns Input Column

An array of strings, where each string represents the Amazon Resource Name (ARN) of a VTL device.

All of the specified VTL devices must be from the same gateway. If no VTL devices are specified, the result will contain all devices on the specified gateway.

VARCHAR[]
Show child fields
vtl_device_ar_ns[]
_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
vtl_devices

An array of VTL device objects composed of the Amazon Resource Name (ARN) of the VTL devices.

STRUCT(
    "vtl_device_arn" VARCHAR,
    "vtl_device_type" VARCHAR,
    "vtl_device_vendor" VARCHAR,
    "vtl_device_product_identifier" VARCHAR,
    "devicei_scsi_attributes" STRUCT(
        "target_arn" VARCHAR,
        "network_interface_id" VARCHAR,
        "network_interface_port" BIGINT,
        "chap_enabled" BOOLEAN
    )
)[]
Show child fields
vtl_devices[]
Show child fields
vtl_devices[].devicei_scsi_attributes

A list of iSCSI information about a VTL device.

Show child fields
vtl_devices[].devicei_scsi_attributes.chap_enabled

Indicates whether mutual CHAP is enabled for the iSCSI target.

vtl_devices[].devicei_scsi_attributes.network_interface_id

The network interface identifier of the VTL device.

vtl_devices[].devicei_scsi_attributes.network_interface_port

The port used to communicate with iSCSI VTL device targets.

vtl_devices[].devicei_scsi_attributes.target_arn

Specifies the unique Amazon Resource Name (ARN) that encodes the iSCSI qualified name(iqn) of a tape drive or media changer target.

vtl_devices[].vtl_device_arn

Specifies the unique Amazon Resource Name (ARN) of the device (tape drive or media changer).

vtl_devices[].vtl_device_product_identifier

Specifies the model number of device that the VTL device emulates.

vtl_devices[].vtl_device_type

Specifies the type of device that the VTL device emulates.

vtl_devices[].vtl_device_vendor

Specifies the vendor of the device that the VTL device object emulates.