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!

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had 3 releases of new security content via the Enterprise Security ...

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...