Query: List of EC2 instances provisioned with undesired(for example t2.large and m3.medium is desired) instance type(s).

Description

Identify instances where EC2 instances have been provisioned with types other than the desired ones, such as t2.large and m3.medium. This can help you manage your resources more effectively by spotting any instances that may not meet your specific needs or standards.

Query

Tables used in this query:

• aws_ec2_instance

SQL