Skip to content
AWS for Query.Farm

aws.drs.describe_job_log_items

Example SQL Queries

SELECT * FROM
aws.drs.describe_job_log_items
WHERE
"job_id" = 'VALUE';

Description

Retrieves a detailed Job log with pagination.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

The ID of the Job for which Job log items will be retrieved.

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
event

The event represents the type of a log.

VARCHAR
event_data

Metadata associated with a Job log.

STRUCT(
    "conversion_properties" STRUCT(
        "data_timestamp" VARCHAR,
        "force_uefi" BOOLEAN,
        "root_volume_name" VARCHAR,
        "volume_to_conversion_map" MAP(VARCHAR, MAP(VARCHAR, VARCHAR)),
        "volume_to_product_codes" MAP(VARCHAR, STRUCT(
                "product_code_id" VARCHAR,
                "product_code_mode" VARCHAR
            )[]),
        "volume_to_volume_size" MAP(VARCHAR, BIGINT)
    ),
    "conversion_server_id" VARCHAR,
    "event_resource_data" STRUCT(
        "source_network_data" STRUCT(
            "source_network_id" VARCHAR,
            "source_vpc" VARCHAR,
            "stack_name" VARCHAR,
            "target_vpc" VARCHAR
        )
    ),
    "raw_error" VARCHAR,
    "source_server_id" VARCHAR,
    "target_instance_id" VARCHAR
)
Show child fields
event_data.conversion_properties

Properties of a conversion job

Show child fields
event_data.conversion_properties.data_timestamp

The timestamp of when the snapshot being converted was taken

event_data.conversion_properties.force_uefi

Whether the volume being converted uses UEFI or not

event_data.conversion_properties.root_volume_name

The root volume name of a conversion job

event_data.conversion_properties.volume_to_conversion_map

A mapping between the volumes being converted and the converted snapshot ids

event_data.conversion_properties.volume_to_product_codes

A mapping between the volumes being converted and the product codes associated with them

event_data.conversion_properties.volume_to_volume_size

A mapping between the volumes and their sizes

event_data.conversion_server_id

The ID of a conversion server.

event_data.event_resource_data

Properties of resource related to a job event.

Show child fields
event_data.event_resource_data.source_network_data

Source Network properties.

Show child fields
event_data.event_resource_data.source_network_data.source_network_id

Source Network ID.

event_data.event_resource_data.source_network_data.source_vpc

VPC ID protected by the Source Network.

event_data.event_resource_data.source_network_data.stack_name

CloudFormation stack name that was deployed for recovering the Source Network.

event_data.event_resource_data.source_network_data.target_vpc

ID of the recovered VPC following Source Network recovery.

event_data.raw_error

A string representing a job error.

event_data.source_server_id

The ID of a Source Server.

event_data.target_instance_id

The ID of a Recovery Instance.

log_date_time

The date and time the log was taken.

VARCHAR