Compute Usage in KQL

Question

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.

score 0 · Answer 1 · answered Jan 09 '23 at 17:43

0

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

answered Jan 09 '23 at 17:43

yuxiz

11
1

Thanks for your reply, i cant find that quotaresources in Azure Resource Graph Explorer – harishk Jan 09 '23 at 18:06

score 0 · Answer 2 · answered Jan 10 '23 at 11:09

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"

Or

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

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

Output:

enter image description here

Actually I cant find, In which particular table that Compute usage data available :) — harishk, Jan 10 '23 at 13:45

Compute Usage in KQL

2 Answers2