Skip to content

aws.macie2.get_findings

Example SQL Queries

SELECT * FROM
aws.macie2.get_findings
WHERE
"finding_ids" = 'VALUE';

Description

Retrieves the details of one or more findings.

Table Definition

Column NameColumn Data Type
finding_ids Required Input Column

An array of strings that lists the unique identifiers for the findings to retrieve. You can specify as many as 50 unique identifiers in this array.

VARCHAR[]
Show child fields
finding_ids[]
sort_criteria Input Column

The criteria for sorting the results of the request.

STRUCT(
"attribute_name" VARCHAR,
"order_by" VARCHAR
)
Show child fields
sort_criteria.attribute_name

The name of the property to sort the results by. Valid values are: count, createdAt, policyDetails.action.apiCallDetails.firstSeen, policyDetails.action.apiCallDetails.lastSeen, resourcesAffected, severity.score, type, and updatedAt.

sort_criteria.order_by

The sort order to apply to the results, based on the value for the property specified by the attributeName property. Valid values are: ASC, sort the results in ascending order; and, DESC, sort the results in descending order.

_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
findings

An array of objects, one for each finding that matches the criteria specified in the request.

STRUCT(
"account_id" VARCHAR,
"archived" BOOLEAN,
"category" VARCHAR,
"classification_details" STRUCT(
"detailed_results_location" VARCHAR,
"job_arn" VARCHAR,
"job_id" VARCHAR,
"origin_type" VARCHAR,
"result" STRUCT(
"additional_occurrences" BOOLEAN,
"custom_data_identifiers" STRUCT(
"detections" STRUCT(
"arn" VARCHAR,
"count" BIGINT,
"name" VARCHAR,
"occurrences" STRUCT(
"cells" STRUCT(
"cell_reference" VARCHAR,
"column" BIGINT,
"column_name" VARCHAR,
"row" BIGINT
)[],
"line_ranges" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
)[],
"offset_ranges" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
)[],
"pages" STRUCT(
"line_range" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
),
"offset_range" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
),
"page_number" BIGINT
)[],
"records" STRUCT(
"json_path" VARCHAR,
"record_index" BIGINT
)[]
)
)[],
"total_count" BIGINT
),
"mime_type" VARCHAR,
"sensitive_data" STRUCT(
"category" VARCHAR,
"detections" STRUCT(
"count" BIGINT,
"occurrences" STRUCT(
"cells" STRUCT(
"cell_reference" VARCHAR,
"column" BIGINT,
"column_name" VARCHAR,
"row" BIGINT
)[],
"line_ranges" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
)[],
"offset_ranges" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
)[],
"pages" STRUCT(
"line_range" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
),
"offset_range" STRUCT(
"end" BIGINT,
"start" BIGINT,
"start_column" BIGINT
),
"page_number" BIGINT
)[],
"records" STRUCT(
"json_path" VARCHAR,
"record_index" BIGINT
)[]
),
"type" VARCHAR
)[],
"total_count" BIGINT
)[],
"size_classified" BIGINT,
"status" STRUCT(
"code" VARCHAR,
"reason" VARCHAR
)
)
),
"count" BIGINT,
"created_at" TIMESTAMP_S,
"description" VARCHAR,
"id" VARCHAR,
"partition" VARCHAR,
"policy_details" STRUCT(
"action" STRUCT(
"action_type" VARCHAR,
"api_call_details" STRUCT(
"api" VARCHAR,
"api_service_name" VARCHAR,
"first_seen" TIMESTAMP_S,
"last_seen" TIMESTAMP_S
)
),
"actor" STRUCT(
"domain_details" STRUCT(
"domain_name" VARCHAR
),
"ip_address_details" STRUCT(
"ip_address_v4" VARCHAR,
"ip_city" STRUCT(
"name" VARCHAR
),
"ip_country" STRUCT(
"code" VARCHAR,
"name" VARCHAR
),
"ip_geo_location" STRUCT(
"lat" DOUBLE,
"lon" DOUBLE
),
"ip_owner" STRUCT(
"asn" VARCHAR,
"asn_org" VARCHAR,
"isp" VARCHAR,
"org" VARCHAR
)
),
"user_identity" STRUCT(
"assumed_role" STRUCT(
"access_key_id" VARCHAR,
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR,
"session_context" STRUCT(
"attributes" STRUCT(
"creation_date" TIMESTAMP_S,
"mfa_authenticated" BOOLEAN
),
"session_issuer" STRUCT(
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR,
"type" VARCHAR,
"user_name" VARCHAR
)
)
),
"aws_account" STRUCT(
"account_id" VARCHAR,
"principal_id" VARCHAR
),
"aws_service" STRUCT(
"invoked_by" VARCHAR
),
"federated_user" STRUCT(
"access_key_id" VARCHAR,
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR,
"session_context" STRUCT(
"attributes" STRUCT(
"creation_date" TIMESTAMP_S,
"mfa_authenticated" BOOLEAN
),
"session_issuer" STRUCT(
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR,
"type" VARCHAR,
"user_name" VARCHAR
)
)
),
"iam_user" STRUCT(
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR,
"user_name" VARCHAR
),
"root" STRUCT(
"account_id" VARCHAR,
"arn" VARCHAR,
"principal_id" VARCHAR
),
"type" VARCHAR
)
)
),
"region" VARCHAR,
"resources_affected" STRUCT(
"s3_bucket" STRUCT(
"allows_unencrypted_object_uploads" VARCHAR,
"arn" VARCHAR,
"created_at" TIMESTAMP_S,
"default_server_side_encryption" STRUCT(
"encryption_type" VARCHAR,
"kms_master_key_id" VARCHAR
),
"name" VARCHAR,
"owner" STRUCT(
"display_name" VARCHAR,
"id" VARCHAR
),
"public_access" STRUCT(
"effective_permission" VARCHAR,
"permission_configuration" STRUCT(
"account_level_permissions" STRUCT(
"block_public_access" STRUCT(
"block_public_acls" BOOLEAN,
"block_public_policy" BOOLEAN,
"ignore_public_acls" BOOLEAN,
"restrict_public_buckets" BOOLEAN
)
),
"bucket_level_permissions" STRUCT(
"access_control_list" STRUCT(
"allows_public_read_access" BOOLEAN,
"allows_public_write_access" BOOLEAN
),
"block_public_access" STRUCT(
"block_public_acls" BOOLEAN,
"block_public_policy" BOOLEAN,
"ignore_public_acls" BOOLEAN,
"restrict_public_buckets" BOOLEAN
),
"bucket_policy" STRUCT(
"allows_public_read_access" BOOLEAN,
"allows_public_write_access" BOOLEAN
)
)
)
),
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
),
"s3_object" STRUCT(
"bucket_arn" VARCHAR,
"e_tag" VARCHAR,
"extension" VARCHAR,
"key" VARCHAR,
"last_modified" TIMESTAMP_S,
"path" VARCHAR,
"public_access" BOOLEAN,
"server_side_encryption" STRUCT(
"encryption_type" VARCHAR,
"kms_master_key_id" VARCHAR
),
"size" BIGINT,
"storage_class" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"version_id" VARCHAR
)
),
"sample" BOOLEAN,
"schema_version" VARCHAR,
"severity" STRUCT(
"description" VARCHAR,
"score" BIGINT
),
"title" VARCHAR,
"type" VARCHAR,
"updated_at" TIMESTAMP_S
)[]
Show child fields
findings[]
Show child fields
findings[].account_id

