Overview

Advanced queries allow you to query your resource configuration states for one or more regions using ResourceQL.

You can conveniently use ResourceQL and a query editor to search for and view your resources.

ResourceQL is a subset of structured query language (SQL) SELECT syntax to help you perform property-based queries and aggregations. The query complexity varies. You can query resources by tag or resource identifier, or by using complex SQL statements. For example, you can query an ECS with a specified OS version.

You can use Advanced Queries to:

• Manage inventory. For example, you can query ECSs with certain specifications.
• Check security compliance of your resources. For example, you can check if the configurations (public IPs attached or disks encrypted) of your resources meet security requirements.
• Optimize costs. For example, you can list all EVS disks that have not been attached to any ECS to avoid unnecessary expenditures.

You can only use advanced queries to query, view, or export cloud resources. If you need to modify or delete resources, go to related service consoles.

Constraints

To prevent a single user from occupying resources for a long time, the advanced query function is restricted as follows:

• If the execution duration of a query statement exceeds 15 seconds, a timeout error will be returned.
• If the result set is too large, an error will occur. Make sure that the data volume returned by each statement is within the size limit.
• The system only returns up to 4,000 records for a single query.
• A single query statement can execute no more than two join queries.
• Each account can perform a maximum of 200 advanced queries.

To get full functionality of advanced queries, you need to enable the resource recorder. The following describes how the resource recorder may affect your use of advanced queries.

• If you have never enabled the resource recorder, no resources are available for advanced queries.
• If you have enabled the resource recorder and a monitoring scope is specified, only resources within that scope are available for advanced queries.
• If you have enabled the resource recorder and disabled it after a period of time, only resource data collected during the period when the resource recorder was enabled is available for advanced queries.

For details about how to enable and configure the resource recorder, see Configuring the Resource Recorder.