Splunk Search

Displaying unwanted user names on the output

brpsingara
Explorer

Below is my code and I want to display only "Druv" Failed logins. But, I see the user name 'None' , 'Karla' and other few names.

How avoid the unwanted users in the output

index=wineventlog source="WinEventLog:Security" sourcetype=WinEventLog:Security EventCode=4625 where Account_Name=Druv
| stats count by _time, Workstation_Name,Account_Name,dest, dest_nt_domain, product, app, action, EventCode, EventCodeDescription, Failure_Reason, name 
| sort  _time
| where Account_Name!="-"

Thanks in advance

Tags (1)
0 Karma

to4kawa
Ultra Champion
index=wineventlog source="WinEventLog:Security" sourcetype=WinEventLog:Security EventCode=4625 Account_Name="Druv"
 | stats count by _time, Workstation_Name,Account_Name,dest, dest_nt_domain, product, app, action, EventCode, EventCodeDescription, Failure_Reason, name 
 | sort  _time

I exclude where. typo?

0 Karma

brpsingara
Explorer

thank you

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...