This will speed up a LOT of investigative efforts, I imagine. Awesome stuff to see from MSFT!
This will speed up a LOT of investigative efforts, I imagine. Awesome stuff to see from MSFT!
EmailEvents
| where geo_info_from_ip_address(SenderIPv4) != ""
| extend GeoIPInfo = geo_info_from_ip_address(SenderIPv4)
| extend country = tostring(parse_json(GeoIPInfo).country)
| project country
| summarize count()by country
EmailEvents
| where geo_info_from_ip_address(SenderIPv4) != ""
| extend GeoIPInfo = geo_info_from_ip_address(SenderIPv4)
| extend country = tostring(parse_json(GeoIPInfo).country)
| project country
| summarize count()by country