Skip to content

aws.resiliencehub.list_apps

Example SQL Queries

SELECT * FROM
aws.resiliencehub.list_apps;

Description

Lists your Resilience Hub applications.

You can filter applications using only one filter at a time or without using any filter. If you try to filter applications using multiple filters, you will get the following error:

An error occurred (ValidationException) when calling the ListApps operation: Only one filter is supported for this operation.

Table Definition

Column NameColumn Data Type
app_arn Input Column

Amazon Resource Name (ARN) of the Resilience Hub application. The format for this ARN is: arn:partition:resiliencehub:region:account:app/app-id. For more information about ARNs, see Amazon Resource Names (ARNs) in the Amazon Web Services General Reference guide.

VARCHAR
from_last_assessment_time Input Column

Indicates the lower limit of the range that is used to filter applications based on their last assessment times.

TIMESTAMP_S
max_results Input Column

Maximum number of results to include in the response. If more results exist than the specified MaxResults value, a token is included in the response so that the remaining results can be retrieved.

BIGINT
name Input Column

The name for the one of the listed applications.

VARCHAR
next_token Input Column

Token for the next set of results, or null if there are no more results.

VARCHAR
reverse_order Input Column

The application list is sorted based on the values of lastAppComplianceEvaluationTime field. By default, application list is sorted in ascending order. To sort the application list in descending order, set this field to True.

BOOLEAN
to_last_assessment_time Input Column

Indicates the upper limit of the range that is used to filter the applications based on their last assessment times.

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
app_summaries

Summaries for the Resilience Hub application.

STRUCT(
"app_arn" VARCHAR,
"assessment_schedule" VARCHAR,
"compliance_status" VARCHAR,
"creation_time" TIMESTAMP_S,
"description" VARCHAR,
"drift_status" VARCHAR,
"last_app_compliance_evaluation_time" TIMESTAMP_S,
"name" VARCHAR,
"resiliency_score" DOUBLE,
"rpo_in_secs" BIGINT,
"rto_in_secs" BIGINT,
"status" VARCHAR
)[]
Show child fields
app_summaries[]
Show child fields
app_summaries[].app_arn

Amazon Resource Name (ARN) of the Resilience Hub application. The format for this ARN is: arn:partition:resiliencehub:region:account:app/app-id. For more information about ARNs, see Amazon Resource Names (ARNs) in the Amazon Web Services General Reference guide.

app_summaries[].assessment_schedule

Assessment execution schedule with 'Daily' or 'Disabled' values.

app_summaries[].compliance_status

The current status of compliance for the resiliency policy.

app_summaries[].creation_time

Date and time when the app was created.

app_summaries[].description

The optional description for an app.

app_summaries[].drift_status

Indicates if compliance drifts (deviations) were detected while running an assessment for your application.

app_summaries[].last_app_compliance_evaluation_time

Date and time of the most recent compliance evaluation.

app_summaries[].name

The name of the application.

app_summaries[].resiliency_score

The current resiliency score for the application.

app_summaries[].rpo_in_secs

Recovery Point Objective (RPO) in seconds.

app_summaries[].rto_in_secs

Recovery Time Objective (RTO) in seconds.

app_summaries[].status

Status of the application.