Mengkueri log di sebuah proyek. Anda dapat menggunakan operasi ini untuk mengkueri log di tingkat proyek.
Deskripsi operasi
Usage notes
-
Host consists of a project name and a Simple Log Service endpoint. You must specify a project in Host.
-
An AccessKey pair is created and obtained. For more information, see AccessKey pair.
The AccessKey pair of an Alibaba Cloud account has permissions on all API operations. Using these credentials to perform operations in Simple Log Service is a high-risk operation. We recommend that you use a Resource Access Management (RAM) user to call API operations or perform routine O&M. To create a RAM user, log on to the RAM console. Make sure that the RAM user has the management permissions on Simple Log Service resources. For more information, see Create a RAM user and authorize the RAM user to access Simple Log Service.
-
The information that is required to query logs is obtained. The information includes the name of the project to which the logs belong and the region of the project. For more information, see Manage a project.
-
Indexes are configured before you query logs. For more information, see Create indexes.
-
Limits are imposed when you use Simple Log Service to query logs. We recommend that you specify query statements and query time ranges based on the limits. For more information, see Log search overview and Log analysis overview.
-
You must set query to a standard SQL statement.
-
You must specify a Logstore in the FROM clause of an SQL statement. A Logstore can be used as an SQL table.
-
You must specify a time range in an SQL statement by using the __date__ or __time__ parameter. The value of the __date__ parameter is a timestamp. The value of the __time__ parameter is an integer, and the unit of the value is seconds.
Authentication resources
The following table describes the authorization information that is required for this operation. You can add the information to the Action element of a RAM policy statement to grant a RAM user or a RAM role the permissions to call this operation.
| Action | Resource |
log:GetProjectLogs | acs:log:{#regionId}:{#accountId}:project/{#ProjectName} |
Coba sekarang
Test
RAM authorization
Sintaks permintaan
GET /logs HTTP/1.1
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| project |
string |
Yes |
Nama proyek. |
ali-test-project |
| query |
string |
Yes |
Pernyataan SQL Standar. Dalam contoh ini, pernyataan SQL mengkueri jumlah tampilan halaman (PV) dari 2022-03-01 10:41:40 hingga 2022-03-01 10:56:40 di penyimpanan log bernama nginx-moni. |
SELECT COUNT(*) as pv FROM nginx-moni where __time__ > 1646102500 and __time__ < 1646103400 |
| powerSql |
boolean |
No |
Apakah akan mengaktifkan fitur SQL Khusus. Untuk informasi lebih lanjut, lihat Enable Dedicated SQL. Nilai valid:
Anda dapat menggunakan parameter powerSql atau query untuk mengonfigurasi SQL Khusus. |
false |
Contoh permintaan
GET /logs?query=SELECT COUNT(*) as pv FROM nginx-moni where time > 1646102500 and time < 1646103400&powerSql=false HTTP/1.1 Host:ali-test-project.ch-hangzhou.log.aliyuncs.com Content-Type:application/json
Elemen respons
|
Element |
Type |
Description |
Example |
|
array |
The logs that are returned. |
||
|
object |
The log that is returned. |
[ { "__time__" : 1409529660, "__source__" : "192.168.1.100", "Key1" : "error", "Key2" : "Value2" }, { "__time__" : 1409529680, "__source__" : "192.168.1.100", "Key3" : "error", "Key4" : "Value4" } ] |
|
|
string |
The log that is returned. |
[ { "__time__" : 1409529660, "__source__" : "192.168.1.100", "Key1" : "error", "Key2" : "Value2" }, { "__time__" : 1409529680, "__source__" : "192.168.1.100", "Key3" : "error", "Key4" : "Value4" } ] |
Contoh
Respons sukses
JSONformat
[
{
"key": "[ { \"__time__\" : 1409529660, \"__source__\" : \"192.168.1.100\", \"Key1\" : \"error\", \"Key2\" : \"Value2\" }, { \"__time__\" : 1409529680, \"__source__\" : \"192.168.1.100\", \"Key3\" : \"error\", \"Key4\" : \"Value4\" } ]"
}
]
Kode kesalahan
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.