The unique identifier for the Amazon Web Services account that the finding applies to. This is typically the account that owns the affected resource.

findings[].archived

Specifies whether the finding is archived (suppressed).

findings[].category

The category of the finding. Possible values are: CLASSIFICATION, for a sensitive data finding; and, POLICY, for a policy finding.

findings[].classification_details

The details of a sensitive data finding. This value is null for a policy finding.

Show child fields
findings[].classification_details.detailed_results_location

The path to the folder or file in Amazon S3 that contains the corresponding sensitive data discovery result for the finding. If a finding applies to a large archive or compressed file, this value is the path to a folder. Otherwise, this value is the path to a file.

findings[].classification_details.job_arn

The Amazon Resource Name (ARN) of the classification job that produced the finding. This value is null if the origin of the finding (originType) is AUTOMATED_SENSITIVE_DATA_DISCOVERY.

findings[].classification_details.job_id

The unique identifier for the classification job that produced the finding. This value is null if the origin of the finding (originType) is AUTOMATED_SENSITIVE_DATA_DISCOVERY.

findings[].classification_details.origin_type

Specifies how Amazon Macie found the sensitive data that produced the finding. Possible values are: SENSITIVE_DATA_DISCOVERY_JOB, for a classification job; and, AUTOMATED_SENSITIVE_DATA_DISCOVERY, for automated sensitive data discovery.

findings[].classification_details.result

The status and other details of the finding.

Show child fields
findings[].classification_details.result.additional_occurrences

Specifies whether Amazon Macie detected additional occurrences of sensitive data in the S3 object. A finding includes location data for a maximum of 15 occurrences of sensitive data.

This value can help you determine whether to investigate additional occurrences of sensitive data in an object. You can do this by referring to the corresponding sensitive data discovery result for the finding (classificationDetails.detailedResultsLocation).

findings[].classification_details.result.custom_data_identifiers

The custom data identifiers that detected the sensitive data and the number of occurrences of the data that they detected.

Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].arn

