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.
Details
Rod Trent
Released: March 26, 2020
Tables
Heartbeat
Keywords
HeartbeatComputerCategoryScom agent
Operators
projectwherecontainsdistinct