Skip to content

aws.application_insights.list_configuration_history

Example SQL Queries

SELECT * FROM
aws.application_insights.list_configuration_history;

Description

Lists the INFO, WARN, and ERROR events for periodic configuration updates performed by Application Insights. Examples of events represented are:

  • INFO: creating a new alarm or updating an alarm threshold.

  • WARN: alarm not created due to insufficient data points used to predict thresholds.

  • ERROR: alarm not created due to permission errors or exceeding quotas.

Table Definition

Column NameColumn Data Type
account_id Input Column

The AWS account ID for the resource group owner.

VARCHAR
end_time Input Column

The end time of the event.

TIMESTAMP_S
event_status Input Column

The status of the configuration update event. Possible values include INFO, WARN, and ERROR.

VARCHAR
max_results Input Column

The maximum number of results returned by ListConfigurationHistory in paginated output. When this parameter is used, ListConfigurationHistory returns only MaxResults in a single page along with a NextToken response element. The remaining results of the initial request can be seen by sending another ListConfigurationHistory request with the returned NextToken value. If this parameter is not used, then ListConfigurationHistory returns all results.

BIGINT
next_token Input Column

The NextToken value to include in a future ListConfigurationHistory request. When the results of a ListConfigurationHistory request exceed MaxResults, this value can be used to retrieve the next page of results. This value is null when there are no more results to return.

VARCHAR
resource_group_name Input Column

Resource group to which the application belongs.

VARCHAR
start_time Input Column

The start time of the event.

TIMESTAMP_S
_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.

event_list

The list of configuration events and their corresponding details.

STRUCT(
"resource_group_name" VARCHAR,
"account_id" VARCHAR,
"monitored_resource_arn" VARCHAR,
"event_status" VARCHAR,
"event_resource_type" VARCHAR,
"event_time" TIMESTAMP_S,
"event_detail" VARCHAR,
"event_resource_name" VARCHAR
)[]
Show child fields
event_list[]
Show child fields
event_list[].account_id

The AWS account ID for the owner of the application to which the configuration event belongs.

event_list[].event_detail

The details of the event in plain text.

event_list[].event_resource_name

The name of the resource Application Insights attempted to configure.

event_list[].event_resource_type

The resource type that Application Insights attempted to configure, for example, CLOUDWATCH_ALARM.

event_list[].event_status

The status of the configuration update event. Possible values include INFO, WARN, and ERROR.

event_list[].event_time

The timestamp of the event.

event_list[].monitored_resource_arn

The resource monitored by Application Insights.

event_list[].resource_group_name

The name of the resource group of the application to which the configuration event belongs.