Query and analyze logs with KQL

تحليل الـ Logs بـ KQL

What you will be able to do

• Read and write Kusto Query Language (KQL) queries in Log Analytics.
• Filter with where and time functions, shape columns with project and extend.
• Aggregate with summarize, count, avg, max, dcount and bin, and visualize with render.
• Know the common Azure Monitor tables and when to use join and union.

What is inside

• How a KQL query is builtالـ KQL query بتتبني إزاي
• Filtering and shaping: where, project, extend, take, topالفلترة والتشكيل: where و project و extend و take و top
• Aggregating and charting: summarize, bin, renderالتجميع والرسم: summarize و bin و render
• Common tables, join and unionالجداول المشهورة و join و union
• Pro: design decisions & best practicesمستوى المحترف: قرارات التصميم وأفضل الممارسات
• Pro: troubleshooting & real-world scenariosمستوى المحترف: حل المشاكل وسيناريوهات من الشغل

It ends with a hands-on lab

• Module lab — Query and analyze logs with KQL

Exam skills it covers

• Query and analyze logs in Azure Monitor