Skip to content

aws.sms.get_replication_jobs

Example SQL Queries

SELECT * FROM
aws.sms.get_replication_jobs;

Description

Describes the specified replication job or all of your replication jobs.

Table Definition

Column NameColumn Data Type
replication_job_id Input Column

The ID of the replication job.

VARCHAR
_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
description

The description of the replication job.

VARCHAR
encrypted

Indicates whether the replication job should produce encrypted AMIs.

BOOLEAN
frequency

The time between consecutive replication runs, in hours.

BIGINT
kms_key_id

The ID of the KMS key for replication jobs that produce encrypted AMIs. This value can be any of the following:

  • KMS key ID

  • KMS key alias

  • ARN referring to the KMS key ID

  • ARN referring to the KMS key alias

If encrypted is enabled but a KMS key ID is not specified, the customer's default KMS key for Amazon EBS is used.

VARCHAR
latest_ami_id

The ID of the latest Amazon Machine Image (AMI).

VARCHAR
license_type

The license type to be used for the AMI created by a successful replication run.

VARCHAR
next_replication_run_start_time

The start time of the next replication run.

TIMESTAMP_S
number_of_recent_amis_to_keep

The number of recent AMIs to keep in the customer's account for a replication job. By default, the value is set to zero, meaning that all AMIs are kept.

BIGINT
replication_run_list

Information about the replication runs.

STRUCT(
"replication_run_id" VARCHAR,
"state" VARCHAR,
"type" VARCHAR,
"stage_details" STRUCT(
"stage" VARCHAR,
"stage_progress" VARCHAR
),
"status_message" VARCHAR,
"ami_id" VARCHAR,
"scheduled_start_time" TIMESTAMP_S,
"completed_time" TIMESTAMP_S,
"description" VARCHAR,
"encrypted" BOOLEAN,
"kms_key_id" VARCHAR
)[]
Show child fields
replication_run_list[]
Show child fields
replication_run_list[].ami_id

The ID of the Amazon Machine Image (AMI) from the replication run.

replication_run_list[].completed_time

The completion time of the last replication run.

replication_run_list[].description

The description of the replication run.

replication_run_list[].encrypted

Indicates whether the replication run should produce an encrypted AMI.

replication_run_list[].kms_key_id

The ID of the KMS key for replication jobs that produce encrypted AMIs. This value can be any of the following:

  • KMS key ID

  • KMS key alias

  • ARN referring to the KMS key ID

  • ARN referring to the KMS key alias

If encrypted is true but a KMS key ID is not specified, the customer's default KMS key for Amazon EBS is used.

replication_run_list[].replication_run_id

The ID of the replication run.

replication_run_list[].scheduled_start_time

The start time of the next replication run.

replication_run_list[].stage_details

Details about the current stage of the replication run.

Show child fields
replication_run_list[].stage_details.stage

The current stage of a replication run.

replication_run_list[].stage_details.stage_progress

The progress of the current stage of a replication run.

replication_run_list[].state

The state of the replication run.

replication_run_list[].status_message

The description of the current status of the replication job.

replication_run_list[].type

The type of replication run.

role_name

The name of the IAM role to be used by Server Migration Service.

VARCHAR
run_once

Indicates whether to run the replication job one time.

BOOLEAN
seed_replication_time

The seed replication time.

TIMESTAMP_S
server_id

The ID of the server.

VARCHAR
server_type

The type of server.

VARCHAR
state

The state of the replication job.

VARCHAR
status_message

The description of the current status of the replication job.

VARCHAR
vm_server

Information about the VM server.

STRUCT(
"vm_server_address" STRUCT(
"vm_manager_id" VARCHAR,
"vm_id" VARCHAR
),
"vm_name" VARCHAR,
"vm_manager_name" VARCHAR,
"vm_manager_type" VARCHAR,
"vm_path" VARCHAR
)
Show child fields
vm_server.vm_manager_name

The name of the VM manager.

vm_server.vm_manager_type

The type of VM management product.

vm_server.vm_name

The name of the VM.

vm_server.vm_path

The VM folder path in the vCenter Server virtual machine inventory tree.

vm_server.vm_server_address

The VM server location.

Show child fields
vm_server.vm_server_address.vm_id

The ID of the VM.

vm_server.vm_server_address.vm_manager_id

The ID of the VM manager.