Help with Union for two tables

Contributor

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

0 Replies