Stack Overflow
Stack Overflow

Questions tagged [azure-resource-graph]

The Azure Resource Graph provides the ability to query, explore and analyse the resources that exist within your Azure subscriptions. The Azure Resource Graph Query Language is based on the Kusto query language.

96 questions
3
votes
0 answers

Using Azure Resource Graph from Kusto

Is there a way to access Azure Resource Graph data from Kusto.Explorer? How would I configure the Connection in Kusto.Explorer?
Felix Bodmer
  • 291
  • 2
  • 16
3
votes
3 answers

Restart VMs in scale set in AKS Node Pool

I have a kubernetes cluster with node pools and as a part of Chaos Engineering Initiative,I need to restart the VM. Is there any code for the same using azure resource graph?
Batman22
  • 376
  • 4
  • 25
2
votes
1 answer

How do I find the appropriate app service for my website on Azure?

I have a website that is on Azure. I am trying to find the app service that corresponds to the url. Shockingly I can't just search the url on Azure to find it. So how do I determine which app service this website is on? Please direct me using the…
Joe
  • 212
  • 2
  • 11
2
votes
1 answer

how to dynamically get all nested properties from JSON Array object in Azure KQL

I am trying to get all data disks present on VM from Azure Resource Graph Query. I am able to get specific data disk by specifying the index( for example properties.storageProfile.dataDisks[0].name for first disk) but but how do I get this…
Samer Singh
  • 57
  • 6
1
vote
2 answers

Azure Resource Graph Explorer result is cached?

When I use the "New Query" option on Azure Resource Graph Explorer page, the "Run Query" button is disabled. When I use a sample query it is enabled and works, but when I update the query with any changes, I can run it but it keeps showing the…
Aram
  • 5,537
  • 2
  • 30
  • 41
1
vote
1 answer

Azure Resource Graph Explorer :: list all resourceGroup with subscriptionName

I've created a kusto query that will allow me to have an overview of all resourceGroups: resourcecontainers where type == 'microsoft.resources/subscriptions/resourcegroups' project subscriptionId, resourceGroup, tags.mytag1, tags.mytag2,…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
2 answers

Kusto query that does case-insensitive filter on tag names (keys) instead of values

In our Azure environment we have resources that contain tags that haven't been consistently named with regard to the use of upper and lowercase. Say we have a tag Projectteam. In our environment we would have all kinds of variants of that tag…
LeonZandman
  • 3,054
  • 6
  • 29
  • 26
1
vote
1 answer

KQL :: return only tags with more than 4 records

I have created a Kusto query that allows me to return all our database park. The query only takes 10 lines of code: Resources | join kind=inner ( resourcecontainers | where type == 'microsoft.resources/subscriptions' | project…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
1 answer

Azure Resource Graph Explorer :: query Cost Management API

I have a Kusto query that can help me list a few resources: ResourceContainers | where type=='microsoft.resources/subscriptions/resourcegroups' | project name, type | limit 5 | union (Resources | project name, type | limit 5) I would like to add…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
1 answer

Azure Resource Graph Explorer :: Draw a trendline in the time chart

I was reading this article about how to draw a trendline in the time chart related to the Azure SQL Database consumption. The query is like this: AzureMetrics | where TimeGenerated >= ago(90d) | where Resource == 'MyDB' | where MetricName ==…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
1 answer

Kusto query "Where not equals to any of the elements contained in list"

I have this Kusto query that I use to find untagged resources: // Find_Untagged_Resources resources | join kind=inner ( resourcecontainers | where type == 'microsoft.resources/subscriptions' | project subscriptionId, subscriptionName =…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
1 answer

Azure Data Factory $Skiptoken (for Rest API POST Method) - Workaround?

I am using a Copy Data activity with a Source that is a REST API POST Method using body as a Kusto query. But while using POST method collection only 1000 record showing as a web page limourceitation. [Source][1] [Source Dataset][1] And Sink…
Siddharth
  • 11
  • 2
1
vote
2 answers

Azure resource visualizer API to generate SVG or PNG?

Is there any Azure Rest API to get the Resource visualizer in the SVG or PNG format?
Dadwals
  • 1,171
  • 2
  • 8
  • 15
1
vote
1 answer

Can an Azure multi-tenant daemon app authenticate to both Microsoft Graph and Azure Resource Graph endpoints?

I have a multi-tenant daemon app in Azure that has no problem authenticating to Microsoft Graph APIs, but doesn't have permissions to access the Azure Resource Graph API; specifically the Compute endpoints to list virtual machines. Is it possible to…
RG5
  • 517
  • 1
  • 5
  • 16
1
vote
1 answer

KQL query to get the node count of running Aks clusters in azure

I am new to Kusto. I need an query to get the current node count of all the running Azure kubernetes clusters. I have tried with below but for few clusters it is giving node count 0 where as mode is present on those Resources | where type ==…
Subhajit Podder
  • 11
  • 1
1
2 3 4 5 6 7