Skip to content
AWS for Query.Farm

aws.xray.get_insight_summaries

Example SQL Queries

SELECT * FROM
aws.xray.get_insight_summaries
WHERE
"start_time" = 'VALUE'
AND "end_time" = 'VALUE';

Description

Retrieves the summaries of all insights in the specified group matching the provided filter values.

Table Definition

Column NameColumn Data Type
end_time Required Input Column

The end of the time frame in which the insights ended. The end time can't be more than 30 days old.

TIMESTAMP_S
start_time Required Input Column

The beginning of the time frame in which the insights started. The start time can't be more than 30 days old.

TIMESTAMP_S
group_arn Input Column

The Amazon Resource Name (ARN) of the group. Required if the GroupName isn't provided.

VARCHAR
group_name Input Column

The name of the group. Required if the GroupARN isn't provided.

VARCHAR
max_results Input Column

The maximum number of results to display.

BIGINT
next_token Input Column

Pagination token.

VARCHAR
states Input Column

The list of insight states. 

VARCHAR[]
Show child fields
states[]
_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
insight_summaries

The summary of each insight within the group matching the provided filters. The summary contains the InsightID, start and end time, the root cause service, the root cause and client impact statistics, the top anomalous services, and the status of the insight.

STRUCT(
    "insight_id" VARCHAR,
    "group_arn" VARCHAR,
    "group_name" VARCHAR,
    "root_cause_service_id" STRUCT(
        "name" VARCHAR,
        "names" VARCHAR[],
        "account_id" VARCHAR,
        "type" VARCHAR
    ),
    "categories" VARCHAR[],
    "state" VARCHAR,
    "start_time" TIMESTAMP_S,
    "end_time" TIMESTAMP_S,
    "summary" VARCHAR,
    "client_request_impact_statistics" STRUCT(
        "fault_count" BIGINT,
        "ok_count" BIGINT,
        "total_count" BIGINT
    ),
    "root_cause_service_request_impact_statistics" STRUCT(
        "fault_count" BIGINT,
        "ok_count" BIGINT,
        "total_count" BIGINT
    ),
    "top_anomalous_services" STRUCT(
        "service_id" STRUCT(
            "name" VARCHAR,
            "names" VARCHAR[],
            "account_id" VARCHAR,
            "type" VARCHAR
        )
    )[],
    "last_update_time" TIMESTAMP_S
)[]
Show child fields
insight_summaries[]
Show child fields
insight_summaries[].categories[]
insight_summaries[].client_request_impact_statistics

The impact statistics of the client side service. This includes the number of requests to the client service and whether the requests were faults or okay.

Show child fields
insight_summaries[].client_request_impact_statistics.fault_count

The number of requests that have resulted in a fault,

insight_summaries[].client_request_impact_statistics.ok_count

The number of successful requests.

insight_summaries[].client_request_impact_statistics.total_count

The total number of requests to the service.

insight_summaries[].end_time

The time, in Unix seconds, at which the insight ended.

insight_summaries[].group_arn

The Amazon Resource Name (ARN) of the group that the insight belongs to.

insight_summaries[].group_name

The name of the group that the insight belongs to.

insight_summaries[].insight_id

The insights unique identifier.

insight_summaries[].last_update_time

The time, in Unix seconds, that the insight was last updated.

insight_summaries[].root_cause_service_id

Show child fields
insight_summaries[].root_cause_service_id.account_id

insight_summaries[].root_cause_service_id.name

insight_summaries[].root_cause_service_id.names[]
insight_summaries[].root_cause_service_id.type

insight_summaries[].root_cause_service_request_impact_statistics

The impact statistics of the root cause service. This includes the number of requests to the client service and whether the requests were faults or okay.

Show child fields
insight_summaries[].root_cause_service_request_impact_statistics.fault_count

The number of requests that have resulted in a fault,

insight_summaries[].root_cause_service_request_impact_statistics.ok_count

The number of successful requests.

insight_summaries[].root_cause_service_request_impact_statistics.total_count

The total number of requests to the service.

insight_summaries[].start_time

The time, in Unix seconds, at which the insight began.

insight_summaries[].state

The current state of the insight.

insight_summaries[].summary

A brief description of the insight.

insight_summaries[].top_anomalous_services[]
Show child fields
insight_summaries[].top_anomalous_services[].service_id

Show child fields
insight_summaries[].top_anomalous_services[].service_id.account_id

insight_summaries[].top_anomalous_services[].service_id.name

insight_summaries[].top_anomalous_services[].service_id.names[]
insight_summaries[].top_anomalous_services[].service_id.type