Query: CloudTrail trails should have insight selectors and logging enabled

Description

CloudTrail Insights provides a powerful way to search and analyze CloudTrail log data using pre-built queries and machine learning algorithms. This can help to identify potential security threats and suspicious activity in near real-time, such as unauthorized access attempts, policy changes, or resource modifications.

Query

Tables used in this query:

• aws_cloudtrail_trail

Controls using this query:

• CloudTrail trails should have insight selectors and logging enabled

SQL