Splunk Dev

how to set an alert for user failed to login to multiple times on multiple server

New Member

Required a usecase for
** user failed to login to multiple times on multiple server**

0 Karma

New Member

Hi Girish,
please try this one
this is for windowsevent logs

----SPL Query-----
sourcetype="wineventlog:security" EventCode=4625
| eval Account_Name=mvindex(Account_Name,1)
| stats values(ComputerName) as Servers_failing by Account_Name
| where mvcount(Servers_failing)>1

0 Karma


Once you have your failed login events, you can use the stats command to group them by user and count the number of failures. It'll be something like this:

<your search for failed logins> | stats count, dc(machine) as machines by user | where (count > <some number>) AND (machines > 1)
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...