Resources - Resources

Mengkueri sumber daya yang dikelola oleh Azure Resource Manager untuk cakupan yang ditentukan dalam permintaan.

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

Parameter URI

Name In Required Type Description
api-version
query True
  • string

Versi Api.

Isi Permintaan

Name Required Type Description
query True
  • string

Kueri sumber daya.

facets

Array permintaan faset yang akan dihitung terhadap hasil kueri.

managementGroups
  • string[]

Grup manajemen Azure untuk menjalankan kueri. Contoh: [ 'mg1', 'mg2' ]

options

Opsi evaluasi kueri

subscriptions
  • string[]

Langganan Azure untuk menjalankan kueri.

Respons

Name Type Description
200 OK

Hasil operasi kueri

Other Status Codes

Terjadi kesalahan saat memproses permintaan ini. Lihat parameter error.code untuk mengidentifikasi kesalahan tertentu.

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

Access a properties field
Basic management group query
Basic query
Basic tenant query
Complex query
Filter resources
First page query
Next page query
Query with a facet request
Random page query
Summarize resources by location

Access a properties field

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | where type =~ 'Microsoft.Compute/virtualMachines' | summarize count() by tostring(properties.storageProfile.osDisk.osType)"
}

Sample Response

{
  "totalRecords": 2,
  "count": 2,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "properties_storageProfile_osDisk_osType": "Linux",
      "count": 7
    },
    {
      "properties_storageProfile_osDisk_osType": "Windows",
      "count": 23
    }
  ]
}

Basic management group query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "managementGroups": [
    "e927f598-c1d4-4f72-8541-95d83a6a4ac8",
    "ProductionMG"
  ],
  "query": "Resources | project id, name, type, location, tags | limit 3"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Network/networkInterfaces/myNetworkInterface",
      "name": "myNetworkInterface",
      "type": "microsoft.network/networkinterfaces",
      "location": "centralus",
      "tags": {
        "tag1": "Value1"
      }
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/virtualNetworks/myVnet",
      "name": "myVnet",
      "type": "microsoft.network/virtualnetworks",
      "location": "westus",
      "tags": {}
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/publicIPAddresses/myPublicIp",
      "name": "myPublicIp",
      "type": "microsoft.network/publicipaddresses",
      "location": "westus",
      "tags": {}
    }
  ]
}

Basic query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | project id, name, type, location, tags | limit 3"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Network/networkInterfaces/myNetworkInterface",
      "name": "myNetworkInterface",
      "type": "microsoft.network/networkinterfaces",
      "location": "centralus",
      "tags": {
        "tag1": "Value1"
      }
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/virtualNetworks/myVnet",
      "name": "myVnet",
      "type": "microsoft.network/virtualnetworks",
      "location": "westus",
      "tags": {}
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/publicIPAddresses/myPublicIp",
      "name": "myPublicIp",
      "type": "microsoft.network/publicipaddresses",
      "location": "westus",
      "tags": {}
    }
  ]
}

Basic tenant query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "query": "Resources | project id, name, type, location, tags | limit 3"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Network/networkInterfaces/myNetworkInterface",
      "name": "myNetworkInterface",
      "type": "microsoft.network/networkinterfaces",
      "location": "centralus",
      "tags": {
        "tag1": "Value1"
      }
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/virtualNetworks/myVnet",
      "name": "myVnet",
      "type": "microsoft.network/virtualnetworks",
      "location": "westus",
      "tags": {}
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Network/publicIPAddresses/myPublicIp",
      "name": "myPublicIp",
      "type": "microsoft.network/publicipaddresses",
      "location": "westus",
      "tags": {}
    }
  ]
}

Complex query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | project id, name, type, location | where type =~ 'Microsoft.Compute/virtualMachines' | summarize count() by location | top 3 by count_"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "location": "centralus",
      "count_": 11
    },
    {
      "location": "eastus",
      "count_": 11
    },
    {
      "location": "southcentralus",
      "count_": 3
    }
  ]
}

Filter resources

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | project id, name, type, location | where type =~ 'Microsoft.Compute/virtualMachines' | limit 3"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Compute/virtualMachines/myVm1",
      "name": "myVm1",
      "type": "microsoft.compute/virtualmachines",
      "location": "centralus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Compute/virtualMachines/myVirtualMachine",
      "name": "myVirtualMachine",
      "type": "microsoft.compute/virtualmachines",
      "location": "eastus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG3/providers/Microsoft.Compute/virtualMachines/testVm",
      "name": "testVm",
      "type": "microsoft.compute/virtualmachines",
      "location": "eastus"
    }
  ]
}

