๐ Exciting News and a Giveaway! ๐
Announcing my new course: Advanced Hands-On KQL for Threat Hunting and Detection Engineering! ๐โจ
This course is designed to take you from zero to master, equipping you with cutting-edge skills to stay ahead in the cybersecurity game. Hereโs what you can expect:
๐ Advanced Time Series Anomaly Detection: Discover methods youโve never seen before.
๐ Attack Path & Execution Chain Detection with Process Mining: A novel approach to threat detection.
๐ Attack Pattern Detection Using Graph Semantics: Start thinking in graphs and revolutionize your detection and investigation skills.
And now, the exciting part! ๐ Iโm giving away 1 FREE seat in the course! To enter:
1๏ธโฃ Follow @BluRavenSec
2๏ธโฃ Like and repost this post
3๏ธโฃ Comment why you want to join
academy.bluraven.io/advancedโฆ#KQL#Kusto#SIEM#MicrosoftSentinel#MicrosoftDefender#MicrosoftDefenderXDR#Defender#cybersecurity#KQLForSecurityAnalysts#ThreatHunting#DetectionEngineering#training#dfir#incidentresponse
๐๐ข๐ฆ๐ ๐๐ซ๐๐ฏ๐๐ฅ๐ข๐ง๐ ๐ข๐ง ๐ญ๐ก๐ ๐๐จ๐ ๐ฌ
Did you know you can time travel using #KQL and effortlessly use the ๐ง๐จ๐ฐ() and ๐๐ ๐จ() functions instead of manually typing timestamps everywhere?
The ๐ช๐ฎ๐๐ซ๐ฒ_๐๐๐ญ๐๐ญ๐ข๐ฆ๐๐ฌ๐๐จ๐ฉ๐_๐๐จ๐ฅ๐ฎ๐ฆ๐ง, ๐ช๐ฎ๐๐ซ๐ฒ_๐๐๐ญ๐๐ญ๐ข๐ฆ๐๐ฌ๐๐จ๐ฉ๐_๐ญ๐จ, and ๐ช๐ฎ๐๐ซ๐ฒ_๐ง๐จ๐ฐ commands make time travel possible, allowing hassle-free analysis.ย This capability is incredibly useful for SOC analysts, threat hunters, and detection engineers! ๐
Learn more: academy.bluraven.io/#KQL#Kusto#SIEM#MicrosoftSentinel#MicrosoftDefender#MicrosoftDefenderXDR#Defender#cybersecurity#KQLForSecurityAnalysts#training#dfir#incidentresponse
๐๐ฌ๐ข๐ง๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ข๐ณ๐๐ญ๐ข๐จ๐ง๐ฌ ๐๐จ๐ซ ๐๐๐ฉ๐จ๐ซ๐ญ๐ข๐ง๐ , ๐๐ซ๐ข๐๐ ๐, ๐๐ง๐ ๐๐ก๐ซ๐๐๐ญ ๐๐ฎ๐ง๐ญ๐ข๐ง๐
Did you know you can visualize logs to identify malicious activities? While it may not be a scalable method, it's incredibly useful for triaging and investigating alerts. For instance, you can use geospatial clustering and aggregation to examine suspicious sign-in activities. Additionally, inverting charts can make rare/suspicious sign-in activities more visible.
Learn how to master these techniques hands-on with real data in a hyper-realistic environment
๐ academy.bluraven.io/hands-onโฆ#KQL#Kusto#SIEM#ThreatHunting#MicrosoftSentinel#MicrosoftDefender#Cybersecurity#KQLForSecurityAnalysts#Training#DFIR#IncidentResponse
Part 3 of breaking down my "๐๐๐ง๐๐ฌ-๐๐ง ๐๐ฎ๐ฌ๐ญ๐จ ๐๐ฎ๐๐ซ๐ฒ ๐๐๐ง๐ ๐ฎ๐๐ ๐ (๐๐๐) ๐๐จ๐ซ ๐๐๐๐ฎ๐ซ๐ข๐ญ๐ฒ ๐๐ง๐๐ฅ๐ฒ๐ฌ๐ญ๐ฌ" course๐
๐๐๐๐ซ๐๐ก๐ข๐ง๐ ๐๐ง๐ ๐ ๐ข๐ฅ๐ญ๐๐ซ๐ข๐ง๐ ๐๐๐ญ๐
In this section, we'll focus on the basics of searching and filtering data in KQL.
โ We'll learn about the ๐ฌ๐๐๐ซ๐๐ก operator to help us quickly locate data and the ๐ฐ๐ก๐๐ซ๐ operator to filter results based on specific conditions (๐ฌ๐๐๐ซ๐๐ก is an awesome operator if you know how to use it effectively).
โ We'll learn scalar operators that are commonly used with the ๐ฐ๐ก๐๐ซ๐ operator for security analysis (do you know the difference between ๐ก๐๐ฌ and ๐๐จ๐ง๐ญ๐๐ข๐ง๐ฌ operators and why you should prefer the ๐ก๐๐ฌ operator?).
โ Also, we'll learn how to work with IP addresses, file paths, and regular expressions effectively.
By the end, we'll have a good grasp on how to find and narrow down the data we're looking for!
academy.bluraven.io/hands-onโฆ#KQL#SIEM#MSsentinel#MicrosoftDefender#XDR#Defender#cybersecurity#KQLForSecurityAnalysts#training
Part 2 of breaking down my "Hands-On Kusto Query Language (KQL) for Security Analysts" course๐
#KQL Fundamentals and Exploring Data
In this section, I explain the foundational concepts of the Kusto Query Language. I kick off with an introduction to KQL statements, followed by an exploration of the pivotal role of the pipe in KQL, which allows for sequential data processing.
Subsequently, we'll examine the structure of KQL queries and familiarize ourselves with the various data types in KQL (Tip: the integers you see in the query results may not be integers).
When we just start using data, many of us don't know the structure of the logs (where information is stored and how). Therefore, we'll wrap up by introducing basic techniques for familiarizing ourselves with the data. If you don't know your data source, how are you going to leverage it?
By the end of this section, you will have a solid grasp of the basic components of KQL, setting the stage for efficient searching and filtering querying techniques.
academy.bluraven.io/hands-onโฆ#KQL#SIEM#MSsentinel#Defender#cybersecurity#KQLForSecurityAnalysts#training
In the coming days, I'll be breaking down my "Hands-On Kusto Query Language (KQL) for Security Analysts" course section by section to provide some details and answer potential questions. ๐
First up: Introduction to Databases and Logging.
This section is perfect for those who are new to SIEM/XDR products like MS Sentinel and Defender. It covers what a columnar storage-based database is, its importance for analysis, how logs are stored and indexed, and why these products are like a massive Excel worksheet.
academy.bluraven.io/hands-onโฆ#KQL#SIEM#MSsentinel#Defender#cybersecurity#KQLForSecurityAnalysts#training