Constructing KQL queries to hunt

M365D advanced hunting has two ways of constructing queries, as mentioned in the Understanding advanced hunting section: the more basic Query in builder (guided) and the more advanced Query in editor. Let us start by looking at the builder option, as it might be just what you need to take that next step in advanced hunting:

1. In the Microsoft 365 Defender portal, go to Advanced hunting | + Create new | Query in builder:

Figure 19.1 – Creating a new Query in builder

2. In the builder, we can start by adding the information we want to look for in the different fields:

Image 19.2 – Showing the result of entering just a device name in the query builder

3. From here, we can add more data that is relevant to our case simply by adding it to the corresponding text box.
4. If we want to learn more about Kusto, in the upper right corner of the builder, there is a button...