Splunk Search

Filtering fields using a common field in two different sourcetypes

infotork
Explorer

fields in sourcetype1 --> A,B,C, txid ( always has a value)

fields in sourcetype2--> D,E,F, txid ( may occur value for some sources or may not)

Its clear that i have a common field ( txid) in two different sourcetypes  sourcetype1 and sourcetype2

Requirement:

I need to print  A,B from sourcetype1, in case i didnt find "txid" in  sourcetype2,  

Please help

Labels (5)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

How about

sourcetype=sourcetype1 OR sourcetype=sourcetype2
| stats values(A) as A values(B) as B values(sourcetype) as types by txid
| where mvcount(types)==1 AND isnull(mvfind(types,"sourcetype2"))
| table A B txid

 

0 Karma
Get Updates on the Splunk Community!

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...