A Community to make the world a better place with KQL | Learn, share and practice the KQL language | #kql #threathunting #security

Joined October 2021
I had the domain for quite some time and the website was already up - but finally it's where I wanted it to be. ◽️Full XDR and Sentinel schema coverage ◽️Documentation of XDRInternal modules by @NathanMcNulty and me ◽️Table column relations (partly) xdrinternals.com/
5
58
2
167
10,206
Two new Advanced Hunting tables will arrive soon. SubmissionEvents and SubmissionResults, to enhance email submission visibility and detection workflows.
17
1
63
7,048
Cc: @stefanschorling @MattiasBorg82 – at Alkmaar, The Netherlands
2
2
85
New Blog: ClickFix: The Gift That Keeps On Giving ClickFix continues to evolve as one of the most effective social engineering techniques for initial access. In this blog, I share research from my @OrangeCon_nl session. 📖 Read the full blog: kqlquery.com/posts/clickfix-…
1
25
3
107
18,372
As response to CVE‑2026‑41615 (Microsoft Authenticator Vulnerability) Microsoft started surfacing the used Microsoft Authenticator App versions in the Microsoft Entra Sign-In Logs. Quick post with a KQL query to identify users with vulnerable versions: tech.nicolonsky.ch/til/authe…
2
9
35
3,786
📢 𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐢𝐧𝐠 𝐭𝐡𝐞 𝐓𝐈𝐅𝐂𝐄 𝐖𝐨𝐫𝐤𝐛𝐨𝐨𝐤 𝐟𝐨𝐫 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐒𝐞𝐧𝐭𝐢𝐧𝐞𝐥! Everyone who knows me knows how passionate I am about the 𝐂𝐲𝐛𝐞𝐫 𝐓𝐡𝐫𝐞𝐚𝐭 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 (𝐂𝐓𝐈) discipline. Back in early 2020, just before the pandemic outbreak, I had the opportunity to travel to Luxembourg for hands-on training on the @MISPProject and later on, attend two @FIRSTdotOrg CTI events in Berlin. Since then, I’ve been fortunate to work on many CTI initiatives, especially during my tenure at Alpha Bank, where my team pioneered in this area within the FSI sector. Over the years, the CTI discipline has significantly matured. With that evolution came frameworks, operational requirements, and the growing challenge of managing multiple intelligence feeds - many of which may not be relevant, actionable, or current enough to effectively protect an organization. Inspired by the TIFCE framework introduced by Sergio Albea, I built the 𝐓𝐈𝐅𝐂𝐄 𝐖𝐨𝐫𝐤𝐛𝐨𝐨𝐤 𝐟𝐨𝐫 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐒𝐞𝐧𝐭𝐢𝐧𝐞𝐥. 🔗 github.com/cyb3rmik3/KQL-thr… The workbook evaluates the four key pillars of the TIFCE framework: ✅ Which feeds provide unique intelligence? ✅ Which feeds are truly relevant to your environment? ✅ Which feeds correlate with confirmed malicious activity? ✅ Which feeds are fresh and actively maintained? If you are using 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐒𝐞𝐧𝐭𝐢𝐧𝐞𝐥 and the 𝐃𝐞𝐟𝐞𝐧𝐝𝐞𝐫 𝐗𝐃𝐑 stack together with multiple 𝐓𝐡𝐫𝐞𝐚𝐭 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 feeds (MDTI, MISP etc), I encourage you to test the workbook and review the findings. Feedback and contributions are always welcome - feel free to open an Issue or submit a PR with enhancements and ideas. I know already that more visuals and some tabs with more info are needed. A huge thank you to my comrade Marios for his contributions, and to MVP brothers Sergio Albea, @BertJanCyber, and Uros Babic for their valuable preview feedback. #MicrosoftSecurity #MicrosoftSentinel #UnifiedSecOps #ThreatIntelligence #CyberThreatIntelligence #KQL #KustoQueryLanguage
3
10
44
3,371
The latest KustoInsights is out! Lots of community blogs have been added in the past month. kustoinsights.substack.com/p…
5
14
1,021
🚀 Join us at KustoCon 2026 in Zürich & online for deep dives into KQL, Defender XDR, threat hunting & AI. 📍 Microsoft Switzerland, The Circle 🎟️ kustocon.com/ #KustoCon #KQL #CyberSecurity
108
☕ KQL Café May 2026 is live! 🎙️ Sergio Albea on smarter Threat Intel feeds: - TIPS scoring model - Match 4 AI selection engine - Claude-powered IOC live-status checks - MISP via Logic Apps + Graph API ▶️ youtu.be/e-mg6XYcCAY #KQLCafe #KQL #ThreatHunting
1
3
273
Today I’m announcing Advanced Threat Hunting & Detection Engineering in the Enterprise. This course is for detection engineers, threat hunters, and security teams who want to build resilient behavioral detections without investing heavily in additional tools or resources. It's also for red teamers who want learn how they are detected. Attackers don’t operate as isolated events. They move across endpoints, identities, and cloud services. They bypass telemetry, steal tokens, abuse legitimate workflows, and blend into normal activity. This course teaches a practical framework to detect that behavior before the damage is done: - Around 20 high-order behavioral detections for Windows and Entra ID attacks - AiTM activity, Entra ID token theft, and stolen token abuse - Full attack-chain labs with realistic false positives - Detection gaps and compensating detections - Vendor-agnostic logic adaptable across tools, clouds, and platforms Detecting majority of the threats at their earliest stages is possible without excessive overhead or cost. I've proved it with this course. academy.bluraven.io/course/a…
24
117
7,662
Dear KustoFans, Tomorrow at 18:00 CEST, @alexverboon and I welcome Laurie Rhodes to KQL Café. No spoilers, but expect hints of KQL experimentation, offline workflows, and graph-based exploration. Join us: meetu.ps/e/PTm3h/M56HB/i
2
5
1,083
Disabling a user account during a security incident removes them from all Microsoft Teams. Private channel membership is not automatically restored. This #KQL query lists all private channels the user was removed from. github.com/lorisAmbrozzo/KQL…
6
8
945
Time for your monthly dose of Kusto! Kusto Insights - October Update is out: open.substack.com/pub/kustoi…
4
10
1,186
📢 New #KQLCafe just dropped on YouTube 🔹 sKaleQL Michals Michalos and Christos Galanopoulos 🔹 Defender hunts Teams messages 🔹 Multi-Tenant Defender is GA 🔹 Detecting malicious PowerShell 🎥 youtu.be/Yna97PlIX18 📝 kqlcafe.com/shownotes/2025/K… #KQL #DefenderXDR
5
20
1,884
🎉 KustoCon 2025 is official! Watch the announcement video and register now for the main event or join us onsite in Zurich for also the hands-on detection engineering workshop! Info & sign-up: kustocon.com/sessions/ #KustoCon #KQL #KustoFans
8
1
18
2,675
Next Tuesday, May 27th Christos Galanopoulos and I will join my dear fellows @alexverboon and @castello_johnny at this month's 𝐊𝐐𝐋 𝐂𝐚𝐟𝐞. Christos Galanopoulos and I worked over the past couple of months on 𝐬𝐊𝐚𝐥𝐞𝐐𝐋, a tool that allows query automation on your log analytics workspace, through GitHub actions. We are going to elaborate how this tool works and provide a couple of examples of how one can benefit from this tool. 📅 Have you registered for next week's 𝐊𝐐𝐋 𝐂𝐚𝐟𝐞? No? Please do so here: meetup.com/kql-cafe/events/3… ⚙️ Have you checked 𝐬𝐊𝐚𝐥𝐞𝐐𝐋? If not, check it out here: github.com/christosgalano/sK… #MicrosoftSecurity #MicrosoftCommunity #KQL #KustoQuery #KQLCafe #sKaleQL #GitHub #GitHubActions
3
1
10
1,144