DeviceNetworkEvents
| where Timestamp > ago(1d)
| where ActionType == "ConnectionSuccess"
| where RemoteIPType == "Public"
| where RemotePort !in (80, 443)
| summarize TotalBytesSent = sum(SentBytes), ConnectionCount = count() by DeviceName, RemoteIP, RemotePort, InitiatingProcessFileName, bin(Timestamp, 1h)
| where TotalBytesSent > 104857600
| extend TotalMBSent = round(TotalBytesSent / 1048576.0, 2)
| project Timestamp, DeviceName, InitiatingProcessFileName, RemoteIP, RemotePort, TotalMBSent, ConnectionCount
| sort by TotalMBSent desc