I want to query all the builtin Azure role definitions using Search-AzQuery. I have the Az.ResourceGroup module v1.0.0 installed. This query works fine in the Azure Portal's Azure Resource Graph Explorer and returns 5 records: authorizationresources | where type ==…
When I go to the Azure portal to display the resources in the resource group, the list of types would look like: I ran the following Kusto query in the Azure Resource Graph Explorer to obtain the resources in the…
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…
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…
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 the output of this is {"id":"/subscriptions/companysubscriptionid/resourceGroups/companyresourcegroupname/providers/Microsoft.Network/vpnSites/NAMEOFTHEWAN"}] I only…
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…
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": "aaaaaaaaaaaaaaaaaa", "localizedValue": "aaaaaaaaaaaaaa" }…
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…
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…
I'm new to KQL and I'm trying to list all Azure SQL Databases with the word "_old" in their name. My protoquery is this and it works: // Find "_old" Databases Resources | where type =~ 'microsoft.sql/servers/databases' | where *…