Skip to main content

Azure KQL - project vs project-away

As how development and deployment important, monitoring is also an important thing. so that we can ensure everything works as expected and solve some issues before it makes our services / resources become outage.

Azure has dedicated service for monitoring called "Monitor" which acts as a Log store.

Log Analytics is one of a service which reads logs from azure monitor like-SQL query format which is called here as KQL (Kusto Query Language). This will help us to prepare a chart with required data in monitoring.

This article is not going to talk about deep on Log analytics whereas we are going to have a glimpse of selecting columns / result in following 2 ways.

  1. project - Have only the required columns in the KQL
  2. project-away - Have only the unwanted columns in the KQL
    • This will help us in a scenario like we have 30 columns and we need 20 columns. Instead of specifying 20 required column names, we can specify 10 unwanted columns

please look into the below image for example and your comments are always welcome.

Comments

Popular posts from this blog

View powershell history and invoke Hi All! When you do administration activities, you may need to work around with multiple commands in powershell. It is bit difficul to remember all the commands we tried because some of them may be fetched from internet. Consider you tried more than 100 commands in current powershell session and may require to try the same large command. One of the way is you can press up arrow many times to see the previously tried command. we have another easy way is to see the history and invoke it by using its order number instead of whole command typing. Please look into the below example
Wow! Monitor web apps running in azure VM and VMSS via app insights Hi All! Application insights monitors the telemetry of web applications, function app, APIM and etc., Consider a scenario that your organization has some web applications hosted in IIS of an azure VM and they want to monitor performance of those applications. Azure VM was not the eligible candidate to map with Application insights then how can we monitor app(s) running inside azure VM? Now azure offers the feature of monitoring azure vm's web applications through application insights generally available. Please follow the below steps and have a look into the picture You need to have a connection string of an existing application insights. If have, copy it. Go to the VM which has web apps running in IIS Click "Extension+applications" and then click Add Find Application insights agent for .NET and click next Paste the copied connection string of app insights and click Review+Cre...
Azure Public IP(s) are zone redundant free of cost natively - Generally Available Availability zone gives high availability to an application as well as information by forestalling the physical datacenter disappointments by involving replication of the asset in extra datacenter. Azure typically has 3 zones per region (and not all regions support zone). Thus, while setting up the environment we really want to pick the right region based on our usecase. Public IP helps to access a resource or an application publicly. Azure offers 2 types of SKU for public IP as below Basic Standard Only Standard SKU gives zone facility. Basic SKU is always non-zonal and this SKU also will be retired 09/2025. Standard public IP can be fell into any of the below category No Zone / Non-Zonal - No availability zone at all Zonal - Our services can be replicated in any one of selected zones from three zones. Zone redundant - Resource will be replicated in all 3 zones. It is opposite of...