Compute Usage in KQL-CodePudding

I'm trying to get Compute Usage List using KQL in Azure, you can find it in above link for reference.

{
  "value": [
    {
      "unit": "Count",
      "currentValue": 17,
      "limit": 19,
      "name": {
        "value": "aaaaaaaaaaaaaaaaaa",
        "localizedValue": "aaaaaaaaaaaaaa"
      }
    }
  ],
  "nextLink": "aaaaaaaaaaaaaaaaaaaaaaaaaaa"
}

Thanks in advance.

What I'm expecting is where that type of data is located in which table.

CodePudding user response：

are you trying to query azure resource graph with KQL? The onboarding for compute usage to ARG is still going on. Currently only part of subscriptions are onboarded. But if you have access to the onboarded subscriptions, you will be able to see results in ARG with this query: quotaresources | where type contains "microsoft.compute/locations/usages" | limit 100

CodePudding user response：

As you added the reference MSDoc, one method for obtaining location usage details is through an API call to the specified Url.

Otherwise,

Compute Usage in KQL:

Search for Azure Resource Graph Explorer in the Azure Portal. All resource usage information can be checked and computed individually as well as with locations.

enter image description here

Go to the resources table under table section to see all the provider categories, as shown:

Eg: Disks resource usage:-

resources
| where type == "microsoft.compute/disks"

Locationwise:

resources
| where type == "microsoft.compute/locations"

To check community gallery resources, execute the below query table.

communitygalleryresources
| where type == "microsoft.compute/locations/communitygalleries"

Output:

enter image description here