Hi everyone, I'm new here :)
I'm wondering if anyone can help me to run this .jason file that turns attacker ip addresses/locations into a map in windows defender workbook?
I'm currently following this tutorial: https://www.youtube.com/watch?v=g5JL2RIbThM and am onto the final stage.
This is the .json script I'm trying to run:
{ "type": 3, "content": { "version": "KqlItem/1.0", "query": "let GeoIPDB_FULL = _GetWatchlist(\"geoip\");\nlet WindowsEvents = SecurityEvent;\nWindowsEvents | where EventID == 4625\n| order by TimeGenerated desc\n| evaluate ipv4_lookup(GeoIPDB_FULL, IpAddress, network)\n| summarize FailureCount = count() by IpAddress, latitude, longitude, cityname, countryname\n| project FailureCount, AttackerIp = IpAddress, latitude, longitude, city = cityname, country = countryname,\nfriendly_location = strcat(cityname, \" (\", countryname, \")\");", "size": 3, "timeContext": { "durationMs": 2592000000 }, "queryType": 0, "resourceType": "microsoft.operationalinsights/workspaces", "visualization": "map", "mapSettings": { "locInfo": "LatLong", "locInfoColumn": "countryname", "latitude": "latitude", "longitude": "longitude", "sizeSettings": "FailureCount", "sizeAggregation": "Sum", "opacity": 0.8, "labelSettings": "friendly_location", "legendMetric": "FailureCount", "legendAggregation": "Sum", "itemColorSettings": { "nodeColorField": "FailureCount", "colorAggregation": "Sum", "type": "heatmap", "heatmapPalette": "greenRed" } } }, "name": "query - 0" }
This is the error message I get when trying to execute the query in the advanced editor:
"No tabular expression statement found"
I have a feeling its not working because Azure workbook has now changed to Microsoft Defender?
Any suggestions/advice/fixes would be much appreciated as I'd really like to get this project finished!
Thank you in advance for your help :)