Query - Get
Menjalankan kueri Analytics
Menjalankan kueri Analitik untuk data
GET https://api.loganalytics.io/v1/workspaces/{workspaceId}/query?query={query}GET https://api.loganalytics.io/v1/workspaces/{workspaceId}/query?query={query}×pan={timespan}Parameter URI
| Name | In | Required | Type | Description |
|---|---|---|---|---|
|
workspace
|
path | True |
|
ID ruang kerja. Ini adalah ID Ruang Kerja dari bilah Properti di portal Azure. |
|
query
|
query | True |
|
Kueri Analitik. Pelajari selengkapnya tentang sintaks kueri Analytics |
|
timespan
|
query |
|
Opsional. Rentang waktu untuk mengkueri data. Ini adalah nilai periode waktu ISO8601. Rentang waktu ini diterapkan selain yang ditentukan dalam ekspresi kueri. |
Respons
| Name | Type | Description |
|---|---|---|
| 200 OK |
OK. Panggilan API berhasil dan hasil kueri Analytics berada dalam payload respons |
|
| Other Status Codes |
Objek respons kesalahan. |
Keamanan
azure_auth
Azure Active Directory Flow OAuth2
Type:
oauth2
Flow:
implicit
Authorization URL:
https://login.microsoftonline.com/common/oauth2/authorize
Scopes
| Name | Description |
|---|---|
| user_impersonation | meniru akun pengguna Anda |
Contoh
| cross-workspace |
| simple-query |
cross-workspace
Sample Request
GET https://api.loganalytics.io/v1/workspaces/63613592-b6f7-4c3d-a390-22ba13102111/query?query=union * | where TimeGenerated > ago(1h) | summarize count() by Type, TenantId
Sample Response
{
"tables": [
{
"name": "PrimaryResult",
"columns": [
{
"name": "Type",
"type": "string"
},
{
"name": "TenantId",
"type": "string"
},
{
"name": "count_",
"type": "long"
}
],
"rows": [
[
"Usage",
"63613592-b6f7-4c3d-a390-22ba13102111",
"1"
],
[
"Usage",
"d436f322-a9f4-4aad-9a7d-271fbf66001c",
"1"
],
[
"BillingFact",
"63613592-b6f7-4c3d-a390-22ba13102111",
"1"
],
[
"BillingFact",
"d436f322-a9f4-4aad-9a7d-271fbf66001c",
"1"
],
[
"Operation",
"63613592-b6f7-4c3d-a390-22ba13102111",
"7"
],
[
"Operation",
"d436f322-a9f4-4aad-9a7d-271fbf66001c",
"5"
]
]
}
]
}simple-query
Sample Request
GET https://api.loganalytics.io/v1/workspaces/63613592-b6f7-4c3d-a390-22ba13102111/query?query=Usage | take 10×pan=PT12H
Sample Response
x-ms-request-id: 58a37988-2c05-427a-891f-5e0e1266fcc5
x-ms-correlation-request-id: 58a37988-2c05-427a-891f-5e0e1266fcc5{
"tables": [
{
"name": "PrimaryResult",
"columns": [
{
"name": "TenantId",
"type": "string"
},
{
"name": "Computer",
"type": "string"
},
{
"name": "TimeGenerated",
"type": "datetime"
},
{
"name": "SourceSystem",
"type": "string"
},
{
"name": "StartTime",
"type": "datetime"
},
{
"name": "EndTime",
"type": "datetime"
},
{
"name": "ResourceUri",
"type": "string"
},
{
"name": "LinkedResourceUri",
"type": "string"
},
{
"name": "DataType",
"type": "string"
},
{
"name": "Solution",
"type": "string"
},
{
"name": "BatchesWithinSla",
"type": "long"
},
{
"name": "BatchesOutsideSla",
"type": "long"
},
{
"name": "BatchesCapped",
"type": "long"
},
{
"name": "TotalBatches",
"type": "long"
},
{
"name": "AvgLatencyInSeconds",
"type": "real"
},
{
"name": "Quantity",
"type": "real"
},
{
"name": "QuantityUnit",
"type": "string"
},
{
"name": "IsBillable",
"type": "bool"
},
{
"name": "MeterId",
"type": "string"
},
{
"name": "LinkedMeterId",
"type": "string"
},
{
"name": "Type",
"type": "string"
}
],
"rows": [
[
"b438b4f6-912a-46d5-9cb1-b44069212abc",
"ContosoSQLSrv1",
"2017-08-24T06:59:59Z",
"OMS",
"2017-08-24T06:00:00Z",
"2017-08-24T06:59:59Z",
"/subscriptions/e4272367-5645-4c4e-9c67-3b74b59a6982/resourcegroups/contosoazurehq/providers/microsoft.operationalinsights/workspaces/contosoretail-it",
null,
"Perf",
"LogManagement",
"1",
"0",
"0",
"1",
"1.286",
"0.076408",
"MBytes",
"true",
"a4e29a95-5b4c-408b-80e3-113f9410566e",
"00000000-0000-0000-0000-000000000000",
"Usage"
],
[
"b438b4f6-912a-46d5-9cb1-b44069212abc",
"Store010Web3",
"2017-08-24T06:59:59Z",
"OMS",
"2017-08-24T06:00:00Z",
"2017-08-24T06:59:59Z",
"/subscriptions/e4272367-5645-4c4e-9c67-3b74b59a6982/resourcegroups/contosoazurehq/providers/microsoft.operationalinsights/workspaces/contosoretail-it",
null,
"Perf",
"LogManagement",
"1",
"0",
"0",
"1",
"1.7",
"0.106767",
"MBytes",
"true",
"a4e29a95-5b4c-408b-80e3-113f9410566e",
"00000000-0000-0000-0000-000000000000",
"Usage"
]
]
}
]
}Definisi
| column |
Kolom tabel. |
|
error |
Detail kesalahan. |
|
error |
Kode dan pesan untuk kesalahan. |
|
error |
Detail kesalahan. |
|
query |
Respons kueri. |
| table |
Tabel respons kueri. |
column
Kolom tabel.
| Name | Type | Description |
|---|---|---|
| name |
|
Nama kolom ini. |
| type |
|
Jenis data kolom ini. |
errorDetail
Detail kesalahan.
| Name | Type | Description |
|---|---|---|
| additionalProperties |
|
Properti tambahan yang dapat disediakan pada objek detail kesalahan |
| code |
|
Kode kesalahan. |
| message |
|
Pesan kesalahan yang dapat dibaca manusia. |
| resources |
|
Menunjukkan sumber daya yang bertanggung jawab atas kesalahan tersebut. |
| target |
|
Menunjukkan properti mana dalam permintaan yang bertanggung jawab atas kesalahan tersebut. |
| value |
|
Menunjukkan nilai mana dalam 'target' yang bertanggung jawab atas kesalahan tersebut. |
errorInfo
Kode dan pesan untuk kesalahan.
| Name | Type | Description |
|---|---|---|
| additionalProperties |
|
Properti tambahan yang dapat disediakan pada objek info kesalahan |
| code |
|
Kode kesalahan yang dapat dibaca mesin. |
| details |
detail kesalahan. |
|
| innererror |
Kode dan pesan untuk kesalahan. |
|
| message |
|
Pesan kesalahan yang dapat dibaca manusia. |
errorResponse
Detail kesalahan.
| Name | Type | Description |
|---|---|---|
| error |
Kode dan pesan untuk kesalahan. |
queryResults
Respons kueri.
| Name | Type | Description |
|---|---|---|
| tables |
|
Daftar tabel, kolom, dan baris. |
table
Tabel respons kueri.
| Name | Type | Description |
|---|---|---|
| columns |
|
Daftar kolom dalam tabel ini. |
| name |
|
Nama tabel. |
| rows |
|
Baris yang dihasilkan dari kueri ini. |