The unique identifier for the custom data identifier.

findings[].classification_details.result.custom_data_identifiers.detections[].count

The total number of occurrences of the sensitive data that the custom data identifier detected.

findings[].classification_details.result.custom_data_identifiers.detections[].name

The name of the custom data identifier.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences

The location of 1-15 occurrences of the sensitive data that the custom data identifier detected. A finding includes location data for a maximum of 15 occurrences of sensitive data.

Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.cells[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.cells[].cell_reference

The location of the cell, as an absolute cell reference, that contains the sensitive data, for example Sheet2!C5 for cell C5 on Sheet2 in a Microsoft Excel workbook. This value is null for CSV and TSV files.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.cells[].column

The column number of the column that contains the sensitive data. For a Microsoft Excel workbook, this value correlates to the alphabetical character(s) for a column identifier, for example: 1 for column A, 2 for column B, and so on.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.cells[].column_name

The name of the column that contains the sensitive data, if available.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.cells[].row

The row number of the row that contains the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.line_ranges[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.line_ranges[].end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.line_ranges[].start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.line_ranges[].start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.offset_ranges[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.offset_ranges[].end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.offset_ranges[].start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.offset_ranges[].start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].line_range

Reserved for future use.

Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].line_range.end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].line_range.start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].line_range.start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].offset_range

Reserved for future use.

Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].offset_range.end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].offset_range.start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].offset_range.start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.pages[].page_number

The page number of the page that contains the sensitive data.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.records[]
Show child fields
findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.records[].json_path

The path, as a JSONPath expression, to the sensitive data. For an Avro object container or Parquet file, this is the path to the field in the record (recordIndex) that contains the data. For a JSON or JSON Lines file, this is the path to the field or array that contains the data. If the data is a value in an array, the path also indicates which value contains the data.

If Amazon Macie detects sensitive data in the name of any element in the path, Macie omits this field. If the name of an element exceeds 240 characters, Macie truncates the name by removing characters from the beginning of the name. If the resulting full path exceeds 250 characters, Macie also truncates the path, starting with the first element in the path, until the path contains 250 or fewer characters.

findings[].classification_details.result.custom_data_identifiers.detections[].occurrences.records[].record_index

For an Avro object container or Parquet file, the record index, starting from 0, for the record that contains the sensitive data. For a JSON Lines file, the line index, starting from 0, for the line that contains the sensitive data. This value is always 0 for JSON files.

findings[].classification_details.result.custom_data_identifiers.total_count

The total number of occurrences of the data that was detected by the custom data identifiers and produced the finding.

findings[].classification_details.result.mime_type

The type of content, as a MIME type, that the finding applies to. For example, application/gzip, for a GNU Gzip compressed archive file, or application/pdf, for an Adobe Portable Document Format file.

findings[].classification_details.result.sensitive_data[]
Show child fields
findings[].classification_details.result.sensitive_data[].category

The category of sensitive data that was detected. For example: CREDENTIALS, for credentials data such as private keys or Amazon Web Services secret access keys; FINANCIAL_INFORMATION, for financial data such as credit card numbers; or, PERSONAL_INFORMATION, for personal health information, such as health insurance identification numbers, or personally identifiable information, such as passport numbers.

findings[].classification_details.result.sensitive_data[].detections[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].count

The total number of occurrences of the type of sensitive data that was detected.

findings[].classification_details.result.sensitive_data[].detections[].occurrences

The location of 1-15 occurrences of the sensitive data that was detected. A finding includes location data for a maximum of 15 occurrences of sensitive data.

Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.cells[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.cells[].cell_reference

The location of the cell, as an absolute cell reference, that contains the sensitive data, for example Sheet2!C5 for cell C5 on Sheet2 in a Microsoft Excel workbook. This value is null for CSV and TSV files.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.cells[].column

The column number of the column that contains the sensitive data. For a Microsoft Excel workbook, this value correlates to the alphabetical character(s) for a column identifier, for example: 1 for column A, 2 for column B, and so on.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.cells[].column_name

The name of the column that contains the sensitive data, if available.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.cells[].row

The row number of the row that contains the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.line_ranges[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.line_ranges[].end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.line_ranges[].start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.line_ranges[].start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.offset_ranges[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.offset_ranges[].end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.offset_ranges[].start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.offset_ranges[].start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].line_range

Reserved for future use.

Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].line_range.end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].line_range.start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].line_range.start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].offset_range

Reserved for future use.

Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].offset_range.end

The number of lines from the beginning of the file to the end of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].offset_range.start

The number of lines from the beginning of the file to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].offset_range.start_column

The number of characters, with spaces and starting from 1, from the beginning of the first line that contains the sensitive data (start) to the beginning of the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.pages[].page_number

