Query: Autoscaling groups with availability zone count less than 2

Description

Identify autoscaling groups that may not be optimally configured for high availability due to having less than two availability zones. This can be useful to improve fault tolerance and ensure uninterrupted service.

Query

Tables used in this query:

• aws_ec2_autoscaling_group

SQL