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
1 answer
Azure Resource graph explorer Query "Error joining 'microsoft.compute/sqlvirtualmachine' with 'microsoft.compute/disks'
I am new the KQL on Azure resource graph explorer kql queries, I have a requirement to get the SQLVM with associated disk. I wrote this query and getting below error.
Any help is highly appreciated.
Query:
resources
| where type ==…
Shamsul Hassan
- 1
- 1
0
votes
2 answers
Retrieve last string in KQL query output in Azure
I am running an KQL Query in Azure Resource Graph Explorer:
resources
| where type == 'microsoft.network/virtualwans' and tags.CompanyTag =~ 'Company'
| extend WANname = tostring(name)
| extend VPNsite = tostring(properties.vpnSites)
And…
Xyltic
- 113
- 1
- 3
- 14
0
votes
1 answer
get a list of ALL resources types in your Azure tenant
I am trying to use Azure Resource Graph to get ALL resources in my tenant. But for some reson i am not able to get blob, queue, table or files resources in a storage account. I get the storage account it self, but i also would like the child…
Nadia Hansen
- 697
- 2
- 6
- 16
0
votes
1 answer
Trying to query Azure Resource Graph Explorer for NSGs with missing rules
The following query fails with 2 ParserFailure errors, both on line 5. At least that's where the query builder shows the red curly line.
The intention of this query is probably obvious to the Azure KQL initiates, but I'll explain nonetheless just to…
Bobtb
- 26
- 3
0
votes
1 answer
Could not load file or assembly 'Azure.ResourceManager.ResourceGraph
Getting following error: Could not load file or assembly 'Azure.ResourceManager.ResourceGraph, Version=1.0.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8'. The system cannot find the file specified.
Have tried cleaning, removing and…
cjr
- 25
- 6
0
votes
2 answers
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":…
harishk
- 3
- 2
0
votes
1 answer
How to get the role assignments of a resource through Resource Graph API?
I want to use the Azure Resource Graph API to get the role assignments of a resource (who are owners, contributors, etc.). That is, I want to create a query that finds the role assignments for a specific resource id that I provide. I've been going…
Azgu
- 19
- 1
0
votes
1 answer
Azure Resource Graph Explorer :: list all VMs with number of cores
GOAL: I want to list all VMs in our park with the relative number of cores.
In order to do so I found this query :
Resources
| where type=~ 'microsoft.compute/virtualmachines'
| project subscriptionId, name, location, resourceGroup, Capacity =…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
0
votes
1 answer
how to get Azure VM last reboot using azure resource graph
I'm using azure resource graph to create dashboard and need the VM last reboot or Power-Off date.
Need your helps please.
Thank you
Mohamed Jalil
- 23
- 9
0
votes
2 answers
How to schedule exports from Azure Resource Graph and LogAnalytics to a Storage account?
I've created a KQL query for a LogAnalytics Workspace and one for the Azure Resource Graph and now try to get the results scheduled to Synapse Analytics or Azure DataLake Storage Gen2. But from Synapse side I can only create a connection to Data…
Gerrit
- 2,515
- 5
- 38
- 63
0
votes
3 answers
Kusto Query using a bracket with a wildcard
Can you help me identifying what type of wildcard I need to use to find a certain email address in my properties field?
I know that the email I'm looking for is in the slot number 2
How can I find the email address without knowing the slot…
0
votes
1 answer
Azure graph explorer virtual machines instanceviews vmAgentVersion
I'm trying to use azure graph with kusto query to get the agent version of a vm.
With REST API, we can do "/instanceView" to get vmAgent.vmAgentVersion
but with Azure Resource Graph explorer, the instanceView is limited to "PowerState".
I didn't…
kent2004
- 59
- 6
0
votes
1 answer
Azure Resource Graph - get all functions of a function app
I'm new with Azure Resource Graph, and I'm trying to get all the functions from a function app.
Firstly, I created a query to get the function apps :
resources
| where type == 'microsoft.web/sites'
| where properties['kind'] == 'functionapp'
Then I…
MaelleL
- 3
- 2
0
votes
1 answer
How to increase output rows in Resource Graph Query in Azure
I am using Resource Graph Powershell module to query all the recent change details in my Subscription.
https://learn.microsoft.com/en-us/azure/governance/resource-graph/how-to/get-resource-changes?tabs=azure-powershell
But though there are many…
0
votes
1 answer
KQL join query to extract compliance report from resource
I am trying to get left outer join or join with extend or mv-expand on Graph API to list all non-compliant disk with specific path (non-comp reason). In other words, extracting fields from policy and fields from resource…
kpgkondo
- 23
- 3