Skip to content

aws.drs.describe_recovery_instances

Example SQL Queries

SELECT * FROM
aws.drs.describe_recovery_instances;

Description

Lists all Recovery Instances or multiple Recovery Instances by ID.

Table Definition

Column NameColumn Data Type
filters Input Column

A set of filters by which to return Recovery Instances.

STRUCT(
"recovery_instance_i_ds" VARCHAR[],
"source_server_i_ds" VARCHAR[]
)
Show child fields
filters.recovery_instance_i_ds[]
filters.source_server_i_ds[]
_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
agent_version

The version of the DRS agent installed on the recovery instance

VARCHAR
arn

The ARN of the Recovery Instance.

VARCHAR
data_replication_info

The Data Replication Info of the Recovery Instance.

STRUCT(
"data_replication_error" STRUCT(
"error" VARCHAR,
"raw_error" VARCHAR
),
"data_replication_initiation" STRUCT(
"start_date_time" VARCHAR,
"steps" STRUCT(
"name" VARCHAR,
"status" VARCHAR
)[]
),
"data_replication_state" VARCHAR,
"eta_date_time" VARCHAR,
"lag_duration" VARCHAR,
"replicated_disks" STRUCT(
"backlogged_storage_bytes" BIGINT,
"device_name" VARCHAR,
"replicated_storage_bytes" BIGINT,
"rescanned_storage_bytes" BIGINT,
"total_storage_bytes" BIGINT
)[],
"staging_availability_zone" VARCHAR,
"staging_outpost_arn" VARCHAR
)
Show child fields
data_replication_info.data_replication_error

Information about Data Replication

Show child fields
data_replication_info.data_replication_error.error

Error in data replication.

data_replication_info.data_replication_error.raw_error

Error in data replication.

data_replication_info.data_replication_initiation

Information about whether the data replication has been initiated.

Show child fields
data_replication_info.data_replication_initiation.start_date_time

The date and time of the current attempt to initiate data replication.

data_replication_info.data_replication_initiation.steps[]
Show child fields
data_replication_info.data_replication_initiation.steps[].name

The name of the step.

data_replication_info.data_replication_initiation.steps[].status

The status of the step.

data_replication_info.data_replication_state

The state of the data replication.

data_replication_info.eta_date_time

An estimate of when the data replication will be completed.

data_replication_info.lag_duration

Data replication lag duration.

data_replication_info.replicated_disks[]
Show child fields
data_replication_info.replicated_disks[].backlogged_storage_bytes

The size of the replication backlog in bytes.

data_replication_info.replicated_disks[].device_name

The name of the device.

data_replication_info.replicated_disks[].replicated_storage_bytes

The amount of data replicated so far in bytes.

data_replication_info.replicated_disks[].rescanned_storage_bytes

The amount of data to be rescanned in bytes.

data_replication_info.replicated_disks[].total_storage_bytes

The total amount of data to be replicated in bytes.

data_replication_info.staging_availability_zone

AWS Availability zone into which data is being replicated.

data_replication_info.staging_outpost_arn

The ARN of the staging Outpost

ec2_instance_id

The EC2 instance ID of the Recovery Instance.

VARCHAR
ec2_instance_state

The state of the EC2 instance for this Recovery Instance.

VARCHAR
failback

An object representing failback related information of the Recovery Instance.

STRUCT(
"agent_last_seen_by_service_date_time" VARCHAR,
"elapsed_replication_duration" VARCHAR,
"failback_client_id" VARCHAR,
"failback_client_last_seen_by_service_date_time" VARCHAR,
"failback_initiation_time" VARCHAR,
"failback_job_id" VARCHAR,
"failback_launch_type" VARCHAR,
"failback_to_original_server" BOOLEAN,
"first_byte_date_time" VARCHAR,
"state" VARCHAR
)
Show child fields
failback.agent_last_seen_by_service_date_time

The date and time the agent on the Recovery Instance was last seen by the service.

failback.elapsed_replication_duration

The amount of time that the Recovery Instance has been replicating for.

