Getting Data In

How to filter out results based on 2 values in an event?

Sparky1
Explorer

I'm trying to use a where command to filter a search based on 2 values in an event.

So something like where host!=Domain Controller1 and Message!="Bad Username"

But doing it this way is filtering any events that match either host or Message. How can I filter results based on 2 field values?

0 Karma
1 Solution

kmaron
Motivator

Try using NOT (host=DomainController1 AND Message="Bad Username")

View solution in original post

kmaron
Motivator

Try using NOT (host=DomainController1 AND Message="Bad Username")

Get Updates on the Splunk Community!

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...