Archive
Highlighted

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
Highlighted

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

SplunkTrust
SplunkTrust

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, an upvote would be appreciated.
0 Karma
Highlighted

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

New Member

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

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

0 Karma