Log Analystics Query for VMProcess Stopped

[Gopi K]

Hi, 

I need to setup the alert rule for specific VMProcess is stopped.

Earlier , we used  set the query using ConfigurationChange Table . 

ConfigurationChange
| where ConfigChangeType == "WindowsServices" and SvcState == "Stopped"
| sort by TimeGenerated desc
| where Computer == "PRODWIN1234"
| where SvcDisplayName == "WMI Performance Adapter"

[#2]

You probably only need to look at the last row/record that matches the ServiceName and State

ConfigurationChange
| where ConfigChangeType == "WindowsServices" and SvcState == "Stopped"
| sort by TimeGenerated desc
| where Computer == "PRODWIN1234"
| where SvcDisplayName == "WMI Performance Adapter"
| summarize arg_max(TimeGenerated,*)