{"id":47,"date":"2022-08-30T12:51:25","date_gmt":"2022-08-30T12:51:25","guid":{"rendered":"https:\/\/themeger.shop\/wordpress\/katen\/personal-alt\/?p=47"},"modified":"2023-02-04T09:51:32","modified_gmt":"2023-02-04T08:51:32","slug":"how-ways-to-learn-everything-about-construction","status":"publish","type":"post","link":"https:\/\/www.mutlu.ch\/?p=47","title":{"rendered":"Kusto Detective Agency:  A good KQL Introduction"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">KQL stands for &#8220;Kusto Query Language&#8221;, it is a big data analytics query language used by Microsoft to query and process data in Azure Data Explorer, and Log Analytics. KQL is used to analyze and process large volumes of data, and it allows users to search, visualize, and alert on log data and telemetry data stored in Azure. Basically it&#8217;s a good copy of Splunk SPL &#x1f608;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"600\" src=\"https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ.png\" alt=\"\" class=\"wp-image-449\" srcset=\"https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ.png 600w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ-300x300.png 300w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ-150x150.png 150w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ-60x60.png 60w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/1_2eBSzdmZlowi-RJtMG-NeQ-360x360.png 360w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">A caption for the above image.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">KQL, or Kusto Query Language, is a query language used for data analysis and processing. It is used to extract insights and trends from large datasets stored in Azure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">An example of a simple KQL query could be to count the number of log events in a specific time range:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Event\n| where TimeGenerated &gt;= ago(7d)\n| count<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This query retrieves all log events from the past 7 days and calculates the number of events.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another example could be to retrieve top 10 results based on a specific column:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Event\n| top 10 by RequestCount<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This query retrieves the top 10 results based on the highest value of the &#8220;RequestCount&#8221; column.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">KQL provides a simple syntax for querying data and is optimized for large-scale data analysis.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Stat the Challenge<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">if you want to participate to this very challenge and win some cool Credly Badges for your profile  go to : &#x1f449; <a href=\"https:\/\/detective.kusto.io\/\">Kusto Detective Agency<\/a><\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"340\" data-id=\"451\" src=\"https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/2023-02-03-18_19_14-Microsoft-Azure-Data-Explorer-Badges-Credly-and-57-more-pages-Work-Micro-1024x340.png\" alt=\"\" class=\"wp-image-451\" srcset=\"https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/2023-02-03-18_19_14-Microsoft-Azure-Data-Explorer-Badges-Credly-and-57-more-pages-Work-Micro-1024x340.png 1024w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/2023-02-03-18_19_14-Microsoft-Azure-Data-Explorer-Badges-Credly-and-57-more-pages-Work-Micro-300x100.png 300w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/2023-02-03-18_19_14-Microsoft-Azure-Data-Explorer-Badges-Credly-and-57-more-pages-Work-Micro-768x255.png 768w, https:\/\/www.mutlu.ch\/wp-content\/uploads\/2023\/02\/2023-02-03-18_19_14-Microsoft-Azure-Data-Explorer-Badges-Credly-and-57-more-pages-Work-Micro.png 1510w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Go to the inbox to receive the first message  &#8220;<strong>Welcome to the Kusto Detective Agency<\/strong>&#8221; and start the challenge. Follow carefully the procedure to create your Azure Cluster.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Very cool challenge for practicing KQL<\/li>\n\n\n\n<li>The challenge is free<\/li>\n\n\n\n<li>Credly badges<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>KQL stands for &#8220;Kusto Query Language&#8221;, it is a big data analytics query language used by Microsoft to query and process data in Azure Data Explorer, and Log Analytics. KQL is used to analyze and process large volumes of data, and it allows users to search, visualize, and alert on log data and telemetry data [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":450,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"gallery","meta":{"footnotes":""},"categories":[26,25],"tags":[24,23],"class_list":["post-47","post","type-post","status-publish","format-gallery","has-post-thumbnail","hentry","category-kql","category-microsoft","tag-kql","tag-microsoft","post_format-post-format-gallery"],"_links":{"self":[{"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":3,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":457,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=\/wp\/v2\/media\/450"}],"wp:attachment":[{"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mutlu.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}