March 31, 2023
Microsoft Security

Microsoft 365 Defender: KQL basics

Microsoft Security logo

This tutorial introduces Kusto Query Language (KQL) fundamentals for Advanced Hunting in Microsoft 365 Defender. It starts with the “shape” of a query—select a table, then refine results using the pipe operator—and demonstrates common building blocks like where filters, projecting specific columns, sorting with order by, limiting results with take, and using summarize to aggregate counts. It also covers practical hunting habits: starting broad to explore, then narrowing by time window and key fields to answer a specific investigation question.

We produced this as a friendly on-ramp—paced to teach the essentials without turning it into a syntax marathon. The screen capture stays focused on the query editor and results grid so viewers can connect each line of KQL to the data it produces, and the edit is structured as small wins that build confidence. Final delivery includes closed captions, audio description, and thumbnails.

Microsoft Security logo
Share this video