Query Details

Password spray attack against Azure AD application

Azure Active Directory Password Spray Attack Against Azure AD Application

Query

let lookBack = 7d;
let IncTitle = "Password spray attack against Azure AD application";
let AttackerIpAddresses = (
SecurityIncident
| where TimeGenerated > ago(lookBack)
| where Title == IncTitle
| summarize arg_max(TimeGenerated,*) by IncidentNumber
| mv-expand AlertIds
| extend AlertId = tostring(AlertIds)
| join  (SecurityAlert)
on $left. AlertId == $right. SystemAlertId
| mv-expand parse_json(Entities)
| extend EType = tostring((Entities.Type))
| extend AttackIPAddress = tostring(Entities.Address)
| project AttackIPAddress);
AttackerIpAddresses
| join (SigninLogs
| extend city = tostring(LocationDetails.city)
| extend latitude = tostring(parse_json(tostring(LocationDetails.geoCoordinates)).latitude)
| extend longitude = tostring(parse_json(tostring(LocationDetails.geoCoordinates)).longitude)
| project IPAddress, Location, city, UserAgent, ClientAppUsed, AppDisplayName, UserPrincipalName,ResultType, latitude, longitude
)
on $left. AttackIPAddress == $right. IPAddress 
| distinct AttackIPAddress, Location,city

About this query

Password spray attack against Azure AD application

Query Information

MITRE ATT&CK Technique(s)

Technique IDTitleLink
T1110.003Credential Access: Brute Force: Password Sprayinghttps://attack.mitre.org/techniques/T1110/003/

Description

The below query looks at all past Sentinel Incidents for "Password spray attack against Azure AD application" and retrieves the Attackers IP Address, location and other properties.

References

Microsoft Sentinel

Explanation

The query retrieves information about past incidents of a password spray attack against an Azure AD application. It retrieves the attacker's IP address, location, and other properties. The query looks at all past Sentinel Incidents for this specific type of attack and joins the information with the SigninLogs to get additional details about the attack. The result is a list of distinct attacker IP addresses, their locations, and cities.

Details

Alex Verboon profile picture

Alex Verboon

Released: June 8, 2023

Tables

SecurityIncidentSecurityAlertSigninLogs

Keywords

PasswordSprayAttackAzure ADApplicationSentinelIncidentsAttackersIP AddressLocationPropertiesMicrosoftSigninLogscitylatitudelongitudeUserAgentClientAppUsedAppDisplayNameUserPrincipalNameResultType

Operators

letwheresummarizearg_maxbymv-expandextendjoinonparse_jsonprojectdistinct

MITRE Techniques

Actions

GitHub