Skip to content
AWS for Query.Farm

aws.accessanalyzer.get_analyzer

Example SQL Queries

SELECT * FROM
aws.accessanalyzer.get_analyzer
WHERE
"analyzer_name" = 'VALUE';

Description

Retrieves information about the specified analyzer.

Table Definition

Column NameColumn Data Type
analyzer_name Required Input Column

The name of the analyzer retrieved.

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.

analyzer

An AnalyzerSummary object that contains information about the analyzer.

STRUCT(
    "arn" VARCHAR,
    "name" VARCHAR,
    "type" VARCHAR,
    "created_at" TIMESTAMP_S,
    "last_resource_analyzed" VARCHAR,
    "last_resource_analyzed_at" TIMESTAMP_S,
    "tags" MAP(VARCHAR, VARCHAR),
    "status" VARCHAR,
    "status_reason" STRUCT(
        "code" VARCHAR
    ),
    "configuration" STRUCT(
        "unused_access" STRUCT(
            "unused_access_age" BIGINT
        )
    )
)
Show child fields
analyzer.arn

The ARN of the analyzer.

analyzer.configuration

Specifies whether the analyzer is an external access or unused access analyzer.

Show child fields
analyzer.configuration.unused_access

Specifies the configuration of an unused access analyzer for an Amazon Web Services organization or account. External access analyzers do not support any configuration.

Show child fields
analyzer.configuration.unused_access.unused_access_age

The specified access age in days for which to generate findings for unused access. For example, if you specify 90 days, the analyzer will generate findings for IAM entities within the accounts of the selected organization for any access that hasn't been used in 90 or more days since the analyzer's last scan. You can choose a value between 1 and 180 days.

analyzer.created_at

A timestamp for the time at which the analyzer was created.

analyzer.last_resource_analyzed

The resource that was most recently analyzed by the analyzer.

analyzer.last_resource_analyzed_at

The time at which the most recently analyzed resource was analyzed.

analyzer.name

The name of the analyzer.

analyzer.status

The status of the analyzer. An Active analyzer successfully monitors supported resources and generates new findings. The analyzer is Disabled when a user action, such as removing trusted access for Identity and Access Management Access Analyzer from Organizations, causes the analyzer to stop generating new findings. The status is Creating when the analyzer creation is in progress and Failed when the analyzer creation has failed.

analyzer.status_reason

The statusReason provides more details about the current status of the analyzer. For example, if the creation for the analyzer fails, a Failed status is returned. For an analyzer with organization as the type, this failure can be due to an issue with creating the service-linked roles required in the member accounts of the Amazon Web Services organization.

Show child fields
analyzer.status_reason.code

The reason code for the current status of the analyzer.

analyzer.tags

The tags added to the analyzer.

analyzer.type

The type of analyzer, which corresponds to the zone of trust chosen for the analyzer.