Forum Discussion

Jeff Walzer's avatar
Jeff Walzer
Iron Contributor
Jul 30, 2020

Help with Union for two tables

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

No RepliesBe the first to reply

Resources