The page number of the page that contains the sensitive data.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.records[]
Show child fields
findings[].classification_details.result.sensitive_data[].detections[].occurrences.records[].json_path

The path, as a JSONPath expression, to the sensitive data. For an Avro object container or Parquet file, this is the path to the field in the record (recordIndex) that contains the data. For a JSON or JSON Lines file, this is the path to the field or array that contains the data. If the data is a value in an array, the path also indicates which value contains the data.

If Amazon Macie detects sensitive data in the name of any element in the path, Macie omits this field. If the name of an element exceeds 240 characters, Macie truncates the name by removing characters from the beginning of the name. If the resulting full path exceeds 250 characters, Macie also truncates the path, starting with the first element in the path, until the path contains 250 or fewer characters.

findings[].classification_details.result.sensitive_data[].detections[].occurrences.records[].record_index

For an Avro object container or Parquet file, the record index, starting from 0, for the record that contains the sensitive data. For a JSON Lines file, the line index, starting from 0, for the line that contains the sensitive data. This value is always 0 for JSON files.

findings[].classification_details.result.sensitive_data[].detections[].type

The type of sensitive data that was detected. For example, AWS_CREDENTIALS, PHONE_NUMBER, or ADDRESS.

findings[].classification_details.result.sensitive_data[].total_count

The total number of occurrences of the sensitive data that was detected.

findings[].classification_details.result.size_classified

The total size, in bytes, of the data that the finding applies to.

findings[].classification_details.result.status

The status of the finding.

Show child fields
findings[].classification_details.result.status.code

The status of the finding. Possible values are:

  • COMPLETE - Amazon Macie successfully completed its analysis of the S3 object that the finding applies to.

  • PARTIAL - Macie analyzed only a subset of the data in the S3 object that the finding applies to. For example, the object is an archive file that contains files in an unsupported format.

  • SKIPPED - Macie wasn't able to analyze the S3 object that the finding applies to. For example, the object is a file that uses an unsupported format.

findings[].classification_details.result.status.reason

A brief description of the status of the finding. This value is null if the status (code) of the finding is COMPLETE.

Amazon Macie uses this value to notify you of any errors, warnings, or considerations that might impact your analysis of the finding and the affected S3 object. Possible values are:

  • ARCHIVE_CONTAINS_UNPROCESSED_FILES - The object is an archive file and Macie extracted and analyzed only some or none of the files in the archive. To determine which files Macie analyzed, if any, refer to the corresponding sensitive data discovery result for the finding (classificationDetails.detailedResultsLocation).

  • ARCHIVE_EXCEEDS_SIZE_LIMIT - The object is an archive file whose total storage size exceeds the size quota for this type of archive.

  • ARCHIVE_NESTING_LEVEL_OVER_LIMIT - The object is an archive file whose nested depth exceeds the quota for the maximum number of nested levels that Macie analyzes for this type of archive.

  • ARCHIVE_TOTAL_BYTES_EXTRACTED_OVER_LIMIT - The object is an archive file that exceeds the quota for the maximum amount of data that Macie extracts and analyzes for this type of archive.

  • ARCHIVE_TOTAL_DOCUMENTS_PROCESSED_OVER_LIMIT - The object is an archive file that contains more than the maximum number of files that Macie extracts and analyzes for this type of archive.

  • FILE_EXCEEDS_SIZE_LIMIT - The storage size of the object exceeds the size quota for this type of file.

  • INVALID_ENCRYPTION - The object is encrypted using server-side encryption but Macie isn't allowed to use the key. Macie can't decrypt and analyze the object.

  • INVALID_KMS_KEY - The object is encrypted with an KMS key that was disabled or is being deleted. Macie can't decrypt and analyze the object.

  • INVALID_OBJECT_STATE - The object doesn't use a supported Amazon S3 storage class.

  • JSON_NESTING_LEVEL_OVER_LIMIT - The object contains JSON data and the nested depth of the data exceeds the quota for the number of nested levels that Macie analyzes for this type of file.

  • MALFORMED_FILE - The object is a malformed or corrupted file. An error occurred when Macie attempted to detect the file's type or extract data from the file.

  • MALFORMED_OR_FILE_SIZE_EXCEEDS_LIMIT - The object is a Microsoft Office file that is malformed or exceeds the size quota for this type of file. If the file is malformed, an error occurred when Macie attempted to extract data from the file.

  • NO_SUCH_BUCKET_AVAILABLE - The object was in a bucket that was deleted shortly before or when Macie attempted to analyze the object.

  • OBJECT_VERSION_MISMATCH - The object was changed while Macie was analyzing it.

  • OOXML_UNCOMPRESSED_RATIO_EXCEEDS_LIMIT - The object is an Office Open XML file whose compression ratio exceeds the compression quota for this type of file.

  • OOXML_UNCOMPRESSED_SIZE_EXCEEDS_LIMIT - The object is an Office Open XML file that exceeds the size quota for this type of file.

  • PERMISSION_DENIED - Macie isn't allowed to access the object. The object's permissions settings prevent Macie from analyzing the object.

  • SOURCE_OBJECT_NO_LONGER_AVAILABLE - The object was deleted shortly before or when Macie attempted to analyze it.

  • TIME_CUT_OFF_REACHED - Macie started analyzing the object but additional analysis would exceed the time quota for analyzing an object.

  • UNABLE_TO_PARSE_FILE - The object is a file that contains structured data and an error occurred when Macie attempted to parse the data.

  • UNSUPPORTED_FILE_TYPE_EXCEPTION - The object is a file that uses an unsupported file or storage format.