First page query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | where name contains 'test' | project id, name, type, location",
  "options": {
    "$top": 3,
    "$skip": 0
  }
}

Sample Response

{
  "totalRecords": 386,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "$skipToken": "eyAibm8iOiAibHVjayIsICJidXQiOiAibmljZSIsICJ0cnkiOiAiISIgfQ==",
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Compute/disks/yetanothertest_OsDisk_1_f396cbcb625a457bb69fe2abf5975820",
      "name": "yetanothertest_OsDisk_1_f396cbcb625a457bb69fe2abf5975820",
      "type": "microsoft.compute/disks",
      "location": "eastus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Automation/automationAccounts/TestAA",
      "name": "TestAA",
      "type": "microsoft.automation/automationaccounts",
      "location": "westcentralus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Automation/automationAccounts/TestAA/runbooks/TestRB",
      "name": "TestRB",
      "type": "microsoft.automation/automationaccounts/runbooks",
      "location": "westcentralus"
    }
  ]
}

Next page query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | where name contains 'test' | project id, name, type, location",
  "options": {
    "$skipToken": "eyAibm8iOiAibHVjayIsICJidXQiOiAibmljZSIsICJ0cnkiOiAiISIgfQ=="
  }
}

Sample Response

{
  "totalRecords": 386,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "$skipToken": "eyAibm8yIjogImx1Y2syIiwgImJ1dDIiOiAibmljZTIiLCAidHJ5MiI6ICIhIiB9",
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Compute/disks/second_OsDisk_dddddbcb625a457bb69fe2abf5975820",
      "name": "second_OsDisk_dddddbcb625a457bb69fe2abf5975820",
      "type": "microsoft.compute/disks",
      "location": "eastus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Automation/automationAccounts/AATest",
      "name": "AATest",
      "type": "microsoft.automation/automationaccounts",
      "location": "westcentralus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Automation/automationAccounts/TestAA/runbooks/RBTest",
      "name": "RBTest",
      "type": "microsoft.automation/automationaccounts/runbooks",
      "location": "westcentralus"
    }
  ]
}

Query with a facet request

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | where type =~ 'Microsoft.Compute/virtualMachines' | project id, name, location, resourceGroup, properties.storageProfile.osDisk.osType | limit 5",
  "facets": [
    {
      "expression": "location",
      "options": {
        "sortOrder": "desc",
        "$top": 3
      }
    },
    {
      "expression": "properties.storageProfile.osDisk.osType",
      "options": {
        "sortOrder": "desc",
        "$top": 3
      }
    },
    {
      "expression": "nonExistingColumn",
      "options": {
        "sortOrder": "desc",
        "$top": 3
      }
    },
    {
      "expression": "resourceGroup",
      "options": {
        "sortBy": "tolower(resourceGroup)",
        "sortOrder": "asc",
        "$top": 3
      }
    },
    {
      "expression": "resourceGroup",
      "options": {
        "filter": "resourceGroup contains 'test'",
        "$top": 3
      }
    }
  ]
}

Sample Response

