Execute a SELECT statement to search for resources by resource property fields, such as the memory of an Elastic Compute Service (ECS) instance.
Background information
Before you write a SELECT statement, obtain the field names and types from the properties file of the target resource type. For more information, see Alibaba Cloud Config Resource Schema.
Each resource type supported by Cloud Config has a properties file named after the resource type. For example, the properties file of the ACS::ECS::Instance resource type is named ACS_ECS_Instance.properties.json. All properties files are stored under the config/properties/resource-types path.
Procedure
Log on to the Cloud Config console.
Optional. In the upper-left corner, select an account group.
This operation is required only if you are using a management account of a resource directory. Otherwise, you do not need to perform the operation.
In the left-side navigation pane, choose .
-
On the Advanced page, click the SQL tab.
-
On the SQL tab, enter an SQL query statement.
-
Click Search.
The matching resources are returned.
NoteA maximum of 1,000 resources can be displayed in the resource list. To download all matching resources, click Download Search Result in the upper-right corner to export a CSV file.