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 - how to check availbility percentage of all apps in resource graph explorer?

For every Azure resource in all my subscriptions I need to get the total time resource has been unavailable in a specified timeframe and based on that calculate the percentage of availbility in a given timeframe. I don't want to use the application…
Akip
  • 1
  • 1
0
votes
1 answer

Is there a way to emulate a table in the Azure Resource Explorer reduced version of Kusto?

Question In Kusto, is there a way to select constant values without having a source table; e.g. in a similar way to how we could use the DUAL table in Oracle (or do a SELECT without a FROM in many other query languages)? E.g. () | project colA =…
JohnLBevan
  • 22,735
  • 13
  • 96
  • 178
0
votes
1 answer

Kusto get resourcegroups and subscription information

How can I get resource group name, subscription name and id for all the resource groups? I can get all resourcegroups with Resources| distinct resourceGroup But if I add "id" in there I get same resourcegroup multiple times. Resources | distinct…
Kamsiinov
  • 1,315
  • 2
  • 20
  • 50
0
votes
1 answer

Join two tables in KQL in Azure Resource Graph

I am trying to list all my Azure virtual machines which have a Standard_LRS disk type and I wrote this KQL query in Azure Resource Graph Explorer to get this: resources | where type == "microsoft.compute/virtualmachines" and subscriptionId ==…
esa
  • 87
  • 3
  • 9
0
votes
1 answer

Kusto :: find all SQL Server and the number of databases within each one

I need to find a list of SQL Servers that are good candidates for SQL Elastic Pool. I have this Kusto query but it just list all the databases once: resources | where type == 'microsoft.sql/servers/databases' | summarize TotalDatabases = count() by…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
0
votes
2 answers

How to find both disk size and disk space used in azure

Is there a way to get both disk sizes and disk space used in azure? I can use a query like this and get the percentage or mb used InsightsMetrics | where Origin == "vm.azm.ms" and Namespace == "LogicalDisk" and Name == "FreeSpacePercentage" |…
ProgH
  • 3
  • 3
0
votes
1 answer

Looking for KQL or Powershell or AZ Cli command

How to get a list Azure storage accounts with sas authentication enabled from all my subscription using AZ-CLI / Rsource Graph KQL / PowerShell scipts? az account list --query…
Maheswaran Ramu
  • 11
0
votes
1 answer

How to get a list of resource count per subscription with Azure Resource Graph Explorer query?

I'm trying to get a list of resource count per subscription. This is simple enough and Azure also has documentation on how to do so. Here's my version. resources | join kind=inner ( resourcecontainers | where type ==…
DivZ
  • 678
  • 12
  • 20
0
votes
1 answer

Azure Resource Graph API - Get Resources table via Data Factory

I'm creating a Data Factory pipeline with Web Activity, and that activity is using Azure Resource Graph API to query the resources table. And after I'll use copy data activity to copy the data to blob container. I already created it but the output…
coding
  • 135
  • 2
  • 9
0
votes
1 answer

How to get more than 1000 records using Azure resource graph API

I am trying to get records out using logic app. However due to the graph limit I can only get 1000 records out. What is the best way to get all the records out? . Please see the logic app below:
hello12345678
  • 17
  • 5
0
votes
3 answers

Is there a REST API call to retrieve regions that are zero-waste certified on Azure?

If you go to this website https://datacenters.microsoft.com/globe/explore and you click on "region filters" and "sustainability filters" and you select "zero-waste certified" you can view the regions that are zero-waste certified. I'd like to make a…
Danny van der Kraan
  • 5,344
  • 6
  • 31
  • 41
0
votes
1 answer

Count number of VMs based on Management Group names

I would like to create a Graph QL query or a Powershell script(preferred) that would display the Total number of VMs in all Azure subscriptions along with number of VMs in management groups containing a certain string and count of rest of the VMs…
HereToLearn
  • 11
  • 1
0
votes
0 answers

Azure Graph query -database,owner info from VMs in Azure

ok so i am able to retrieve database owners from each VM using this code snippet: SELECT @@SERVERNAME AS [SQL Server], name AS [Database], SUSR_SNAME(owner_sid) AS [Owner], CAST(CONNECTIONPROPERTY('LOCAL_NET_ADDRESS') AS varchar(15)) AS [IP…
Akeem Rajifuja
  • 15
  • 6
0
votes
1 answer

Azure Resource Graph Query - List policy Compliance State and excluded scope i.e. not scope from policy assignment

My goal is to create an Azure dashboard widget with a Compliance status of policy and also include the count of excludedscope i.e. notscopes from Policy assignment +-------------------+-------+-----------+--------+---------------+------------+ For…
Purnima Jain
  • 3
  • 2
0
votes
1 answer

Azure Logic app - how to use it beyond its subscription

I have created a Logic app (consumption) to query the Microsoft Resource graph for some open alerts, using API. The app is working fine but only listing the result within that subscription . I need the result from all subscriptions- please help me…
Travel free
  • 1
1 2
3
4 5 6 7