I have a basic malware count query as follows:
DeviceAlertEvents
| summarize count() by DeviceName, Title, FileName, Category
| sort by count_
How can I use Union to pull the MachineGroup from the DeviceInfo table so I can see what MachineGroup each device is in?
Thx