Microsoft Azure - Using JSON with Azure Logic Apps

Microsoft Azure – Using KQL in Various Methods With Azure Tools

Last Updated : 03 Apr, 2023

Here in this article, you will be learning about various methods of using Kusto queries or KQL queries in different methods to retrieve the resource properties. Before we get into examples, let see what is Kusto Query Language.

Kusto Query Language, also known as KQL. It is an Azure native tool to explore your data and discover patterns, identify anomalies and outliers, create graphs, pie and bar charts for visual representation, and more. KQL is a very powerful tool to explore data and view data in the table format. KQL is easy to learn, and its syntax is very similar to SQL.

Let’s get started with some examples using various azure native tools.

Below are some examples of finding the Count of Azure Key Vault using the Azure native tools like Resource Graph Explorer, Azure CLI cmdlet, and Azure PowerShell cmdlet.

Method 1: Using KQL Find the count of Azure Key Vaults resources using Resource Graph Explorer

Resources
| where type =~ 
'microsoft.keyvault/vaults'
| count

or Single Line Syntax separated by Pipe ‘|’

Resources | where type =~ 
'microsoft.keyvault/vaults' | count

This query returns the count of Azure Key Vaults from the select scope. Refer to the below output.

Output:

Azure Resource Graph Explorer

Method 2: Using Azure CLI Find the Count of Azure Key Vaults using the az graph query cmdlet.

az graph query -q "Resources | 
where type =~ 'microsoft.keyvault
/vaults' | count"

This az command returns the count of Azure Key Vaults. Refer to the below output.

Output:

Method 3: Using Azure PowerShell Finding the count of Azure Key Vaults using the Search-AzGraph cmdlet

Search-AzGraph -Query "Resources 
| where type =~ 'microsoft.keyvault
/vaults' | count"

This Azure PowerShell command returns the count of Azure Key Vaults. Refer to the below output.

Output:

Microsoft Azure - Using JSON with Azure Logic Apps

jaysurya9

Improve

Article Tags :

Similar Reads

Microsoft Azure - Using Azure Key Vaults

To use secure configuration for Azure Functions with Azure Key Vault. You can secure secrets in Azure Key Vault and read them easily in an Azure Function. Azure Key Vault is a cloud service for securely storing and accessing secrets. A secret is anything that you want to tightly control access to, s

Microsoft Azure - Using JSON with Azure Logic Apps

In this article, we will look into how to create JSON Schema that can be used in Azure logic apps. For the sake of example, here one of our goals is to create an Azure logic app that gets triggered by an HTTP request. Now, when we pass our JSON payload over, we want it to be validated. So, let's loo

Microsoft Azure - Using Azure Spring Cloud

Pre-requisite:- Azure VM In this article, we will learn how to get started with Microsoft Azure - Using Azure Spring Cloud. Azure Spring Cloud is a fully managed service that allows developers to build, deploy, and run Spring Boot applications on the Azure platform. It is designed to simplify the pr

Microsoft Azure - Troubleshoot Azure VM Process using KQL

Azure is Microsoftâ€™s cloud platform, just like Google has its Google Cloud and Amazon has its Amazon Web Service or AWS.000. Generally, it is a platform through which we can use Microsoftâ€™s resources. In this article, we will be using the VMProcess Kusto query operator in Azure Monitor to collect th

Microsoft Azure - Using Cost Management in Azure Portal

In this article we will learn how to use cost management to understand your spending in the cloud, so you can do more with less. Cost management is available from any subscription or resource group within the portal. Since starting on the Azure home, the first thing that you want to do is click on t

Microsoft Azure - Deploy Azure Functions using VS Code

In this article, we will learn how to deploy Azure functions with Visual Studio Code. To deploy an Azure function out from within Visual Studio Code, we are going to open the command palette. Now follow the below steps to deploy the Azure function: Step 1: First, we are going to type "deploy functio

Microsoft Azure - Using Azure Monitor Workbooks

In this article, we will learn how to use Azure Monitor workbooks to get insights and visualize your data. Azure Monitor workbooks is a new visualization tool thatâ€™s available in the Azure portal. So, youâ€™re familiar with the Azure portal and Monitor is something thatâ€™s always available and always o

Microsoft Azure - Testing Azure Functions

In this article, we will explore the ways of testing different Azure Functions. This includes, for example, running tests of HTTP trigger functions using Postman and using Microsoft Storage Explorer to test Azure Blob triggers, Queue triggers, and other storage-service-related triggers. Prerequisite

Microsoft Azure - Debugging Azure Functions using VS Code

In this article, we will learn how to debug Azure functions with Visual Studio Code. To start debugging Azure functions inside of Visual Studio Code, all you need to do is start off by creating a breakpoint, and now we'll just engage the debugging session. To do so follow the below steps: Step 1: Fi

Microsoft Azure - Using VS Code for Azure Function Projects

In this article, we will learn how to create an Azure Functions project with Visual Studio Code. Azure Functions is a cloud on-demand service used for getting all the continually updated infrastructure and resources needed to run the applications. Azure Functions provide serverless computing in Azur