Query: Find logstores with retention period less than 365 days

Description

Identify logstores that do not meet the recommended 365-day retention period for compliance purposes. This is useful for ensuring your log data is retained long enough for incident response and audit requirements, as specified in CIS benchmarks.

Query

Tables used in this query:

• alicloud_log_store

SQL