{
  "totalRecords": 5,
  "count": 5,
  "resultTruncated": "false",
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/B-TEST-RG/providers/Microsoft.Compute/virtualMachines/myTestVm",
      "name": "myTestVm",
      "location": "eastus",
      "resourceGroup": "B-TEST-RG",
      "properties_storageProfile_osDisk_osType": "Windows"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/c-rg/providers/Microsoft.Compute/virtualMachines/myTestAccountVm",
      "name": "myTestAccountVm",
      "location": "westcentralus",
      "resourceGroup": "c-rg",
      "properties_storageProfile_osDisk_osType": "Windows"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/I-RG/providers/Microsoft.Compute/virtualMachines/yetanothertest",
      "name": "yetanothertest",
      "location": "eastus",
      "resourceGroup": "I-RG",
      "properties_storageProfile_osDisk_osType": "Linux"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/x-test-rg/providers/Microsoft.Compute/virtualMachines/drafttest1bux4cv7a7q3aw",
      "name": "drafttest1bux4cv7a7q3aw",
      "location": "southcentralus",
      "resourceGroup": "x-test-rg",
      "properties_storageProfile_osDisk_osType": "Linux"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/y-rg/providers/Microsoft.Compute/virtualMachines/testvmntp25370",
      "name": "testvmntp25370",
      "location": "eastus",
      "resourceGroup": "y-rg",
      "properties_storageProfile_osDisk_osType": "Windows"
    }
  ],
  "facets": [
    {
      "expression": "location",
      "resultType": "FacetResult",
      "totalRecords": 3,
      "count": 3,
      "data": [
        {
          "location": "eastus",
          "count": 3
        },
        {
          "location": "southcentralus",
          "count": 1
        },
        {
          "location": "westcentralus",
          "count": 1
        }
      ]
    },
    {
      "expression": "properties.storageProfile.osDisk.osType",
      "resultType": "FacetResult",
      "totalRecords": 2,
      "count": 2,
      "data": [
        {
          "properties_storageProfile_osDisk_osType": "Linux",
          "count": 2
        },
        {
          "properties_storageProfile_osDisk_osType": "Windows",
          "count": 3
        }
      ]
    },
    {
      "expression": "nonExistingColumn",
      "resultType": "FacetError",
      "errors": [
        {
          "code": "NoValidColumns",
          "message": "No valid columns in facet expression."
        },
        {
          "code": "InvalidColumnNames",
          "message": "Invalid column names: [nonExistingColumn]."
        }
      ]
    },
    {
      "expression": "resourceGroup",
      "resultType": "FacetResult",
      "totalRecords": 5,
      "count": 3,
      "data": [
        {
          "resourceGroup": "B-TEST-RG",
          "count": 1
        },
        {
          "resourceGroup": "c-rg",
          "count": 1
        },
        {
          "resourceGroup": "I-RG",
          "count": 1
        }
      ]
    },
    {
      "expression": "resourceGroup",
      "resultType": "FacetResult",
      "totalRecords": 2,
      "count": 2,
      "data": [
        {
          "resourceGroup": "B-TEST-RG",
          "count": 1
        },
        {
          "resourceGroup": "x-test-rg",
          "count": 1
        }
      ]
    }
  ]
}

Random page query

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | where name contains 'test' | project id, name, type, location",
  "options": {
    "$top": 2,
    "$skip": 10
  }
}

Sample Response

{
  "totalRecords": 386,
  "count": 2,
  "resultTruncated": "false",
  "facets": [],
  "$skipToken": "eyAibm8iOiAibHVjayIsICJidXQiOiAibmljZSIsICJ0cnkiOiAiISIgfQ==",
  "data": [
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG1/providers/Microsoft.Compute/disks/third_OsDisk_dddddbcb625a457bb69fe2abf5975820",
      "name": "third_OsDisk_dddddbcb625a457bb69fe2abf5975820",
      "type": "microsoft.compute/disks",
      "location": "eastus"
    },
    {
      "id": "/subscriptions/cfbbd179-59d2-4052-aa06-9270a38aa9d6/resourceGroups/RG2/providers/Microsoft.Automation/automationAccounts/CCTest",
      "name": "CCTest",
      "type": "microsoft.automation/automationaccounts",
      "location": "westcentralus"
    }
  ]
}

Summarize resources by location

Sample Request

POST https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2021-03-01

{
  "subscriptions": [
    "cfbbd179-59d2-4052-aa06-9270a38aa9d6"
  ],
  "query": "Resources | project id, name, type, location | summarize by location"
}

Sample Response

{
  "totalRecords": 3,
  "count": 3,
  "resultTruncated": "false",
  "facets": [],
  "data": [
    {
      "location": "centralus"
    },
    {
      "location": "eastus"
    },
    {
      "location": "westus"
    }
  ]
}

Definisi

Error

Info kesalahan.

ErrorDetails

Detail kesalahan.

ErrorResponse

Respons kesalahan.

FacetError

Faset yang eksekusinya mengakibatkan kesalahan.

FacetRequest

Permintaan untuk menghitung statistik tambahan (faset) atas hasil kueri.

FacetRequestOptions

Opsi untuk evaluasi faset

FacetResult

Faset yang berhasil dijalankan berisi statistik tambahan pada respons kueri.

FacetSortOrder

Urutan pengurutan menurut kolom yang dipilih (hitung secara default).

QueryRequest

Menjelaskan kueri yang akan dijalankan.

QueryRequestOptions

Opsi untuk evaluasi kueri

QueryResponse

Hasil kueri.

ResultFormat

Menentukan hasil kueri format yang dikembalikan.

ResultTruncated

Menunjukkan apakah hasil kueri terpotong.

Error

Info kesalahan.

Name Type Description
code
  • string

Kode kesalahan yang mengidentifikasi kesalahan tertentu.

details

Detail kesalahan

message
  • string

