Skip to content

Instantly share code, notes, and snippets.

@alexmags
Last active June 7, 2022 06:03
Show Gist options
  • Save alexmags/0ff30aa740c5d2f77e0509d1fd909f72 to your computer and use it in GitHub Desktop.
Save alexmags/0ff30aa740c5d2f77e0509d1fd909f72 to your computer and use it in GitHub Desktop.
KQL to report on sites used with Internet Explorer. Use with Defender for Endpoint Advanced Hunting https://blog.alexmags.com/posts/internet-explorer-eol-kql/
DeviceNetworkEvents
| where Timestamp > ago(7d)
| where InitiatingProcessFileName =~ 'iexplore.exe'
and RemoteUrl contains ".intranet domain here"
and RemoteUrl !contains "proxy url here"
//and RemoteUrl !contains "other thing to filter out"
// chop off http:// or https://
| extend URLwithoutProtocol=replace_string(replace_string(RemoteUrl, 'http://', ''), 'https://', '')
| extend splitURL=split(URLwithoutProtocol,'/')
| extend domain=tostring(splitURL[0])
| summarize by InitiatingProcessAccountUpn,domain
| summarize count() by domain
| order by count_ desc
//| top 15 by count_
//| render columnchart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment