Splunk Search

What are THE most important SPL commands?

woodcock
Esteemed Legend

I get asked some form of this question often and I know what my answer is but I am curious about others. What is your opinion of the top 10 most powerful SPL command that every expert splunk user or wannabe should know well and what is on "off the beaten path that you find occasionally invaluable?

osakachan
Communicator

I am not an expert but these commands are my bread and butter to doing things and accomplish the objectives.

stats , timechart, streamstats, tstats,append, map, transpose, rex, bin, transaction

And as a command is very easy to understand but the power that has all the functions of eval is where the magic happens.

to4kawa
Ultra Champion

Is transaction necessary?

0 Karma

osakachan
Communicator

If you want to have in one event a succession of events evaluated with a beginning or an end with a defined control of span or limit of times, yes. If not *stats are always better 😄

0 Karma

to4kawa
Ultra Champion

makeresults @ Splunk>Answers

I didn't expect to use that much.
It is convenient to create logs freely.

woodcock
Esteemed Legend

Do not forget about windbag and gentimes!

0 Karma

to4kawa
Ultra Champion

I have never used windbag yet.
gentimes is difficult to use.

0 Karma

randy_moore
Path Finder

Agree with the stats family, but not just "use stats" but "how to properly use stats" (to get rid of joins/append and other inefficient statements).

TERM (for faster matching if your data supports it)
IN (reduction of "OR"s and easier readability)

Finally, REX/REGEX. If your data is barely structured (looking at you kubernetes and rancher debug logs) , and you are good at rex/regex, then you can you interrogate the data and bend it to your will.

sduff_splunk
Splunk Employee
Splunk Employee

*stats!

stats, eventstats, streamstats take Splunk from being just a search engine to a tool for in-depth analysis

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!

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...

SPL2 Deep Dives, AppDynamics Integrations, SAML Made Simple and Much More on Splunk ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...