Dashboards & Visualizations

How to exclude equal values in different columns

reneedeleon
Engager

How to exclude equal values in different columns to obtain stats with different values only? I want to exclude similarities to list only where the user and sysuser are different.

index=example* stuff
| stats count by user, sysuser

*user **sysuser
Bill Bill
Steve Steve
*Dave Jon
Vince Daniel

Any Ideas?

Tags (1)
0 Karma

kmaron
Motivator
index=example* stuff
| stats count by user, sysuser
| where user!=sysuser
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...