insights
Creates, updates, deletes, gets or lists an insights resource.
Overview
| Name | insights |
| Type | Resource |
| Id | aws.auditmanager.insights |
Fields
The following fields are returned by SELECT queries:
- get_insights
| Name | Datatype | Description |
|---|---|---|
active_assessments_count | integer | The number of active assessments in Audit Manager. |
assessment_controls_count_by_noncompliant_evidence | integer | The number of assessment controls that collected non-compliant evidence on the lastUpdated date. |
compliant_evidence_count | integer | The number of compliance check evidence that Audit Manager classified as compliant on the lastUpdated date. This includes evidence that was collected from Security Hub CSPM with a Pass ruling, or collected from Config with a Compliant ruling. |
inconclusive_evidence_count | integer | The number of evidence without a compliance check ruling. Evidence is inconclusive when the associated control uses Security Hub CSPM or Config as a data source but you didn't enable those services. This is also the case when a control uses a data source that doesn’t support compliance checks (for example: manual evidence, API calls, or CloudTrail). If evidence has a compliance check status of not applicable, it's classed as inconclusive in Insights data. |
last_updated | string (date-time) | The time when the cross-assessment insights were last updated. |
noncompliant_evidence_count | integer | The number of compliance check evidence that Audit Manager classified as non-compliant on the lastUpdated date. This includes evidence that was collected from Security Hub CSPM with a Fail ruling, or collected from Config with a Non-compliant ruling. |
total_assessment_controls_count | integer | The total number of controls across all active assessments. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get_insights | select | region | Gets the latest analytics data for all your current active assessments. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
region | string | AWS region (default: us-east-1) |
SELECT examples
- get_insights
Gets the latest analytics data for all your current active assessments.
SELECT
active_assessments_count,
assessment_controls_count_by_noncompliant_evidence,
compliant_evidence_count,
inconclusive_evidence_count,
last_updated,
noncompliant_evidence_count,
total_assessment_controls_count
FROM aws.auditmanager.insights
WHERE region = '{{ region }}' -- required
;