Splunk Search

How to use where to compare field values


Let's say I'm doing a stats count by x,y

How would I formulate a WHERE that compares the string value of x and y and only returns the stats count when there's a difference.

So like stats count by x,y |where x != y

0 Karma


Put the where clause before the stats to reduce the number of events to process.

... | where 'x' != 'y' | stats count by x,y

The single quotes tell Splunk to treat x and y as field names rather than strings.

If this reply helps you, Karma would be appreciated.
0 Karma


@summitsplunk Is your query not working. What are the values in x and y can you give an example.

0 Karma
Get Updates on the Splunk Community!

Index This | A sphere has three, a circle has two, and a point has zero. What is it?

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

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...