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

Post a Comment

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
Post a Comment
Read more
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...
Post a Comment
Read more
While loop with head and tail in linux Hi All! In today's post we're going to see/refresh about while loop with head and tail in bash. head - Read the first top 'n' lines. Example: head -n 5 reads first 5 lines from a file or input. tail - Read the last 'n' lines. Example: tail -n 5 reads last 5 lines from a file or input. Please look into the below image we have a txt file called file1.txt which has 3 lines of text and we read using head and tail as above.
Post a Comment
Read more