Pesan kesalahan yang dapat dibaca manusia.

ErrorDetails

Detail kesalahan.

Name Type Description
code
  • string

Kode kesalahan yang mengidentifikasi kesalahan tertentu.

message
  • string

Pesan kesalahan yang dapat dibaca manusia.

ErrorResponse

Respons kesalahan.

Name Type Description
error

Info kesalahan.
Informasi kesalahan.

FacetError

Faset yang eksekusinya mengakibatkan kesalahan.

Name Type Description
errors

Array yang berisi kesalahan faset yang terdeteksi dengan detail.

expression
  • string

Ekspresi faset, sama seperti dalam permintaan faset yang sesuai.

resultType string:

Jenis Hasil

FacetRequest

Permintaan untuk menghitung statistik tambahan (faset) atas hasil kueri.

Name Type Description
expression
  • string

Kolom atau daftar kolom yang akan diringkas menurut

options

Opsi untuk evaluasi faset

FacetRequestOptions

Opsi untuk evaluasi faset

Name Type Default Value Description
$top
  • integer

Jumlah maksimum baris faset yang harus dikembalikan.

filter
  • string

Menentukan kondisi filter untuk klausa 'where' yang akan dijalankan pada hasil kueri utama, tepat sebelum faset aktual.

sortBy
  • string

Nama kolom atau ekspresi kueri untuk diurutkan. Default untuk dihitung jika tidak ada.

sortOrder desc

Urutan pengurutan menurut kolom yang dipilih (hitung secara default).

FacetResult

Faset yang berhasil dijalankan berisi statistik tambahan pada respons kueri.

Name Type Description
count
  • integer

Jumlah rekaman yang dikembalikan dalam respons faset.

data
  • object

Array JObject atau Tabel yang berisi faset yang diinginkan. Hanya ada jika faset valid.

expression
  • string

Ekspresi faset, sama seperti dalam permintaan faset yang sesuai.

resultType string:

Jenis Hasil

totalRecords
  • integer

Jumlah total rekaman dalam hasil faset.

FacetSortOrder

Urutan pengurutan menurut kolom yang dipilih (hitung secara default).

Name Type Description
asc
  • string
desc
  • string

QueryRequest

Menjelaskan kueri yang akan dijalankan.

Name Type Description
facets

Array permintaan faset yang akan dihitung terhadap hasil kueri.

managementGroups
  • string[]

Grup manajemen Azure untuk menjalankan kueri. Contoh: [ 'mg1', 'mg2' ]

options

Opsi evaluasi kueri

query
  • string

Kueri sumber daya.

subscriptions
  • string[]

Langganan Azure untuk menjalankan kueri.

QueryRequestOptions

Opsi untuk evaluasi kueri

Name Type Default Value Description
$skip
  • integer

Jumlah baris yang akan dilewati dari awal hasil. Mengambil alih offset halaman berikutnya saat $skipToken properti ada.

$skipToken
  • string

Token kelanjutan untuk penomoran halaman, menangkap ukuran dan offset halaman berikutnya, serta konteks kueri.

$top
  • integer

Jumlah maksimum baris yang harus dikembalikan kueri. Mengambil alih ukuran halaman saat $skipToken properti ada.

allowPartialScopes
  • boolean
False

Hanya berlaku untuk kueri tingkat penyewa dan grup manajemen untuk memutuskan apakah akan mengizinkan cakupan parsial jika jumlah langganan melebihi batas yang diizinkan.

resultFormat objectArray

Menentukan hasil kueri format yang dikembalikan.

QueryResponse

Hasil kueri.

Name Type Description
$skipToken
  • string

Saat ada, nilai dapat diteruskan ke panggilan kueri berikutnya (bersama dengan kueri dan cakupan yang sama yang digunakan dalam permintaan saat ini) untuk mengambil halaman data berikutnya.

count
  • integer

Jumlah rekaman yang dikembalikan dalam respons saat ini. Dalam kasus penomoran halaman, ini adalah jumlah rekaman di halaman saat ini.

data
  • object

Output kueri dalam array JObject atau format Tabel.

facets Facet[]:

Faset kueri.

resultTruncated

Menunjukkan apakah hasil kueri terpotong.

totalRecords
  • integer

Jumlah total rekaman yang cocok dengan kueri.

ResultFormat

Menentukan hasil kueri format yang dikembalikan.

Name Type Description
objectArray
  • string
table
  • string

ResultTruncated

Menunjukkan apakah hasil kueri terpotong.

Name Type Description
false
  • string
true
  • string