Try in Splunk Security Cloud


The following analytic identifies a single source IP failing to authenticate into Google Workspace with multiple valid users, potentially indicating a Password Spraying attack. It uses Google Workspace login failure events and calculates the standard deviation for source IPs, applying the 3-sigma rule to detect unusual failed authentication attempts. This activity is significant as it may signal an adversary attempting to gain initial access or elevate privileges. If confirmed malicious, this could lead to unauthorized access, data breaches, or further exploitation within the environment.

  • Type: Anomaly
  • Product: Splunk Enterprise, Splunk Enterprise Security, Splunk Cloud

  • Last Updated: 2024-05-24
  • Author: Bhavin Patel, Splunk
  • ID: bd8097ed-958a-4873-87d9-44f2b4d85705




ID Technique Tactic
T1586 Compromise Accounts Resource Development
T1586.003 Cloud Accounts Resource Development
T1110 Brute Force Credential Access
T1110.003 Password Spraying Credential Access
T1110.004 Credential Stuffing Credential Access
Kill Chain Phase
  • Weaponization
  • Exploitation
  • DE.AE
  • CIS 10
`gws_reports_login` event.type = login = login_failure
| bucket span=5m _time 
| stats  dc(user_name) AS unique_accounts values(user_name) as tried_accounts values(authentication_method) AS authentication_method by _time, src 
| eventstats  avg(unique_accounts) as ip_avg , stdev(unique_accounts) as ip_std by _time 
| eval  upperBound=(ip_avg+ip_std*3) 
| eval  isOutlier=if(unique_accounts > 10 and unique_accounts >= upperBound, 1, 0) 
| where isOutlier =1
| `gcp_unusual_number_of_failed_authentications_from_ip_filter`


The SPL above uses the following Macros:

:information_source: gcp_unusual_number_of_failed_authentications_from_ip_filter is a empty macro by default. It allows the user to filter out any results (false positives) without editing the SPL.

Required fields

List of fields required to use this analytic.

  • _time
  • src
  • event.type
  • user_name

How To Implement

You must install the latest version of Splunk Add-on for Google Workspace from Splunkbase ( which allows Splunk administrators to collect Google Workspace event data in Splunk using Google Workspace APIs. We would also recommend tuning the detection by adjusting the window span and unique_accounts threshold values according to your environment. Specifically, this analytic leverages the User log events.

Known False Positives

No known false positives for this detection. Please review this alert

Associated Analytic Story


Risk Score Impact Confidence Message
54.0 60 90 Unusual number of failed console login attempts (Count: $unique_accounts$) against users from IP Address - $src$

:information_source: The Risk Score is calculated by the following formula: Risk Score = (Impact * Confidence/100). Initial Confidence and Impact is set by the analytic author.


Test Dataset

Replay any dataset to Splunk Enterprise by using our tool or the UI. Alternatively you can replay a dataset into a Splunk Attack Range

source | version: 2