Splunk Search

what are the benefits vs drawback in :: and =

noorani1980
Engager

whats the difference between :: and = in splunk search. what are the benefits vs drawbacks

Labels (1)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

The double colon :: refers to an indexed field so if the field is NOT indexed, it will not find it. 

If you run this search

index=_audit sourcetype=audittrail
| stats count by sourcetype

and then insect the job and look at the search log, you will see something called LISPY

09-29-2023 10:26:38.508 INFO  UnifiedSearch [3846 searchOrchestrator] - base lispy: [ AND index::_audit sourcetype::audittrail ]

where is knows that index and sourcetype are indexed fields and so replaces them with the :: syntax.

So, if you KNOW your field is indexed, then using :: will force Splunk to look at the indexed rather than raw data for the results.

 

Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...