Help with Union for two tables

Iron Contributor

I have a basic malware count query as follows:


| 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?



0 Replies