Skip to content
AWS for Query.Farm

aws.imagebuilder.list_image_scan_findings

Example SQL Queries

SELECT * FROM
aws.imagebuilder.list_image_scan_findings;

Description

Returns a list of image scan findings for your account.

Table Definition

Column NameColumn Data Type
filters Input Column

An array of name value pairs that you can use to filter your results. You can use the following filters to streamline results:

  • imageBuildVersionArn

  • imagePipelineArn

  • vulnerabilityId

  • severity

If you don't request a filter, then all findings in your account are listed.

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

The name of the image scan finding filter. Filter names are case-sensitive.

filters[].values[]
max_results Input Column

The maximum items to return in a request.

BIGINT
next_token Input Column

The next token used for paginated responses. When this field isn't empty, there are additional elements that the service hasn't included in this request. Use this token with the next request to retrieve additional objects.

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.

findings

The image scan findings for your account that meet your request filter criteria.

STRUCT(
    "aws_account_id" VARCHAR,
    "image_build_version_arn" VARCHAR,
    "image_pipeline_arn" VARCHAR,
    "type" VARCHAR,
    "description" VARCHAR,
    "title" VARCHAR,
    "remediation" STRUCT(
        "recommendation" STRUCT(
            "text" VARCHAR,
            "url" VARCHAR
        )
    ),
    "severity" VARCHAR,
    "first_observed_at" TIMESTAMP_S,
    "updated_at" TIMESTAMP_S,
    "inspector_score" DOUBLE,
    "inspector_score_details" STRUCT(
        "adjusted_cvss" STRUCT(
            "score_source" VARCHAR,
            "cvss_source" VARCHAR,
            "version" VARCHAR,
            "score" DOUBLE,
            "scoring_vector" VARCHAR,
            "adjustments" STRUCT(
                "metric" VARCHAR,
                "reason" VARCHAR
            )[]
        )
    ),
    "package_vulnerability_details" STRUCT(
        "vulnerability_id" VARCHAR,
        "vulnerable_packages" STRUCT(
            "name" VARCHAR,
            "version" VARCHAR,
            "source_layer_hash" VARCHAR,
            "epoch" BIGINT,
            "release" VARCHAR,
            "arch" VARCHAR,
            "package_manager" VARCHAR,
            "file_path" VARCHAR,
            "fixed_in_version" VARCHAR,
            "remediation" VARCHAR
        )[],
        "source" VARCHAR,
        "cvss" STRUCT(
            "base_score" DOUBLE,
            "scoring_vector" VARCHAR,
            "version" VARCHAR,
            "source" VARCHAR
        )[],
        "related_vulnerabilities" VARCHAR[],
        "source_url" VARCHAR,
        "vendor_severity" VARCHAR,
        "vendor_created_at" TIMESTAMP_S,
        "vendor_updated_at" TIMESTAMP_S,
        "reference_urls" VARCHAR[]
    ),
    "fix_available" VARCHAR
)[]
Show child fields
findings[]
Show child fields
findings[].aws_account_id

The Amazon Web Services account ID that's associated with the finding.

findings[].description

The description of the finding.

findings[].first_observed_at

The date and time when the finding was first observed.

findings[].fix_available

Details about whether a fix is available for any of the packages that are identified in the finding through a version update.

findings[].image_build_version_arn

The Amazon Resource Name (ARN) of the image build version that's associated with the finding.

findings[].image_pipeline_arn

The Amazon Resource Name (ARN) of the image pipeline that's associated with the finding.

findings[].inspector_score

The score that Amazon Inspector assigned for the finding.

findings[].inspector_score_details

An object that contains details of the Amazon Inspector score.

Show child fields
findings[].inspector_score_details.adjusted_cvss

An object that contains details about an adjustment that Amazon Inspector made to the CVSS score for the finding.

Show child fields
findings[].inspector_score_details.adjusted_cvss.adjustments[]
Show child fields
findings[].inspector_score_details.adjusted_cvss.adjustments[].metric

The metric that Amazon Inspector used to adjust the CVSS score.

findings[].inspector_score_details.adjusted_cvss.adjustments[].reason

The reason for the CVSS score adjustment.

findings[].inspector_score_details.adjusted_cvss.cvss_source

The source of the finding.

findings[].inspector_score_details.adjusted_cvss.score

The CVSS score.

findings[].inspector_score_details.adjusted_cvss.score_source

The source for the CVSS score.

findings[].inspector_score_details.adjusted_cvss.scoring_vector

A vector that measures the severity of the vulnerability.

findings[].inspector_score_details.adjusted_cvss.version

The CVSS version that generated the score.

findings[].package_vulnerability_details

An object that contains the details of a package vulnerability finding.

Show child fields
findings[].package_vulnerability_details.cvss[]
Show child fields
findings[].package_vulnerability_details.cvss[].base_score

The CVSS base score.

findings[].package_vulnerability_details.cvss[].scoring_vector

The vector string of the CVSS score.

findings[].package_vulnerability_details.cvss[].source

The source of the CVSS score.

findings[].package_vulnerability_details.cvss[].version

The CVSS version that generated the score.

findings[].package_vulnerability_details.reference_urls[]
findings[].package_vulnerability_details.related_vulnerabilities[]
findings[].package_vulnerability_details.source

The source of the vulnerability information.

findings[].package_vulnerability_details.source_url

A link to the source of the vulnerability information.

findings[].package_vulnerability_details.vendor_created_at

The date and time when this vulnerability was first added to the vendor's database.

findings[].package_vulnerability_details.vendor_severity

The severity that the vendor assigned to this vulnerability type.

findings[].package_vulnerability_details.vendor_updated_at

The date and time when the vendor last updated this vulnerability in their database.

findings[].package_vulnerability_details.vulnerability_id

A unique identifier for this vulnerability.

findings[].package_vulnerability_details.vulnerable_packages[]
Show child fields
findings[].package_vulnerability_details.vulnerable_packages[].arch

The architecture of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].epoch

The epoch of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].file_path

The file path of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].fixed_in_version

The version of the package that contains the vulnerability fix.

findings[].package_vulnerability_details.vulnerable_packages[].name

The name of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].package_manager

The package manager of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].release

The release of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].remediation

The code to run in your environment to update packages with a fix available.

findings[].package_vulnerability_details.vulnerable_packages[].source_layer_hash

The source layer hash of the vulnerable package.

findings[].package_vulnerability_details.vulnerable_packages[].version

The version of the vulnerable package.

findings[].remediation

An object that contains the details about how to remediate the finding.

Show child fields
findings[].remediation.recommendation

An object that contains information about the recommended course of action to remediate the finding.

Show child fields
findings[].remediation.recommendation.text

The recommended course of action to remediate the finding.

findings[].remediation.recommendation.url

A link to more information about the recommended remediation for this vulnerability.

findings[].severity

The severity of the finding.

findings[].title

The title of the finding.

findings[].type

The type of the finding. Image Builder looks for findings of the type PACKAGE_VULNERABILITY that apply to output images, and excludes other types.

findings[].updated_at

The timestamp when the finding was last updated.

request_id

The request ID that uniquely identifies this request.

VARCHAR