Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Splunk Search
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: Simple eval + stats count by 2 fields not work...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the_wolverine
Champion
10-12-2012
05:24 PM
What am I doing wrong? I've tried several iterations of the following all which return 2 columns with a count of 0:
sourcetype=a OR sourcetype=b | stats count
count(eval(sourcetype=a)) AS a_count
count(eval(sourcetype=b)) AS b_count
- "sourcetype=a OR sourcetype=b | stats count by sourcetype" <= returns the correct counts but I'm unable to split the count out for further evaluation. I need to be able to eval diff=(b_count-a_count).
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the_wolverine
Champion
10-12-2012
05:33 PM
OMG. I got it to work by changing '=' to '==' and putting the value in quotes! HOW FICKLE!!
sourcetype=a OR sourcetype=b | stats count as Total
count(eval(sourcetype=="a")) AS a_count
count(eval(sourcetype=="b")) AS b_count
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
AFAS
Explorer
08-04-2016
03:06 AM
I was looking for this for days! Thanks the_wolverine
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
shikhanshu
Path Finder
09-15-2014
09:14 PM
Exact same situation and exact same reaction. OMG. 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the_wolverine
Champion
10-12-2012
05:33 PM
OMG. I got it to work by changing '=' to '==' and putting the value in quotes! HOW FICKLE!!
sourcetype=a OR sourcetype=b | stats count as Total
count(eval(sourcetype=="a")) AS a_count
count(eval(sourcetype=="b")) AS b_count
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
cmak
Contributor
02-04-2013
01:34 PM
So glad I found this 🙂
Got questions? Get answers!
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Meet up IRL or virtually!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Get Updates on the Splunk Community!
Meet the .conf26 AI Agent Buildathon Winners
At the .conf26 AI Agent Buildathon, Splunk users turned their operational expertise into working AI agents ...
Trusted Autonomy in the SOC: A Maturity Journey
AI is compressing attacker timelines and pushing SOC teams beyond human capacity thresholds. The next SOC ...
Supercharging Windows Security Detection Performance: Introducing Hybrid Field ...
Windows event logs—from Security auditing and Sysmon to PowerShell script blocks—form the operational backbone ...