failback.failback_client_id

The ID of the failback client that this Recovery Instance is associated with.

failback.failback_client_last_seen_by_service_date_time

The date and time that the failback client was last seen by the service.

failback.failback_initiation_time

The date and time that the failback initiation started.

failback.failback_job_id

The Job ID of the last failback log for this Recovery Instance.

failback.failback_launch_type

The launch type (Recovery/Drill) of the last launch for the failback replication of this recovery instance.

failback.failback_to_original_server

Whether we are failing back to the original Source Server for this Recovery Instance.

failback.first_byte_date_time

The date and time of the first byte that was replicated from the Recovery Instance.

failback.state

The state of the failback process that this Recovery Instance is in.

is_drill

Whether this Recovery Instance was created for a drill or for an actual Recovery event.

BOOLEAN
job_id

The ID of the Job that created the Recovery Instance.

VARCHAR
origin_availability_zone

AWS availability zone associated with the recovery instance.

VARCHAR
origin_environment

Environment (On Premises/AWS) of the instance that the recovery instance originated from.

VARCHAR
point_in_time_snapshot_date_time

The date and time of the Point in Time (PIT) snapshot that this Recovery Instance was launched from.

VARCHAR
recovery_instance_id

The ID of the Recovery Instance.

VARCHAR
recovery_instance_properties

Properties of the Recovery Instance machine.

STRUCT(
"cpus" STRUCT(
"cores" BIGINT,
"model_name" VARCHAR
)[],
"disks" STRUCT(
"bytes" BIGINT,
"ebs_volume_id" VARCHAR,
"internal_device_name" VARCHAR
)[],
"identification_hints" STRUCT(
"aws_instance_id" VARCHAR,
"fqdn" VARCHAR,
"hostname" VARCHAR,
"vm_ware_uuid" VARCHAR
),
"last_updated_date_time" VARCHAR,
"network_interfaces" STRUCT(
"ips" VARCHAR[],
"is_primary" BOOLEAN,
"mac_address" VARCHAR
)[],
"os" STRUCT(
"full_string" VARCHAR
),
"ram_bytes" BIGINT
)
Show child fields
recovery_instance_properties.cpus[]
Show child fields
recovery_instance_properties.cpus[].cores

The number of CPU cores.

recovery_instance_properties.cpus[].model_name

The model name of the CPU.

recovery_instance_properties.disks[]
Show child fields
recovery_instance_properties.disks[].bytes

The amount of storage on the disk in bytes.

recovery_instance_properties.disks[].ebs_volume_id

The EBS Volume ID of this disk.

recovery_instance_properties.disks[].internal_device_name

The internal device name of this disk. This is the name that is visible on the machine itself and not from the EC2 console.

recovery_instance_properties.identification_hints

Hints used to uniquely identify a machine.

Show child fields
recovery_instance_properties.identification_hints.aws_instance_id

AWS Instance ID identification hint.

recovery_instance_properties.identification_hints.fqdn

Fully Qualified Domain Name identification hint.

recovery_instance_properties.identification_hints.hostname

Hostname identification hint.

recovery_instance_properties.identification_hints.vm_ware_uuid

vCenter VM path identification hint.

recovery_instance_properties.last_updated_date_time

The date and time the Recovery Instance properties were last updated on.

recovery_instance_properties.network_interfaces[]
Show child fields
recovery_instance_properties.network_interfaces[].ips[]
recovery_instance_properties.network_interfaces[].is_primary

Whether this is the primary network interface.

recovery_instance_properties.network_interfaces[].mac_address

The MAC address of the network interface.

recovery_instance_properties.os

Operating system.

Show child fields
recovery_instance_properties.os.full_string

The long name of the Operating System.

recovery_instance_properties.ram_bytes

The amount of RAM in bytes.

source_outpost_arn

The ARN of the source Outpost

VARCHAR
source_server_id

The Source Server ID that this Recovery Instance is associated with.

VARCHAR
tags

An array of tags that are associated with the Recovery Instance.

MAP(VARCHAR, VARCHAR)