Skip to content

aws.route53resolver.list_resolver_query_log_config_associations

Example SQL Queries

SELECT * FROM
aws.route53resolver.list_resolver_query_log_config_associations;

Description

Lists information about associations between Amazon VPCs and query logging configurations.

Table Definition

Column NameColumn Data Type
filters Input Column

An optional specification to return a subset of query logging associations.

If you submit a second or subsequent ListResolverQueryLogConfigAssociations request and specify the NextToken parameter, you must use the same values for Filters, if any, as in the previous request.

STRUCT(
"name" VARCHAR,
"values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

The name of the parameter that you want to use to filter objects.

The valid values for Name depend on the action that you're including the filter in, ListResolverEndpoints, ListResolverRules, ListResolverRuleAssociations, ListResolverQueryLogConfigs, or ListResolverQueryLogConfigAssociations.

In early versions of Resolver, values for Name were listed as uppercase, with underscore (_) delimiters. For example, CreatorRequestId was originally listed as CREATOR_REQUEST_ID. Uppercase values for Name are still supported.

ListResolverEndpoints

Valid values for Name include the following:

  • CreatorRequestId: The value that you specified when you created the Resolver endpoint.

  • Direction: Whether you want to return inbound or outbound Resolver endpoints. If you specify DIRECTION for Name, specify INBOUND or OUTBOUND for Values.

  • HostVPCId: The ID of the VPC that inbound DNS queries pass through on the way from your network to your VPCs in a region, or the VPC that outbound queries pass through on the way from your VPCs to your network. In a CreateResolverEndpoint request, SubnetId indirectly identifies the VPC. In a GetResolverEndpoint request, the VPC ID for a Resolver endpoint is returned in the HostVPCId element.

  • IpAddressCount: The number of IP addresses that you have associated with the Resolver endpoint.

  • Name: The name of the Resolver endpoint.

  • SecurityGroupIds: The IDs of the VPC security groups that you specified when you created the Resolver endpoint.

  • Status: The status of the Resolver endpoint. If you specify Status for Name, specify one of the following status codes for Values: CREATING, OPERATIONAL, UPDATING, AUTO_RECOVERING, ACTION_NEEDED, or DELETING. For more information, see Status in ResolverEndpoint.

ListResolverRules

Valid values for Name include the following:

  • CreatorRequestId: The value that you specified when you created the Resolver rule.

  • DomainName: The domain name for which Resolver is forwarding DNS queries to your network. In the value that you specify for Values, include a trailing dot (.) after the domain name. For example, if the domain name is example.com, specify the following value. Note the "." after com:

    example.com.

  • Name: The name of the Resolver rule.

  • ResolverEndpointId: The ID of the Resolver endpoint that the Resolver rule is associated with.

    You can filter on the Resolver endpoint only for rules that have a value of FORWARD for RuleType.

  • Status: The status of the Resolver rule. If you specify Status for Name, specify one of the following status codes for Values: COMPLETE, DELETING, UPDATING, or FAILED.

  • Type: The type of the Resolver rule. If you specify TYPE for Name, specify FORWARD or SYSTEM for Values.

ListResolverRuleAssociations

Valid values for Name include the following:

  • Name: The name of the Resolver rule association.

  • ResolverRuleId: The ID of the Resolver rule that is associated with one or more VPCs.

  • Status: The status of the Resolver rule association. If you specify Status for Name, specify one of the following status codes for Values: CREATING, COMPLETE, DELETING, or FAILED.

  • VPCId: The ID of the VPC that the Resolver rule is associated with.

ListResolverQueryLogConfigs

Valid values for Name include the following:

  • Arn: The ARN for the query logging configuration.

  • AssociationCount: The number of VPCs that are associated with the query logging configuration.

  • CreationTime: The date and time that the query logging configuration was created, in Unix time format and Coordinated Universal Time (UTC).

  • CreatorRequestId: A unique string that identifies the request that created the query logging configuration.

  • Destination: The Amazon Web Services service that you want to forward query logs to. Valid values include the following:

    • S3

    • CloudWatchLogs

    • KinesisFirehose

  • DestinationArn: The ARN of the location that Resolver is sending query logs to. This value can be the ARN for an S3 bucket, a CloudWatch Logs log group, or a Kinesis Data Firehose delivery stream.

  • Id: The ID of the query logging configuration

  • Name: The name of the query logging configuration

  • OwnerId: The Amazon Web Services account ID for the account that created the query logging configuration.

  • ShareStatus: An indication of whether the query logging configuration is shared with other Amazon Web Services accounts, or was shared with the current account by another Amazon Web Services account. Valid values include: NOT_SHARED, SHARED_WITH_ME, or SHARED_BY_ME.

  • Status: The status of the query logging configuration. If you specify Status for Name, specify the applicable status code for Values: CREATING, CREATED, DELETING, or FAILED. For more information, see Status.

ListResolverQueryLogConfigAssociations

Valid values for Name include the following:

  • CreationTime: The date and time that the VPC was associated with the query logging configuration, in Unix time format and Coordinated Universal Time (UTC).

  • Error: If the value of Status is FAILED, specify the cause: DESTINATION_NOT_FOUND or ACCESS_DENIED.

  • Id: The ID of the query logging association.

  • ResolverQueryLogConfigId: The ID of the query logging configuration that a VPC is associated with.

  • ResourceId: The ID of the Amazon VPC that is associated with the query logging configuration.

  • Status: The status of the query logging association. If you specify Status for Name, specify the applicable status code for Values: CREATING, CREATED, DELETING, or FAILED. For more information, see Status.

filters[].values[]
sort_by Input Column

The element that you want Resolver to sort query logging associations by.

If you submit a second or subsequent ListResolverQueryLogConfigAssociations request and specify the NextToken parameter, you must use the same value for SortBy, if any, as in the previous request.

Valid values include the following elements:

  • CreationTime: The ID of the query logging association.

  • Error: If the value of Status is FAILED, the value of Error indicates the cause:

    • DESTINATION_NOT_FOUND: The specified destination (for example, an Amazon S3 bucket) was deleted.

    • ACCESS_DENIED: Permissions don't allow sending logs to the destination.

    If Status is a value other than FAILED, ERROR is null.

  • Id: The ID of the query logging association

  • ResolverQueryLogConfigId: The ID of the query logging configuration

  • ResourceId: The ID of the VPC that is associated with the query logging configuration

  • Status: The current status of the configuration. Valid values include the following:

    • CREATING: Resolver is creating an association between an Amazon VPC and a query logging configuration.

    • CREATED: The association between an Amazon VPC and a query logging configuration was successfully created. Resolver is logging queries that originate in the specified VPC.

    • DELETING: Resolver is deleting this query logging association.

    • FAILED: Resolver either couldn't create or couldn't delete the query logging association. Here are two common causes:

      • The specified destination (for example, an Amazon S3 bucket) was deleted.

      • Permissions don't allow sending logs to the destination.

VARCHAR
sort_order Input Column

If you specified a value for SortBy, the order that you want query logging associations to be listed in, ASCENDING or DESCENDING.

If you submit a second or subsequent ListResolverQueryLogConfigAssociations request and specify the NextToken parameter, you must use the same value for SortOrder, if any, as in the previous request.

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
resolver_query_log_config_associations

A list that contains one ResolverQueryLogConfigAssociations element for each query logging association that matches the values that you specified for Filter.

STRUCT(
"id" VARCHAR,
"resolver_query_log_config_id" VARCHAR,
"resource_id" VARCHAR,
"status" VARCHAR,
"error" VARCHAR,
"error_message" VARCHAR,
"creation_time" VARCHAR
)[]
Show child fields
resolver_query_log_config_associations[]
Show child fields
resolver_query_log_config_associations[].creation_time

The date and time that the VPC was associated with the query logging configuration, in Unix time format and Coordinated Universal Time (UTC).

resolver_query_log_config_associations[].error

If the value of Status is FAILED, the value of Error indicates the cause:

  • DESTINATION_NOT_FOUND: The specified destination (for example, an Amazon S3 bucket) was deleted.

  • ACCESS_DENIED: Permissions don't allow sending logs to the destination.

If the value of Status is a value other than FAILED, Error is null.

resolver_query_log_config_associations[].error_message

Contains additional information about the error. If the value or Error is null, the value of ErrorMessage also is null.

resolver_query_log_config_associations[].id

The ID of the query logging association.

resolver_query_log_config_associations[].resolver_query_log_config_id

The ID of the query logging configuration that a VPC is associated with.

resolver_query_log_config_associations[].resource_id

The ID of the Amazon VPC that is associated with the query logging configuration.

resolver_query_log_config_associations[].status

The status of the specified query logging association. Valid values include the following:

  • CREATING: Resolver is creating an association between an Amazon VPC and a query logging configuration.

  • CREATED: The association between an Amazon VPC and a query logging configuration was successfully created. Resolver is logging queries that originate in the specified VPC.

  • DELETING: Resolver is deleting this query logging association.

  • FAILED: Resolver either couldn't create or couldn't delete the query logging association.

total_count

The total number of query logging associations that were created by the current account in the specified Region. This count can differ from the number of associations that are returned in a ListResolverQueryLogConfigAssociations response, depending on the values that you specify in the request.

BIGINT
total_filtered_count

The total number of query logging associations that were created by the current account in the specified Region and that match the filters that were specified in the ListResolverQueryLogConfigAssociations request. For the total number of associations that were created by the current account in the specified Region, see TotalCount.

BIGINT