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.
Questions tagged [azure-resource-graph]
96 questions
0
votes
2 answers
Get Azure resources associated with a subnet through Azure Resource Graph Query
I am looking to fetch all resources associated with a subnet. I could find references oh how to do it the other way around (fetch a particular resource and it includes the subnet it is associated with), but can't find any documents where we can…
Godson
- 1
- 1
- 2
0
votes
0 answers
Refreshing Azure Resource Graph queries in Azure workbook frequently gives missing data
I'm writing a Azure Resource Graph query in Azure workbook on Azure portal:
AlertsManagementResources
| where type =~ 'microsoft.alertsmanagement/alerts'
| where properties.essentials.startDateTime > ago(30d)
| where properties.essentials.severity…
0
votes
1 answer
Find unassociate public IP Azure
I'm tryig to find unassociate public IP in my Azure subscription with Azure resource graph explorer.
I was able to find for a NSG but I can't do the same thing with public IP.
Is somebody has an idea about the Query that I can use ?
Thanks,
Makina74
- 45
- 6
0
votes
1 answer
AzureResourceGraph dotnetsdk c# QueryResponse to csv file
I get a QueryResponse.Data returning the following data in table format with two columns "type" and name":
Content: {"columns": [{"name": "type","type": "string"},{"name": "name","type": "string"}],"rows":…
wuz
- 483
- 3
- 16
0
votes
2 answers
Resource Graph query using Azure Function .NET and User managed Identity?
In the example the DotNet-ResourceGraphClient requires ServiceClientCredentials. I do not know how to use a user-assigned-managed-identity directly.
For instance:
var credential = new DefaultAzureCredential(new DefaultAzureCredentialOptions {…
wuz
- 483
- 3
- 16
0
votes
2 answers
Retrieve AzureAD Users sign-in logs Kusto Resource Graph Query
I am trying to get a list of users logged into azure AD, that can be seen under Users | All Users from the azure portal, using Kusto Resource Graph Query but does anybody know how to call this? i understand i can List all sign-ins via http…
user203818
- 43
- 7
0
votes
1 answer
Operation returned an invalid status code 'BadRequest' - Microsoft.Azure.Management.ResourceGraph
Whenever var response line executes it will throw an exception that states
Operation returned an invalid status code 'BadRequest'
The same request that I did in Azure Resource Graph Explorer worked as expected. But for some odd reason, when I do…
MarkCo
- 810
- 2
- 12
- 29
0
votes
3 answers
Create an array from the output of POST request in JSON Object
I'm trying to send an email via Logic App.
The content must be an array of an orphaned resources.
I am using an HTTP request to query the Azure resource graph explorer, on the Output I have a JSON object. I want to transform this JSON Object on an…
Makina74
- 45
- 6
0
votes
1 answer
List comprehension equivalent in Kusto
I recently started to use the Azure Resource Graph Explorer to obtain resource information. KQL is a new thing I'm figuring out along the way, and one of the problems I need help with is a means to manipulate an array of dictionaries into just an…
Teo Nicholas
- 73
- 6
0
votes
1 answer
KQL timechart visualization to show the total number of specific resource over time
I am trying to get a visualization of the total number of specific resource over time in Azure resource graph.
For example, in 2018 total number of application insights were 10, in 2019 total is 20 and so on.
This is the query but it has to…
Renm
- 717
- 3
- 10
- 20
0
votes
1 answer
List all Resource locks within all Resource Groups with Kusto
I am trying to make a query that will allow me to view every Resource Lock within our Resource Groups and I have gotten nowhere with it. I am very new to Kusto and help would be appreciated!
0
votes
1 answer
Print all VM names and private IP from subnet
I want to list all Virtual Machine names that contain a private IP address under a specific subnet (e.g., named "sub-a"). How do I do that?
I was hoping that this query in Azure Resource Graph Explorer would at least print all non empty private IP…
bulkmoustache
- 1,875
- 3
- 20
- 24
0
votes
1 answer
Is there a way to expand key-values in resource properties or tags into their own columns in azure resource graph?
I want to be able to expand the "dynamic" columns in Azure resource graph such that each key/value pair has its own column. Its something that would be nice for resource properties, and resource tags.
So for example this is what i currently get
But…
asts bins
- 43
- 1
- 1
- 6
0
votes
1 answer
How to track SLA of VM availability set (or availability zone) through heartbeats with Log Analytics (KQL)
I want to track the SLAs of our VMs in a Monitor Workbook using a Log Analytics query.
For this, I use the 'Heartbeat' table, which gives the heartbeats of each VM.
However, some of our VMs are in an availability set/zone and as such, the SLA is…
Adriaan
- 23
- 3
0
votes
2 answers
Azure Resource Graph Query - List policy state by subscription name
My goal is to create an Azure dashboard widget with a list of subscriptions with their according policy states.
+-------------------+-------+-----------+--------+---------------+------------+
| Subscription name | Total | Compliant | Exempt |…
mister.elastic
- 389
- 2
- 18