KQL
Topic
KQL
KQL you can actually run in Microsoft Sentinel and Defender Advanced Hunting, from beginner basics to detections, hunting queries and investigations.
70 posts
KQL
KQL
The Antivirus Setting Your Admins Turned Off Years Ago
All right class. Somewhere in your estate there is a device with C:\ in its Defender exclusion list. Somebody put it there in 2021 to stop
KQL
Fixing the "Excessive Windows Logon Failures" Analytic Rule
Alright class. A close cousin to one of the previous lessons - that rule counted failures in a 10 minute burst. This one takes a whole day
Microsoft Sentinel
The Sentinel Data Lake Got Respecced: What Actually Moved to Fabric
All right class. You moved your firewall logs to the data lake tier because the analytics bill had turned into a monthly argument with finance. You
Microsoft Sentinel
Fixing the "Failed Logon Attempts by Valid Accounts within 10 mins" Analytic Rule
Alright class. On-premises this time, back in the Windows security log. The rule watches event 4625, a failed logon, and fires when a valid account
Microsoft Sentinel
Fixing the "Microsoft Entra ID PowerShell accessing non-Entra ID resources" Analytic Rule
Alright class. Today's rule is "Microsoft Entra ID PowerShell accessing non-Entra ID resources", which alerts when the old Azure AD PowerShell
Microsoft Sentinel
Fixing the "Mass Cloud resource deletions Time Series Anomaly" Analytic Rule
Alright class. Today we are looking at Mass Cloud resource deletions Time Series Anomaly, a content hub rule that promises to catch an adversary tearing down
KQL
Fixing the "Suspicious granting of permissions to an account" Analytic Rule
Alright class. Today's patient is "Suspicious granting of permissions to an account", the content hub rule that promises an alert "when
KQL
Conditional Access, Part Six: Turning Twenty-Five Queries Into an Operating Model
All right class. Five posts, twenty-five queries. If you have been following along, you now have a folder of KQL that describes your Conditional AccessSave your progress
Get the next post by email
One email per post, plus the KQL Vault. That's the whole deal.