For information about quotas, supported storage classes, and supported file and storage formats, see Quotas and Supported storage classes and formats in the Amazon Macie User Guide.

findings[].count

The total number of occurrences of the finding. For sensitive data findings, this value is always 1. All sensitive data findings are considered unique.

findings[].created_at

The date and time, in UTC and extended ISO 8601 format, when Amazon Macie created the finding.

findings[].description

The description of the finding.

findings[].id

The unique identifier for the finding. This is a random string that Amazon Macie generates and assigns to a finding when it creates the finding.

findings[].partition

The Amazon Web Services partition that Amazon Macie created the finding in.

findings[].policy_details

The details of a policy finding. This value is null for a sensitive data finding.

Show child fields
findings[].policy_details.action

The action that produced the finding.

Show child fields
findings[].policy_details.action.action_type

The type of action that occurred for the affected resource. This value is typically AWS_API_CALL, which indicates that an entity invoked an API operation for the resource.

findings[].policy_details.action.api_call_details

The invocation details of the API operation that an entity invoked for the affected resource, if the value for the actionType property is AWS_API_CALL.

Show child fields
findings[].policy_details.action.api_call_details.api

The name of the operation that was invoked most recently and produced the finding.

findings[].policy_details.action.api_call_details.api_service_name

The URL of the Amazon Web Service that provides the operation, for example: s3.amazonaws.com.

findings[].policy_details.action.api_call_details.first_seen

The first date and time, in UTC and extended ISO 8601 format, when any operation was invoked and produced the finding.

findings[].policy_details.action.api_call_details.last_seen

The most recent date and time, in UTC and extended ISO 8601 format, when the specified operation (api) was invoked and produced the finding.

findings[].policy_details.actor

The entity that performed the action that produced the finding.

Show child fields
findings[].policy_details.actor.domain_details

The domain name of the device that the entity used to perform the action on the affected resource.

Show child fields
findings[].policy_details.actor.domain_details.domain_name

The name of the domain.

findings[].policy_details.actor.ip_address_details

The IP address and related details about the device that the entity used to perform the action on the affected resource. The details can include information such as the owner and geographic location of the IP address.

Show child fields
findings[].policy_details.actor.ip_address_details.ip_address_v4

The Internet Protocol version 4 (IPv4) address of the device.

findings[].policy_details.actor.ip_address_details.ip_city

The city that the IP address originated from.

Show child fields
findings[].policy_details.actor.ip_address_details.ip_city.name

The name of the city.

findings[].policy_details.actor.ip_address_details.ip_country

The country that the IP address originated from.

Show child fields
findings[].policy_details.actor.ip_address_details.ip_country.code

The two-character code, in ISO 3166-1 alpha-2 format, for the country that the IP address originated from. For example, US for the United States.

findings[].policy_details.actor.ip_address_details.ip_country.name

The name of the country that the IP address originated from.

findings[].policy_details.actor.ip_address_details.ip_geo_location

The geographic coordinates of the location that the IP address originated from.

Show child fields
findings[].policy_details.actor.ip_address_details.ip_geo_location.lat

The latitude coordinate of the location, rounded to four decimal places.

findings[].policy_details.actor.ip_address_details.ip_geo_location.lon

The longitude coordinate of the location, rounded to four decimal places.

findings[].policy_details.actor.ip_address_details.ip_owner

The registered owner of the IP address.

Show child fields
findings[].policy_details.actor.ip_address_details.ip_owner.asn

The autonomous system number (ASN) for the autonomous system that included the IP address.

findings[].policy_details.actor.ip_address_details.ip_owner.asn_org

The organization identifier that's associated with the autonomous system number (ASN) for the autonomous system that included the IP address.

findings[].policy_details.actor.ip_address_details.ip_owner.isp

The name of the internet service provider (ISP) that owned the IP address.

findings[].policy_details.actor.ip_address_details.ip_owner.org

The name of the organization that owned the IP address.

