Direct Report
Query
Heartbeat
| project Computer , Category
|where Category contains "Direct"
|distinct ComputerExplanation
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.
Details
Rod Trent
Released: March 26, 2020
Tables
Heartbeat
Keywords
HeartbeatComputerCategoryDirect
Operators
projectwherecontainsdistinct