Splunk Search

self join in splunk

abhayneilam
Contributor

Hi,

Can you make me understand how to use a self join using splunk..

A short example will work.

thanks a lot !!

Abhay

Tags (4)

DaveSavage
Builder

Abhay,
....| selfjoin []* gives you a join on the selected field(s). The options are useful (overwrite, max or keepsingle. That allows control over values in the selected fields. Note the default on 'max' vs zero.
There's more at http://docs.splunk.com/Documentation/Splunk/5.0/SearchReference/Selfjoin

The example used is ... | selfjoin id...which may start you off with results. Depends what you are trying to do after that 😉

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!

IT Service Intelligence 5.0 Series: Your Guide to the June Launch

We are excited to announce the June release of Splunk IT Service Intelligence (ITSI) 5.0. This update ...

Agent Mode Engaged! Enchaining Agentic Operations with Splunk AI Assistant 2.0

    Are you ready to transform how your team handles complex data requests? We invite you to our upcoming ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...