findings[].policy_details.actor.user_identity

The type and other characteristics of the entity that performed the action on the affected resource. This value is null if the action was performed by an anonymous (unauthenticated) entity.

Show child fields
findings[].policy_details.actor.user_identity.assumed_role

If the action was performed with temporary security credentials that were obtained using the AssumeRole operation of the Security Token Service (STS) API, the identifiers, session context, and other details about the identity.

Show child fields
findings[].policy_details.actor.user_identity.assumed_role.access_key_id

The Amazon Web Services access key ID that identifies the credentials.

findings[].policy_details.actor.user_identity.assumed_role.account_id

The unique identifier for the Amazon Web Services account that owns the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.arn

The Amazon Resource Name (ARN) of the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.principal_id

The unique identifier for the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.session_context

The details of the session that was created for the credentials, including the entity that issued the session.

Show child fields
findings[].policy_details.actor.user_identity.assumed_role.session_context.attributes

The date and time when the credentials were issued, and whether the credentials were authenticated with a multi-factor authentication (MFA) device.

Show child fields
findings[].policy_details.actor.user_identity.assumed_role.session_context.attributes.creation_date

The date and time, in UTC and ISO 8601 format, when the credentials were issued.

findings[].policy_details.actor.user_identity.assumed_role.session_context.attributes.mfa_authenticated

Specifies whether the credentials were authenticated with a multi-factor authentication (MFA) device.

findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer

The source and type of credentials that were issued to the entity.

Show child fields
findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer.account_id

The unique identifier for the Amazon Web Services account that owns the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer.arn

The Amazon Resource Name (ARN) of the source account, Identity and Access Management (IAM) user, or role that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer.principal_id

The unique identifier for the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer.type

The source of the temporary security credentials, such as Root, IAMUser, or Role.

findings[].policy_details.actor.user_identity.assumed_role.session_context.session_issuer.user_name

The name or alias of the user or role that issued the session. This value is null if the credentials were obtained from a root account that doesn't have an alias.

findings[].policy_details.actor.user_identity.aws_account

If the action was performed using the credentials for another Amazon Web Services account, the details of that account.

Show child fields
findings[].policy_details.actor.user_identity.aws_account.account_id

The unique identifier for the Amazon Web Services account.

findings[].policy_details.actor.user_identity.aws_account.principal_id

The unique identifier for the entity that performed the action.

findings[].policy_details.actor.user_identity.aws_service

If the action was performed by an Amazon Web Services account that belongs to an Amazon Web Service, the name of the service.

Show child fields
findings[].policy_details.actor.user_identity.aws_service.invoked_by

The name of the Amazon Web Service that performed the action.

findings[].policy_details.actor.user_identity.federated_user

If the action was performed with temporary security credentials that were obtained using the GetFederationToken operation of the Security Token Service (STS) API, the identifiers, session context, and other details about the identity.

Show child fields
findings[].policy_details.actor.user_identity.federated_user.access_key_id

The Amazon Web Services access key ID that identifies the credentials.

findings[].policy_details.actor.user_identity.federated_user.account_id

The unique identifier for the Amazon Web Services account that owns the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.arn

The Amazon Resource Name (ARN) of the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.principal_id

The unique identifier for the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.session_context

The details of the session that was created for the credentials, including the entity that issued the session.

Show child fields
findings[].policy_details.actor.user_identity.federated_user.session_context.attributes

The date and time when the credentials were issued, and whether the credentials were authenticated with a multi-factor authentication (MFA) device.

Show child fields
findings[].policy_details.actor.user_identity.federated_user.session_context.attributes.creation_date

The date and time, in UTC and ISO 8601 format, when the credentials were issued.

findings[].policy_details.actor.user_identity.federated_user.session_context.attributes.mfa_authenticated

Specifies whether the credentials were authenticated with a multi-factor authentication (MFA) device.

findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer

The source and type of credentials that were issued to the entity.

Show child fields
findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer.account_id

The unique identifier for the Amazon Web Services account that owns the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer.arn

The Amazon Resource Name (ARN) of the source account, Identity and Access Management (IAM) user, or role that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer.principal_id

The unique identifier for the entity that was used to get the credentials.

findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer.type

The source of the temporary security credentials, such as Root, IAMUser, or Role.

findings[].policy_details.actor.user_identity.federated_user.session_context.session_issuer.user_name

The name or alias of the user or role that issued the session. This value is null if the credentials were obtained from a root account that doesn't have an alias.

findings[].policy_details.actor.user_identity.iam_user

If the action was performed using the credentials for an Identity and Access Management (IAM) user, the name and other details about the user.

Show child fields
findings[].policy_details.actor.user_identity.iam_user.account_id

The unique identifier for the Amazon Web Services account that's associated with the IAM user who performed the action.

