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.
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.
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
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