Heartbeatforscomagent
Query
Heartbeat
| project Computer , Category
|where Category contains "Scom agent"
|distinct Computer//Explanation
This query selects the "Computer" and "Category" columns from the Heartbeat table. It filters the results to only include rows where the "Category" column contains the phrase "Scom agent". Finally, it returns a list of distinct computers from the filtered results.