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
0
votes
1 answer

Azure resourcechanges missing KeyVault?

I have to get the history of changes of the key in an Azure KeyVault, like updated expiry date via keyUpdate operation, for example. Is there any way to get those changes? Are the KeyVault changes even stored by Azure? Checked the resourcechanges…
user2107244
  • 31
  • 1
  • 4
0
votes
1 answer

create an array of strings from and existing array keys

I have the following column returned from ARG: { "a": { "key1": [ "text1", "text2" ] } "b": { "key2": [ "text1", "text2" ] } } I'm trying to create another column which would…
Ace
  • 831
  • 2
  • 8
  • 28
0
votes
1 answer

trying to get the resources.name joined to advisorresources

Using Azure Resource Graph Queries and a kusto query, trying to get resources.name of the advisorresources properties field in json of resourceMetadata.resourceId, joined on the resource id. Kusto Query advisorresources | extend jProp =…
Νικόλαος Μανωλακος
  • 313
  • 1
  • 9
0
votes
1 answer

How to find Windows version on Virtual Machines through Azure portal

How can I find what windows version is running on my Virtual Machines through Azure portal? We have about 60 resource groups with virtual machines and we are planning to upgrade all Windows server 2012, but first we need an overview of how many…
Gornil
  • 27
  • 4
0
votes
2 answers

Get total number of Azure functions in a subscription

I'm trying to find a query to list total number of Azure functions within a subscription using Azure Resource Graph Explorer. I'm only able to get the total number of Function Apps and not the underlying functions. Is there a way using Graph query?…
user20056090
  • 11
0
votes
1 answer

KQL/Search-AzGraph join operator

I have just begun using AzGraph and I am learning how to use its queries, I am running into an issue when attempting to pull key vault whitelisted IP addresses, below is the query that I am currently running: Search-AzGraph -Query "resources |where…
user2954003
  • 3
  • 2
0
votes
2 answers

KQL get all CVE's in an array

I'm running the following KQL query in Azure Graph Explorer securityresources | where type == "microsoft.security/assessments/subassessments" | extend assessmentKey = extract(".*assessments/(.+?)/.*",1, id) | where assessmentKey ==…
user211245
  • 21
  • 8
0
votes
0 answers

Azure-PowerShell - Search-AzGraph -Query not able to join with $left or $right

I'm looking to create a report on all policies and initiatives in my Azure tenant. To do this, I'm using Search-AzGraph in PowerShell to pull from Azure Resource Graph Explorer. I'm running into an issue when I have a query that needs joined using…
user19700045
  • 11
  • 1
0
votes
1 answer

KQL exclude blank rows from query output

How would I exclude blank rows from the my virtualmachine column in my securityresources | where type == "microsoft.security/assessments" | project id = tostring(id), //DisplayName = properties.displayName, Description =…
dehgrah101
  • 1
  • 1
0
votes
0 answers

KQL Integration with VS Code

I have been working with Azure Resource Graphs to explore resources and security recommendations over a subscription. However, I'd like to generate the Kusto Query Language (KQL) requests from local computer using VS Code. I've been doing some…
Hazem Waddah
  • 11
  • 1
0
votes
1 answer

Azure Resource Graph query

How can I pull all properties for a service that are avaliable to query for? I have a start but I would like to know everything I can list resources | extend type = case( type contains 'microsoft.netapp/netappaccounts', 'NetApp…
user770022
  • 2,899
  • 19
  • 52
  • 79
0
votes
2 answers

Azure resource graph returns null for a config while the same is present in Json view of resource

While running the below query I get null on internalDomainNameSuffix, but the same has value on Json view from the resource page overview. resources | where type == 'microsoft.network/networkinterfaces' and name == 'interface1'| project name,…
Godson
  • 1
  • 1
  • 2
0
votes
1 answer

Azure resource graph query - getting data on VMs

I am new to Azure resource graph query. I would like to use resource graphy query to find out information on virtual machines. Is it possible to create a query to get a list of Virtual machines that have been deleted for a specified period? The…
buddd
  • 1
0
votes
1 answer

How to get list of compute instance size under Azure Machine Learning and Azure Databricks?

Goal here is to query a list of frequently used compute instance size under Azure Machine Learning and Azure Databricks using Azure Resource Graph Explorer from Azure Portal using Kusto query. From the documentation here, there is a list of…
rick
  • 423
  • 6
  • 17
0
votes
1 answer

azure dns record sets through kusto query

I am trying to find some reference for kusto queries for azure. In particular, I would like to find out how to query resources such as dns record sets. I am able, through a trial and error approach to extract for example dns zones, by using the…
Riccardo Mattesini
  • 1
1 2 3 4
5
6 7