Splunk Search

Correlating fields and printing some fields .

sandeepmakkena
Contributor

Logger 1: has StartId: 1234, and commitCode as 101.
Logger 2: has EndId: 1234(which is same as start ID), WebOrderID: W789, Ccode: 111(which is Commitcode)
Logger 3: has EndID: 1234, sectionID: 4567

I want to display StartID,commitCode from Logger 1, sectionID from Logger3 and WebOrderID and Ccode from Logger 2. I am doing that only for StartIds that meet this condition "fraud-decision.received" "lineItemOverrides" NOT "lineItemOverrides=()" NOT commitCode=null

0 Karma

richgalloway
SplunkTrust
SplunkTrust

This should get you started.

<your search that meets the given condition> 
| stats values(*) as * by StartId 
| table StartId, commitCode, sectionID, WebOrderID, Ccode
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...