Skip to content

aws.drs.describe_source_servers

Example SQL Queries

SELECT * FROM
aws.drs.describe_source_servers;

Description

Lists all Source Servers or multiple Source Servers filtered by ID.

Table Definition

Column NameColumn Data Type
filters Input Column

A set of filters by which to return Source Servers.

STRUCT(
"hardware_id" VARCHAR,
"source_server_i_ds" VARCHAR[],
"staging_account_i_ds" VARCHAR[]
)
Show child fields
filters.hardware_id

An ID that describes the hardware of the Source Server. This is either an EC2 instance id, a VMware uuid or a mac address.

filters.source_server_i_ds[]
filters.staging_account_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 source server

VARCHAR
arn

The ARN of the Source Server.

VARCHAR
data_replication_info

The Data Replication Info of the Source Server.

STRUCT(
"data_replication_error" STRUCT(
"error" VARCHAR,
"raw_error" VARCHAR
),
"data_replication_initiation" STRUCT(
"next_attempt_date_time" VARCHAR,
"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,
"volume_status" VARCHAR
)[],
"staging_availability_zone" VARCHAR,
"staging_outpost_arn" VARCHAR
)
Show child fields
data_replication_info.data_replication_error

Error in 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.next_attempt_date_time

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

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.replicated_disks[].volume_status

The status of the volume.

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

last_launch_result

The status of the last recovery launch of this Source Server.

VARCHAR
life_cycle

The lifecycle information of this Source Server.

STRUCT(
"added_to_service_date_time" VARCHAR,
"elapsed_replication_duration" VARCHAR,
"first_byte_date_time" VARCHAR,
"last_launch" STRUCT(
"initiated" STRUCT(
"api_call_date_time" VARCHAR,
"job_id" VARCHAR,
"type" VARCHAR
),
"status" VARCHAR
),
"last_seen_by_service_date_time" VARCHAR
)
Show child fields
life_cycle.added_to_service_date_time

The date and time of when the Source Server was added to the service.

life_cycle.elapsed_replication_duration

The amount of time that the Source Server has been replicating for.

life_cycle.first_byte_date_time

The date and time of the first byte that was replicated from the Source Server.

life_cycle.last_launch

An object containing information regarding the last launch of the Source Server.

Show child fields
life_cycle.last_launch.initiated

An object containing information regarding the initiation of the last launch of a Source Server.

Show child fields
life_cycle.last_launch.initiated.api_call_date_time

The date and time the last Source Server launch was initiated.

life_cycle.last_launch.initiated.job_id

The ID of the Job that was used to last launch the Source Server.

life_cycle.last_launch.initiated.type

The Job type that was used to last launch the Source Server.

life_cycle.last_launch.status

Status of Source Server's last launch.

life_cycle.last_seen_by_service_date_time

The date and time this Source Server was last seen by the service.

recovery_instance_id

The ID of the Recovery Instance associated with this Source Server.

VARCHAR
replication_direction

Replication direction of the Source Server.

VARCHAR
reversed_direction_source_server_arn

For EC2-originated Source Servers which have been failed over and then failed back, this value will mean the ARN of the Source Server on the opposite replication direction.

VARCHAR
source_cloud_properties

Source cloud properties of the Source Server.

STRUCT(
"origin_account_id" VARCHAR,
"origin_availability_zone" VARCHAR,
"origin_region" VARCHAR,
"source_outpost_arn" VARCHAR
)
Show child fields
source_cloud_properties.origin_account_id

AWS Account ID for an EC2-originated Source Server.

source_cloud_properties.origin_availability_zone

AWS Availability Zone for an EC2-originated Source Server.

source_cloud_properties.origin_region

AWS Region for an EC2-originated Source Server.

source_cloud_properties.source_outpost_arn

The ARN of the source Outpost

source_network_id

ID of the Source Network which is protecting this Source Server's network.

VARCHAR
source_properties

The source properties of the Source Server.

STRUCT(
"cpus" STRUCT(
"cores" BIGINT,
"model_name" VARCHAR
)[],
"disks" STRUCT(
"bytes" BIGINT,
"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,
"recommended_instance_type" VARCHAR,
"supports_nitro_instances" BOOLEAN
)
Show child fields
source_properties.cpus[]
Show child fields
source_properties.cpus[].cores

The number of CPU cores.

source_properties.cpus[].model_name

The model name of the CPU.

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

The amount of storage on the disk in bytes.

source_properties.disks[].device_name

The disk or device name.

source_properties.identification_hints

Hints used to uniquely identify a machine.

Show child fields
source_properties.identification_hints.aws_instance_id

AWS Instance ID identification hint.

source_properties.identification_hints.fqdn

Fully Qualified Domain Name identification hint.

source_properties.identification_hints.hostname

Hostname identification hint.

source_properties.identification_hints.vm_ware_uuid

vCenter VM path identification hint.

source_properties.last_updated_date_time

The date and time the Source Properties were last updated on.

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

Whether this is the primary network interface.

source_properties.network_interfaces[].mac_address

The MAC address of the network interface.

source_properties.os

Operating system.

Show child fields
source_properties.os.full_string

The long name of the Operating System.

source_properties.ram_bytes

The amount of RAM in bytes.

source_properties.recommended_instance_type

The recommended EC2 instance type that will be used when recovering the Source Server.

source_properties.supports_nitro_instances

Are EC2 nitro instance types supported when recovering the Source Server.

source_server_id

The ID of the Source Server.

VARCHAR
staging_area

The staging area of the source server.

STRUCT(
"error_message" VARCHAR,
"staging_account_id" VARCHAR,
"staging_source_server_arn" VARCHAR,
"status" VARCHAR
)
Show child fields
staging_area.error_message

Shows an error message that occurred when DRS tried to access the staging source server. In this case StagingArea$status will have value EXTENSION_ERROR

staging_area.staging_account_id

Account ID of the account to which source server belongs. If this source server is extended - shows Account ID of staging source server.

staging_area.staging_source_server_arn

Arn of the staging source server if this source server is extended

staging_area.status

Status of Source server extension. Possible values: (a) NOT_EXTENDED - This is a source server that is replicating in the current account. (b) EXTENDED - Source server is extended from a staging source server. In this case, the value of stagingSourceServerArn is pointing to the Arn of the source server in the staging account. (c) EXTENSION_ERROR - Some issue occurred when accessing staging source server. In this case, errorMessage field will contain an error message that explains what happened.

tags

The tags associated with the Source Server.

MAP(VARCHAR, VARCHAR)