Question 103934 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – Compute Usage in KQL

Usage – List

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.

Tags:

2

Answers


  1. 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

    Login or Signup to reply.
  2. 0

    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

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search