findings[].policy_details.actor.user_identity.iam_user.arn

The Amazon Resource Name (ARN) of the principal that performed the action. The last section of the ARN contains the name of the user who performed the action.

findings[].policy_details.actor.user_identity.iam_user.principal_id

The unique identifier for the IAM user who performed the action.

findings[].policy_details.actor.user_identity.iam_user.user_name

The username of the IAM user who performed the action.

findings[].policy_details.actor.user_identity.root

If the action was performed using the credentials for your Amazon Web Services account, the details of your account.

Show child fields
findings[].policy_details.actor.user_identity.root.account_id

The unique identifier for the Amazon Web Services account.

findings[].policy_details.actor.user_identity.root.arn

The Amazon Resource Name (ARN) of the principal that performed the action. The last section of the ARN contains the name of the user or role that performed the action.

findings[].policy_details.actor.user_identity.root.principal_id

The unique identifier for the entity that performed the action.

findings[].policy_details.actor.user_identity.type

The type of entity that performed the action.

findings[].region

The Amazon Web Services Region that Amazon Macie created the finding in.

findings[].resources_affected

The resources that the finding applies to.

Show child fields
findings[].resources_affected.s3_bucket

The details of the S3 bucket that the finding applies to.

Show child fields
findings[].resources_affected.s3_bucket.allows_unencrypted_object_uploads

Specifies whether the bucket policy for the bucket requires server-side encryption of objects when objects are added to the bucket. Possible values are:

  • FALSE - The bucket policy requires server-side encryption of new objects. PutObject requests must include a valid server-side encryption header.

  • TRUE - The bucket doesn't have a bucket policy or it has a bucket policy that doesn't require server-side encryption of new objects. If a bucket policy exists, it doesn't require PutObject requests to include a valid server-side encryption header.

  • UNKNOWN - Amazon Macie can't determine whether the bucket policy requires server-side encryption of new objects.

Valid server-side encryption headers are: x-amz-server-side-encryption with a value of AES256 or aws:kms, and x-amz-server-side-encryption-customer-algorithm with a value of AES256.

findings[].resources_affected.s3_bucket.arn

The Amazon Resource Name (ARN) of the bucket.

findings[].resources_affected.s3_bucket.created_at

The date and time, in UTC and extended ISO 8601 format, when the bucket was created. This value can also indicate when changes such as edits to the bucket's policy were most recently made to the bucket, relative to when the finding was created or last updated.

findings[].resources_affected.s3_bucket.default_server_side_encryption

The default server-side encryption settings for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.default_server_side_encryption.encryption_type

The server-side encryption algorithm that's used when storing data in the bucket or object. If default encryption settings aren't configured for the bucket or the object isn't encrypted using server-side encryption, this value is NONE.

findings[].resources_affected.s3_bucket.default_server_side_encryption.kms_master_key_id

The Amazon Resource Name (ARN) or unique identifier (key ID) for the KMS key that's used to encrypt data in the bucket or the object. This value is null if an KMS key isn't used to encrypt the data.

findings[].resources_affected.s3_bucket.name

The name of the bucket.

findings[].resources_affected.s3_bucket.owner

The display name and canonical user ID for the Amazon Web Services account that owns the bucket.

Show child fields
findings[].resources_affected.s3_bucket.owner.display_name

The display name of the account that owns the bucket.

findings[].resources_affected.s3_bucket.owner.id

The canonical user ID for the account that owns the bucket.

findings[].resources_affected.s3_bucket.public_access

The permissions settings that determine whether the bucket is publicly accessible.

Show child fields
findings[].resources_affected.s3_bucket.public_access.effective_permission

Specifies whether the bucket is publicly accessible due to the combination of permissions settings that apply to the bucket. Possible values are:

  • NOT_PUBLIC - The bucket isn't publicly accessible.

  • PUBLIC - The bucket is publicly accessible.

  • UNKNOWN - Amazon Macie can't determine whether the bucket is publicly accessible.

findings[].resources_affected.s3_bucket.public_access.permission_configuration

The account-level and bucket-level permissions settings for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions

The account-level permissions settings that apply to the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions.block_public_access

The block public access settings for the Amazon Web Services account that owns the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions.block_public_access.block_public_acls

Specifies whether Amazon S3 blocks public access control lists (ACLs) for the bucket and objects in the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions.block_public_access.block_public_policy

Specifies whether Amazon S3 blocks public bucket policies for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions.block_public_access.ignore_public_acls

Specifies whether Amazon S3 ignores public ACLs for the bucket and objects in the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.account_level_permissions.block_public_access.restrict_public_buckets

Specifies whether Amazon S3 restricts public bucket policies for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions

The bucket-level permissions settings for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.access_control_list

