Query: Get the security group rules that allow inbound public access to all tcp or udp ports, along with instances attached to them

Description

This query is useful for identifying potential security vulnerabilities in your system. It reveals the security group rules that permit unrestricted inbound public access to all TCP or UDP ports, and also lists the instances associated with these rules. This can help in strengthening your system's security by pinpointing areas of potential weakness.

Query

Tables used in this query:

• alicloud_ecs_security_group

SQL