Splunk Search

How to query for specific string literal field

jaj
Path Finder

I have a filed in my logs "labeDatal" and I also have another field that I trace out called "labelDataSpec"

i.e. log => ".....labelData="whatever1" labelDataSpec="whatever1.1"

How can I run a query that just brings back data for labelData and not labelDataSpec? The following query is bringing back data for labelDataSpec as well (I only want labelData):

source=...labelData| chart count by labelData | sort count | reverse

output example:

labelData count
1 whatever1 15
2 whatever2 100

etc,...

Tags (1)
0 Karma
1 Solution

kristian_kolb
Ultra Champion

Your stats should work like it is - have you verified your data? Anyway, you can remove the field before the stats/chart/timechart/whatever, just to be sure ...

your search | fields - labelDataSpec | chart count by labelData | sort - count 

/K

View solution in original post

kristian_kolb
Ultra Champion

Your stats should work like it is - have you verified your data? Anyway, you can remove the field before the stats/chart/timechart/whatever, just to be sure ...

your search | fields - labelDataSpec | chart count by labelData | sort - count 

/K

Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...