Skip to main content

Posts

Azure Data Explorer - Kusto Query - Get Min/Max Within Each Category Filter

In continuation to my previous post on 'Get Categorial Count' , this time let’s get our hands dirty with one more query related to filter criteria for date time field. Below is the sample data on which we are going to query: GenerationDate IngestionTime DescriptionTitle DescriptionDetail FeedKey 2020-05-21 00:00:00:0000000 2020-05-25 02:00:00:0000000 Schedule Task Read feed from server 1 acbf-uhef-4t5i-dfff 2020-05-21 00:00:00:0000000 2020-05-25 03:00:00:3000000 Schedule Task Read feed from server 1 acbf-uhef-4t5i-dfff 2020-05-21 00:00:00:0000000 2020-05-25 03:00:00:3500000 Schedule Task Read feed from server 1 acbf-uhef-4t5i-dfff 2020-05-21 00:00:00:0000000 2020-05-25 03:00:00:3000000 Monitoring Task Monitoring failed for LOC lcbf-u78f-4

Azure Data Explorer - Kusto Query - Get Categorial Count

I t’s been a while since I started working on data analysis part. When it comes to data analysis, it’s all about how efficiently one can filter and fetch the small set of useful data from humongous collection. I used Kusto Query Language (KQL) for writing advanced queries for Azure Log Analytics. At first, when you will start writing queries, it would be very daunting and keeping that in mind, I thought, I should share a few of those queries which could save huge on the beginner’s time. Hence, my next few posts would be mostly based on how to achieve expected output using KQL . So, let’s get started with a simple scenario first. Below is the sample data on which we are going to query: GenerationDate IngestionTime DescriptionTitle DescriptionDetail FeedKey 2020-05-21 00:00:00:0000000 2020-05-25 02:00:00:0000000 Schedule Task Read feed from server 1 acbf-uhef-4t5i-dfff 2020-0

Excluding Teams from Office Deployment

Recently I received a request from one of my readers on how to tailor Office deployments and to be specific, how to exclude Teams from deployment configuration file. Let’s navigate to https://config.office.com/ from the browser. This is the place from where administrators can manage and deploy office products and subscriptions. You can see that there are two options on the page:  Create a new configuration  Import your configuration Here I am going to create a new configuration, but if you have existing configuration, you can import that too and update it based on your business needs. Once you have entered the Deployment Settings page, there are many options which need to be configured. Architecture Selection Select the architecture for which we are creating a deployment: Office Suite Selection Next is to select the Office Suite: Version Selection Next is to select the version which we want to deploy: