Query: List of disks having no attached running instances

Description

Determine the areas in which disks are not being utilized by identifying instances where disks are not attached to any running instances. This query is useful in pinpointing potential resources that may be underutilized or misallocated, helping optimize resource allocation and potentially reducing costs.

Query

Tables used in this query:

• alicloud_ecs_disk

SQL