Splunk Search

How to index combination with different event structure?

aa0
Path Finder

Hi all,

I would like to create a table with details involved from two different index created. I'm facing difficulty in combining the data from both two indexes with common columns but different event structure. How to start a query to merge/combine fields from different indexes? As mentioned, both indexes consist of one similar field which is user=john. Here are the details:

 

IndexA

fieldA1=user (john)

fieldA2=description

 

IndexB

fieldB1=user (john)

fieldB2=Workstation

fieldB3=EventCode

 

Expected result:

user| EventCode| description| Workstation

john|      4740     |locked out| Lenovo..

 

could someone point me to the right direction on how to start a Splunk Cloud query to merge into one table?

Many thanks.

Labels (2)
0 Karma

aa0
Path Finder

thanks for your reply, unfortunately I'm actually looking for other query. I've tried this to start so far:

|set union[search index=indexA user=john|fields description user][search index=indexB user=john|fields user EventCode Workstation]

could someone help to expand the search idea or make few tweaks to merge into one table?

Many thanks.

0 Karma

johnhuang
Motivator

Assuming you're using indexA's user description to enrich events from indexB.

 

index IN ("indexA", "indexB") user=john
| eventstats max(description) AS description BY user
| search EventCode=*
| table _time user EventCode description Workstation

 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @aa0,

you have to use teh sats command, something like this:

index=indexA OR index=indexB
| stats values(EventCode) AS EventCode values(description) AS description  values(Workstation) AS Workstation BY user

if you have more values, you can choose to display al the values (as in the above sample) or only the first or only the last (using first or last instead values).

Ciao.

Giuseppe

Tags (1)
0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...