Skip to content
AWS for Query.Farm

aws.config.get_compliance_summary_by_config_rule

Example SQL Queries

SELECT * FROM
aws.config.get_compliance_summary_by_config_rule;

Description

Returns the number of Config rules that are compliant and noncompliant, up to a maximum of 25 for each.

Table Definition

Column NameColumn Data Type
compliance_summary

The number of Config rules that are compliant and the number that are noncompliant, up to a maximum of 25 for each.

STRUCT(
    "compliant_resource_count" STRUCT(
        "capped_count" BIGINT,
        "cap_exceeded" BOOLEAN
    ),
    "non_compliant_resource_count" STRUCT(
        "capped_count" BIGINT,
        "cap_exceeded" BOOLEAN
    ),
    "compliance_summary_timestamp" TIMESTAMP_S
)
Show child fields
compliance_summary.compliance_summary_timestamp

The time that Config created the compliance summary.

compliance_summary.compliant_resource_count

The number of Config rules or Amazon Web Services resources that are compliant, up to a maximum of 25 for rules and 100 for resources.

Show child fields
compliance_summary.compliant_resource_count.cap_exceeded

Indicates whether the maximum count is reached.

compliance_summary.compliant_resource_count.capped_count

The number of Amazon Web Services resources or Config rules responsible for the current compliance of the item.

compliance_summary.non_compliant_resource_count

The number of Config rules or Amazon Web Services resources that are noncompliant, up to a maximum of 25 for rules and 100 for resources.

Show child fields
compliance_summary.non_compliant_resource_count.cap_exceeded

Indicates whether the maximum count is reached.

compliance_summary.non_compliant_resource_count.capped_count

The number of Amazon Web Services resources or Config rules responsible for the current compliance of the item.