KQL Search

Query Details

Direct Report

Query

Heartbeat
| project Computer , Category 
|where Category contains "Direct" 
|distinct Computer

Explanation

This query selects the "Computer" and "Category" columns from the Heartbeat table. It then filters the results to only include rows where the "Category" column contains the word "Direct". Finally, it returns only the unique values in the "Computer" column.