The permissions settings of the access control list (ACL) for the bucket. This value is null if an ACL hasn't been defined for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.access_control_list.allows_public_read_access

Specifies whether the ACL grants the general public with read access permissions for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.access_control_list.allows_public_write_access

Specifies whether the ACL grants the general public with write access permissions for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.block_public_access

The block public access settings for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.block_public_access.block_public_acls

Specifies whether Amazon S3 blocks public access control lists (ACLs) for the bucket and objects in the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.block_public_access.block_public_policy

Specifies whether Amazon S3 blocks public bucket policies for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.block_public_access.ignore_public_acls

Specifies whether Amazon S3 ignores public ACLs for the bucket and objects in the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.block_public_access.restrict_public_buckets

Specifies whether Amazon S3 restricts public bucket policies for the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.bucket_policy

The permissions settings of the bucket policy for the bucket. This value is null if a bucket policy hasn't been defined for the bucket.

Show child fields
findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.bucket_policy.allows_public_read_access

Specifies whether the bucket policy allows the general public to have read access to the bucket.

findings[].resources_affected.s3_bucket.public_access.permission_configuration.bucket_level_permissions.bucket_policy.allows_public_write_access

Specifies whether the bucket policy allows the general public to have write access to the bucket.

findings[].resources_affected.s3_bucket.tags[]
Show child fields
findings[].resources_affected.s3_bucket.tags[].key

One part of a key-value pair that comprises a tag. A tag key is a general label that acts as a category for more specific tag values.

findings[].resources_affected.s3_bucket.tags[].value

One part of a key-value pair that comprises a tag. A tag value acts as a descriptor for a tag key. A tag value can be an empty string.

findings[].resources_affected.s3_object

The details of the S3 object that the finding applies to.

Show child fields
findings[].resources_affected.s3_object.bucket_arn

The Amazon Resource Name (ARN) of the bucket that contains the object.

findings[].resources_affected.s3_object.e_tag

The entity tag (ETag) that identifies the affected version of the object. If the object was overwritten or changed after Amazon Macie produced the finding, this value might be different from the current ETag for the object.

findings[].resources_affected.s3_object.extension

The file name extension of the object. If the object doesn't have a file name extension, this value is "".

findings[].resources_affected.s3_object.key

The full name (key) of the object, including the object's prefix if applicable.

findings[].resources_affected.s3_object.last_modified

The date and time, in UTC and extended ISO 8601 format, when the object was last modified.

findings[].resources_affected.s3_object.path

The full path to the affected object, including the name of the affected bucket and the object's name (key).

findings[].resources_affected.s3_object.public_access

Specifies whether the object is publicly accessible due to the combination of permissions settings that apply to the object.

findings[].resources_affected.s3_object.server_side_encryption

The type of server-side encryption that was used to encrypt the object.

Show child fields
findings[].resources_affected.s3_object.server_side_encryption.encryption_type

The server-side encryption algorithm that's used when storing data in the bucket or object. If default encryption settings aren't configured for the bucket or the object isn't encrypted using server-side encryption, this value is NONE.

findings[].resources_affected.s3_object.server_side_encryption.kms_master_key_id

The Amazon Resource Name (ARN) or unique identifier (key ID) for the KMS key that's used to encrypt data in the bucket or the object. This value is null if an KMS key isn't used to encrypt the data.

findings[].resources_affected.s3_object.size

The total storage size, in bytes, of the object.

findings[].resources_affected.s3_object.storage_class

The storage class of the object.

findings[].resources_affected.s3_object.tags[]
Show child fields
findings[].resources_affected.s3_object.tags[].key

One part of a key-value pair that comprises a tag. A tag key is a general label that acts as a category for more specific tag values.

findings[].resources_affected.s3_object.tags[].value

One part of a key-value pair that comprises a tag. A tag value acts as a descriptor for a tag key. A tag value can be an empty string.

findings[].resources_affected.s3_object.version_id

The identifier for the affected version of the object.

findings[].sample

Specifies whether the finding is a sample finding. A sample finding is a finding that uses example data to demonstrate what a finding might contain.

findings[].schema_version

The version of the schema that was used to define the data structures in the finding.

findings[].severity

The severity level and score for the finding.

Show child fields
findings[].severity.description

The qualitative representation of the finding's severity, ranging from Low (least severe) to High (most severe).

findings[].severity.score

The numerical representation of the finding's severity, ranging from 1 (least severe) to 3 (most severe).

findings[].title

The brief description of the finding.

findings[].type

The type of the finding.

findings[].updated_at

The date and time, in UTC and extended ISO 8601 format, when Amazon Macie last updated the finding. For sensitive data findings, this value is the same as the value for the createdAt property. All sensitive data findings are considered new.