Skip to content

aws.mgn.describe_source_servers

Example SQL Queries

SELECT * FROM
aws.mgn.describe_source_servers;

Description

Retrieves all SourceServers or multiple SourceServers by ID.

Table Definition

Column NameColumn Data Type
account_id Input Column

Request to filter Source Servers list by Accoun ID.

VARCHAR
filters Input Column

Request to filter Source Servers list.

STRUCT(
"application_i_ds" VARCHAR[],
"is_archived" BOOLEAN,
"life_cycle_states" VARCHAR[],
"replication_types" VARCHAR[],
"source_server_i_ds" VARCHAR[]
)
Show child fields
filters.application_i_ds[]
filters.is_archived

Request to filter Source Servers list by archived.

filters.life_cycle_states[]
filters.replication_types[]
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
application_id

Source server application ID.

VARCHAR
arn

Source server ARN.

VARCHAR
connector_action

Source Server connector action.

STRUCT(
"connector_arn" VARCHAR,
"credentials_secret_arn" VARCHAR
)
Show child fields
connector_action.connector_arn

Source Server connector action connector arn.

connector_action.credentials_secret_arn

Source Server connector action credentials secret arn.

data_replication_info

Source server data replication info.

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,
"last_snapshot_date_time" VARCHAR,
"replicated_disks" STRUCT(
"backlogged_storage_bytes" BIGINT,
"device_name" VARCHAR,
"replicated_storage_bytes" BIGINT,
"rescanned_storage_bytes" BIGINT,
"total_storage_bytes" BIGINT
)[]
)
Show child fields
data_replication_info.data_replication_error

Error in obtaining data replication info.

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

Request to query whether data replication has been initiated.

Show child fields
data_replication_info.data_replication_initiation.next_attempt_date_time

Request to query next data initiation date and time.

data_replication_info.data_replication_initiation.start_date_time

Request to query data initiation start date and time.

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

Request to query data initiation step name.

data_replication_info.data_replication_initiation.steps[].status

Request to query data initiation status.

data_replication_info.data_replication_state

Request to query the data replication state.

data_replication_info.eta_date_time

Request to query the time when data replication will be complete.

data_replication_info.lag_duration

Request to query data replication lag duration.

data_replication_info.last_snapshot_date_time

Request to query data replication last snapshot time.

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

Request to query data replication backlog size in bytes.

data_replication_info.replicated_disks[].device_name

Request to query device name.

data_replication_info.replicated_disks[].replicated_storage_bytes

Request to query amount of data replicated in bytes.

data_replication_info.replicated_disks[].rescanned_storage_bytes

Request to query amount of data rescanned in bytes.

data_replication_info.replicated_disks[].total_storage_bytes

Request to query total amount of data replicated in bytes.

fqdn_for_action_framework

Source server fqdn for action framework.

VARCHAR
is_archived

Source server archived status.

BOOLEAN
launched_instance

Source server launched instance.

STRUCT(
"ec2_instance_id" VARCHAR,
"first_boot" VARCHAR,
"job_id" VARCHAR
)
Show child fields
launched_instance.ec2_instance_id

Launched instance EC2 ID.

launched_instance.first_boot

Launched instance first boot.

launched_instance.job_id

Launched instance Job ID.

life_cycle

Source server lifecycle state.

STRUCT(
"added_to_service_date_time" VARCHAR,
"elapsed_replication_duration" VARCHAR,
"first_byte_date_time" VARCHAR,
"last_cutover" STRUCT(
"finalized" STRUCT(
"api_call_date_time" VARCHAR
),
"initiated" STRUCT(
"api_call_date_time" VARCHAR,
"job_id" VARCHAR
),
"reverted" STRUCT(
"api_call_date_time" VARCHAR
)
),
"last_seen_by_service_date_time" VARCHAR,
"last_test" STRUCT(
"finalized" STRUCT(
"api_call_date_time" VARCHAR
),
"initiated" STRUCT(
"api_call_date_time" VARCHAR,
"job_id" VARCHAR
),
"reverted" STRUCT(
"api_call_date_time" VARCHAR
)
),
"state" VARCHAR
)
Show child fields
life_cycle.added_to_service_date_time

Lifecycle added to service data and time.

life_cycle.elapsed_replication_duration

Lifecycle elapsed time and duration.

life_cycle.first_byte_date_time

Lifecycle replication initiation date and time.

life_cycle.last_cutover

Lifecycle last Cutover.

Show child fields
life_cycle.last_cutover.finalized

Lifecycle Cutover finalized date and time.

Show child fields
life_cycle.last_cutover.finalized.api_call_date_time

Lifecycle Cutover finalized date and time.

life_cycle.last_cutover.initiated

Lifecycle last Cutover initiated.

Show child fields
life_cycle.last_cutover.initiated.api_call_date_time

life_cycle.last_cutover.initiated.job_id

Lifecycle last Cutover initiated by Job ID.

life_cycle.last_cutover.reverted

Lifecycle last Cutover reverted.

Show child fields
life_cycle.last_cutover.reverted.api_call_date_time

Lifecycle last Cutover reverted API call date time.

life_cycle.last_seen_by_service_date_time

Lifecycle last seen date and time.

life_cycle.last_test

Lifecycle last Test.

Show child fields
life_cycle.last_test.finalized

Lifecycle last Test finalized.

Show child fields
life_cycle.last_test.finalized.api_call_date_time

Lifecycle Test failed API call date and time.

life_cycle.last_test.initiated

Lifecycle last Test initiated.

Show child fields
life_cycle.last_test.initiated.api_call_date_time

Lifecycle last Test initiated API call date and time.

life_cycle.last_test.initiated.job_id

Lifecycle last Test initiated Job ID.

life_cycle.last_test.reverted

Lifecycle last Test reverted.

Show child fields
life_cycle.last_test.reverted.api_call_date_time

Lifecycle last Test reverted API call date and time.

life_cycle.state

Lifecycle state.

replication_type

Source server replication type.

VARCHAR
source_properties

Source server properties.

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_path" 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
)
Show child fields
source_properties.cpus[]
Show child fields
source_properties.cpus[].cores

The number of CPU cores on the source server.

source_properties.cpus[].model_name

The source server's CPU model name.

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

Source server identification hints.

Show child fields
source_properties.identification_hints.aws_instance_id

AWS Instance ID identification hint.

source_properties.identification_hints.fqdn

FQDN address identification hint.

source_properties.identification_hints.hostname

Hostname identification hint.

source_properties.identification_hints.vm_path

vCenter VM path identification hint.

source_properties.identification_hints.vm_ware_uuid

vmWare UUID identification hint.

source_properties.last_updated_date_time

Source server last update date and time.

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

Network interface primary IP.

source_properties.network_interfaces[].mac_address

Network interface Mac address.

source_properties.os

Source server OS.

Show child fields
source_properties.os.full_string

OS full string.

source_properties.ram_bytes

Source server RAM in bytes.

source_properties.recommended_instance_type

Source server recommended instance type.

source_server_id

Source server ID.

VARCHAR
tags

Source server Tags.

MAP(VARCHAR, VARCHAR)
user_provided_id

Source server user provided ID.

VARCHAR
vcenter_client_id

Source server vCenter client id.

VARCHAR